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.
- Open the Oracle Cloud Infrastructure Console's Data Flow SQL Endpoint Details page.
- Under Connect, click Drivers.
- 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.
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