cancel
Showing results for 
Search instead for 
Did you mean: 
Get Started Discussions
Start your journey with Databricks by joining discussions on getting started guides, tutorials, and introductory topics. Connect with beginners and experts alike to kickstart your Databricks experience.
cancel
Showing results for 
Search instead for 
Did you mean: 

How to connect to Databricks from Oracle Analytics Cloud

ihrushi
New Contributor

How to connect to Databricks from #Oracle Analytics Cloud (#OAC)? It is not listed as a validated BI tool on Databricks documentation. Is JDBC tested with Oracle Analytics Cloud ? Is there any other way or 3rd party connector for Oracle Analytics Cloud ?

2 REPLIES 2

Prabakar
Esteemed Contributor III
Esteemed Contributor III

To connect to Databricks from Oracle Analytics Cloud (OAC), you can use the Databricks JDBC driver. Although Oracle Analytics Cloud is not listed as a validated BI tool on Databricks documentation, you can still use the JDBC driver to connect to Databricks.

The Databricks JDBC driver is compatible with any BI tool that supports JDBC connectivity. You can download the Databricks JDBC driver from the JDBC Drivers Download – Databricks

To configure the JDBC driver in OAC, you can follow the instructions provided in the Oracle Analytics Cloud documentation for connecting to a JDBC data source. You will need to provide the JDBC connection URL, which has the following general form:

jdbc:databricks://<Server Hostname>:443;HttpPath=<Http Path>[;property=value[;property=value]]

You can find more information about building the JDBC connection URL in the Databricks documentation.

If you encounter any issues while configuring the JDBC driver in OAC, you can refer to the troubleshooting section in the Databricks documentation or contact Databricks support for assistance.

There are no third-party connectors available for Oracle Analytics Cloud specifically, but you can use the Databricks JDBC driver to connect to Databricks from any BI tool that supports JDBC connectivity.

Anonymous
Not applicable

Hi @ihrushi 

Thank you for posting your question in our community! We are happy to assist you.

To help us provide you with the most accurate information, could you please take a moment to review the responses and select the one that best answers your question?

This will also help other community members who may have similar questions in the future. Thank you for your participation and let us know if you need any further assistance!