Connect to a Remote Databricks Data Source

In Oracle Analytics, you can connect to a remote Databricks data source.

Oracle Analytics requires that remote connectivity is enabled and that Data Gateway is installed on the system hosting your Databricks data source. In addition, Data Gateway must be configured with a Databricks driver. See Configure Remote Data Connectivity for a Databricks Data Source.

1. On the Oracle Analytics Home page, click Create, and then click Connection.
2. Click Databricks.
3. In Connection Name, enter a user-friendly display name.
4. In Connection Type, select Basic or Advanced, depending on your requirements.
   • Basic - Provide target data source details as Host, Port, and Http Path.
   • Advanced - Provide target data source details as a string in Connection String.
   To obtain the connection details, refer to the JDBC/ODBC tab for a Databricks cluster, or the Connection Details tab for a Databricks SQL warehouse.
   • For Host, copy in the hostname for your Databricks data source. For example,

     adb-1234567890.1.azuredatabricks.net.

   • For Port, copy in the port number for your Databricks data source. For example, 443.
   • For Http Path, copy in the Http Path value for your Databricks data source. For example,

     /sql/1.0/warehouses/a1234567890b1234567890a.

   • For Connection String, specify a JDBC connection URL in the format:

     jdbc:databricks://<server-hostname>:443;httpPath=<http-path>[;<setting1>=<value1>;<setting2>=<value2>;<settingN>=<valueN>]

     For example:

     jdbc:databricks://adb-1234567890.1.azuredatabricks.net:443;HttpPath=/sql/1.0/warehouses/a1234567890b1234567890a

5. For Username and Password, enter user credentials with access to the Databricks data source.
6. In Driver Class Name (read-only), you can view the full path of the driver being used.

   Note:

   The Use Remote Data Connectivity option is selected by default and greyed out because you can't use this connection type with local data sources.
7. Click Save.