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.
