1

I've read: How do you connect to a MySQL database using Oracle SQL Developer?

I want to connect to my Databricks SQL Warehouse using Oracle SQL developer. So I:

  • went to "Oracle SQL Developper > Tools > Preferences... > Database > Third Party JDBC Drivers > Add Entry..." and selected the Databricks JDBC Driver jar I downloaded.
  • repeated the process for the MySQL JDBC driver jar. enter image description here
  • Now when I create a "New Connection", I see MySQL and Oracle as options in the "Database Type" combo-box, but no Databricks.

enter image description here

I'm also able to use the same Databricks JDBC Driver file in DBeaver and connect successfully.

Am I missing some step?

Improve this question

1 Answer 1

Reset to default
2

It's not supported. I wish I had a better answer, but we hard-code the list of allowed JDBC drivers we support. And they match the list of databases our 'Migrate to Oracle' code path have been tested for.

Not enough Databricks customers are asking us to help them migrate to Oracle, yet.

Improve this answer
Sign up to request clarification or add additional context in comments.

4 Comments

Looking at your title I'll just accept this answer. :-). I suspect no one will ever ask Oracle to support migration from Databricks/Spark to Oracle (unless they had no idea what Databricks was and started using it). As they serve completely different functions.
exactly @Kashyap so that's why there's no support there, doesn't make sense
well, for someone who's familiar with the SQL Developer GUI, it would be good to be able to connect to Databricks using SQL Developer instead of learning a new tool like DBeaver/... I.e. use SQL Developer as a simple JDBC client. It is the standard JDBC driver/protocol so I would guess the reason to not support it would be non-technical.
@Kashyap correct - it's not our intent to provide a tool for just any ole database/data source - it's made to be best-of-breed specifically for Oracle DB (and also TimesTen in-memory db)

Your Answer

By clicking “Post Your Answer”, you agree to our terms of service and acknowledge you have read our privacy policy.

Start asking to get answers

Find the answer to your question by asking.

Ask question

Explore related questions

See similar questions with these tags.