cancel
Showing results for 
Search instead for 
Did you mean: 

How to connect to Databricks DB using JDBC and extract records using SAP Cloud Integration

varun_kasireddy
Explorer
0 Kudos
1,090

Hi Team,

Please suggest how to connect to Databricks DB for JDBC connection using SAP Cloud Integration.

 I have check there is no option to upload databricks drivers under Manage Security -> JDBC Material -> JDBC Driver. I found only below Database types

1. Oracle

2. DB2

3. Microsoft SQL Server

I want to make a connection to databricks sql using JDBC connection

Sample URL:

jdbc:databricks://<hostname>.18.azuredatabricks.net:443/default;transportMode=http;ssl=1;AuthMech=3;httpPath=/sql/1.0/warehouses/12345;

Thanks,
Varun

Accepted Solutions (0)

Answers (1)

Answers (1)

0 Kudos

Hi Colleagues,
At the moment there is no support of Databricks in Cloud Integrations.
Refer to https://help.sap.com/docs/cloud-integration/sap-cloud-integration/configure-jdbc-drivers.

It would be possible in Edge Integration Cell as soon as support of generic JDBC drivers will be there, refer to the roadmap: https://roadmaps.sap.com/board?range=CURRENT-LAST&PRODUCT=000D3A47875C1EDB98A8A910864AC24B&q=jdbc#Q3...

 

I did not find any requests on Influence portal as well, so consider creating such request if needed:
https://influence.sap.com/sap/ino/#/campaign/2282

 

Best wishes, Stan.

Ram30
Explorer
0 Kudos
Thank you 🙂