Connecting to a Data Flow SQL Endpoint

You need a JDBC or ODBC driver and one of token or API key authentication to connect to a Data Flow SQL Endpoint.

Follow these steps to connect to a Data Flow SQL Endpoint:

Download the JDBC or ODBC driver

To connect to a SQL Endpoint requires a JDBC or ODBC driver.

  1. Open the Oracle Cloud Infrastructure Console's Data Flow SQL Endpoint Details page.
  2. Under Connect, click Drivers.
  3. Under JDBC, click Download JDBC driver.

Authenticate the Connection

Use token or API key authentication to connect to a Data Flow SQL Endpoint.

The connection uses SSL as the default. It encrypts data in-transit.

Token Authentication

Use token authentication to connect to a Data Flow SQL Endpoint.

  1. Use a token by not specifying any profile in the URL if you don't have DEFAULT profile.
    For example:
    jdbc:spark:<endpoint-url>.interactive.dataflowclusters.us-phoenix-1.oci.oraclecloud.com/default;SparkServerType=DFI
    The URL opens a browser window.
  2. Sign in to the tenancy where the Data Flow SQL Endpoint is found.

API Key Authentication

Use API key authentication to connect to a Data Flow SQL Endpoint.

Use API key by specifying the OCI Profile with ociProfile=<profile name> in the connection URL. For example, to use OCI Profile name Demo:
jdbc:spark:<endpoint-url>.interactive.dataflowclusters.us-phoenix-1.oci.oraclecloud.com/default;SparkServerType=DFI;ociProfile=Demo