Prerequisites for Creating a Connection

You must satisfy the following prerequisites to create a connection with the Databricks Adapter.

Obtain the Host Name, HTTP Path, Port, and Catalog

  1. Sign in to Databricks.

    The Databricks homepage appears.

  2. In the SQL menu that appears on the left-hand side of the home page, select SQL Warehouses.
  3. Select your SQL warehouse.
  4. Go to the Connection details section.
  5. Copy the values for the server host name, HTTP path, and JDBC URL.
  6. Copy the port number (443) from the JDBC URL.
  7. Click Create Personal Access Token.

    The Access Token page appears.

  8. Click Generate New Token.
  9. Enter the name and lifetime (in days).
  10. Click Generate.

    A new access token is created.

    Note:

    This token is displayed only once for security purposes. Copy the value and save it for reference.
  11. Go to SQL Menu and select SQL Editor.
  12. From the Catalog list that appears, select the catalog with which you want the adapter to connect.

    Note:

    You can create a new catalog. One catalog is created by default. You need these values when creating a connection in Oracle Integration.

Add JDBC Driver JAR to the Connectivity Agent Directory

  1. Download the Databricks JDBC driver from the following location:

    https://databricks-bi-artifacts.s3.us-east-2.amazonaws.com/simbaspark-drivers/jdbc/2.7.1/DatabricksJDBC42-2.7.1.1004.zip

  2. Extract the downloaded ZIP file and copy the Databricks JDBC driver JAR file to the following directory on the connectivity agent host: 
    agenthome/thirdparty/lib
  3. Restart the agent. See Restart the Connectivity Agent in Using Integrations in Oracle Integration 3.