1. Visualizing Data in Oracle Analytics Server
  2. Visualize Data
  3. Connect to Data Sources
  4. Connect to OCI Data Flow SQL Endpoints
  5. Create a Connection to OCI Data Flow SQL Endpoints

Create a Connection to OCI Data Flow SQL Endpoints

You can create a connection to a OCI Data Flow SQL Endpoints and use the connection to visualize data.

Before you start, in OCI Console download a JSON file containing connection details for the OCI tenancy where the OCI data flow is located. See Download JDBC Connection Details for Data Flow SQL Endpoints to a JSON File. In addition, copy an API Key from the User Tenancy area (in a Privacy Enhanced Mail (PEM) file).
  1. On the Oracle Analytics Home page, click Create, and then click Connection.
  2. Click OCI Data Flow.
  3. In Connection Name, specify a user-friendly name to identify the connection in Oracle Analytics.
  4. In Connection Details, click Select, navigate to your JDBC connection JSON file that you downloaded, then click Open.
    Oracle Analytics uses the JSON file to populate the Host, Database, User OCID, Tenancy OCID, and Region fields.
  5. In Private API Key, click Select, navigate to your PEM file containing the API Key, then click Open.
    Oracle Analytics uses the PEM file to populate the API Key Fingerprint field.
  6. Click Save.
You're now ready to create a workbook and start visualizing your data. For example, from the Home page, click Create, then click Dataset, then select the connection that you just created and create a workbook.