Create a Connection to Your OCI Tenancy

Create a connection to your OCI tenancy 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 can connect to an OCI tenancy using an API key or a resource principal.
  • Using an API key enables you to connect to OCI without having to log into Oracle Analytics as a user with BI Service Administrator privileges. However, you need to know the OCID details for the tenancy you're connecting to, and you have to generate a Public API key to register in OCI. To use this method, start with Step 1.
  • Using a resource principal enables an OCI administrator to provision the Oracle Analytics to have the permissions on the OCI services without having to generate a Public API key to register in OCI. However, because the Resource Principal connection has administrator-level permissions, to select this option you must be logged into Oracle Analytics as a user with BI Service Administrator privileges. To use this method, start with Step 2.
  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 resource 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 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 API key, wait a few seconds before saving the connection to avoid this error: "Failed to save the connection. Invalid connection parameters specified".