In Oracle Analytics, you can connect to a remote 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.