Kashyap
Reputation: 17476
Connect to Databricks SQL Warehouse using Oracle SQL Developer, with JDBC driver
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.
- Now when I create a "New Connection", I see MySQL and Oracle as options in the "Database Type" combo-box, but no Databricks.
I'm also able to use the same Databricks JDBC Driver file in DBeaver and connect successfully.
Am I missing some step?
Upvotes: 1
Views: 795
Answers (1)
thatjeffsmith
Reputation: 22457
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.
Upvotes: 2
Related Questions
- How to Connect to Databricks Delta table using JDBC driver
- New Databricks JDBC driver version doesn't recognize JDBC URL
- Connect to databricks sql using spark and databricks jdbc
- How to connect to an Oracle database with JDBC
- JDBC connection from Databricks to SQL server
- Getting error on connecting to a local SQL Server database to databricks via JDBC connection
- Not able to connect to Azure database for MySQL server from databricks cluster using jdbc and spark connector
- Connectivity to Oracle from Databricks
- Connect to an Oracle DB with sqldeveloper
- How do you connect to a MySQL database using Oracle SQL Developer?