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.
Oracle Analytics requires that remote connectivity is enabled and that Data Gateway is installed on the system hosting your Databricks data source. See Connect to On-premises Data Sources Using Data Gateway.
  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.