topic Re: How to connect to Databricks from Oracle Analytics Cloud in Get Started Discussions

How to connect to Databricks from Oracle Analytics Cloud

ihrushi — Fri, 07 Jul 2023 12:26:03 GMT

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 ?

Re: How to connect to Databricks from Oracle Analytics Cloud

Prabakar — Fri, 07 Jul 2023 22:30:05 GMT

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.

Re: How to connect to Databricks from Oracle Analytics Cloud

Anonymous — Wed, 12 Jul 2023 09:09:07 GMT

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!

Re: How to connect to Databricks from Oracle Analytics Cloud

BenjaminArnulf — Mon, 21 Oct 2024 21:19:39 GMT

Hi, the DataBricks connector has been added to the Oracle Analytics Product Roadmap!

You can find more information in the Oracle Analytics Community and ask questions.