1. User’s Guide for Oracle Analytics Desktop
  2. Connect to Data Sources
  3. Connect to a Remote Databricks Data Source
  4. Configure Remote Data Connectivity for a Databricks Data Source

Configure Remote Data Connectivity for a Databricks Data Source

In Oracle Analytics, you can connect to a remote Databricks data source using Data Gateway. Before workbook creators connect to the Databricks data source, you must configure your Data Gateway installation to support Databricks.

You supply your own Databricks JDBC driver. Oracle doesn't manage the license or usage compliance for Databricks drivers. Make sure that you fully test data sources and database features before deployment to production.
  1. Download the latest Databricks JDBC driver JAR file from the Databricks website.
  2. In each Data Gateway installation that you have, navigate to the \<Data Gateway installation>\ folder and copy in the JAR file.
    • In a server deployment, copy the JAR file into: <Data Gateway install_location>/domain/jettybase/thirdpartyDrivers
    • In a personal deployment on Windows, copy the JAR file into: <Data Gateway_extract_path>\thirdpartyDrivers
    • In a personal deployment on MacOS, copy the JAR file into: <Application->Show Package Contents>Resources->app.nw-> thirdpartyDrivers
  3. Restart the Data Gateway agent.
You can now use the Databricks connection type to connect to your data source. See Connect to a Remote Databricks Data Source.