1. Visualizing Data in Oracle Analytics Server
  2. Reference
  3. Data Preparation Reference
  4. Create a Connection to Your Oracle Cloud Infrastructure Tenancy

Create a Connection to Your Oracle Cloud Infrastructure Tenancy

In Oracle Analytics, you create a connection to Oracle Cloud Infrastructure (OCI) so that you can integrate Oracle Analytics with OCI functions, OCI Vision, OCI Data Science, or OCI Language. For example, you might register a language conversion function hosted in OCI so that you can convert English text into Spanish or German using an Oracle Analytics data flow.

You connect to an OCI tenancy using an API key.
  1. In OCI Console, navigate to the OCI tenancy profile, and copy the Region, Tenancy OCID, and User OCID.
    • For Region, review the geographical region displayed at the top of the profile.
    • For Tenancy OCID, click the Tenancy name, and copy the OCID.
    • For User OCID, click User Settings, and copy the OCID.
  2. In Oracle Analytics, on the Home page, click Create, then click Connection.
  3. At the Select Connection Type dialog, click OCI Resource.
  4. For Connection Name, specify a user-friendly name to identify this connection in Oracle Analytics.
  5. To connect using an API key:
    • For Connect Using, select API Key.
    • For Tenancy OCID, paste in the tenancy OCID that you copied in step 1.
    • For Default Region, select the region in which your OCI tenancy is located.
    • For User OCID, paste in the user OCID that you copied in step 1.
    • For Public API Key, click Generate, then click Copy.
    • In your OCI tenancy, paste the API key into the API Keys page under User Settings and click Add.
  6. To connect using a resource principal:
    • For Connect Using, select Resource Principal.
    • For Default Region, select the region in which your OCI resource is located.
    • For Compartment, click Select and select the OCI compartment that you're connecting to.
    • For Services, select the OCI services that the connection will be used for. To select services, you must be logged into Oracle Analytics as a user with BI Service Administrator privileges.
  7. In Oracle Analytics, in the Create Connection dialog, click Save.
    If you're connecting using an API key, wait a few seconds before saving the connection to avoid this error: "Failed to save the connection. Invalid connection parameters specified".