Prerequisites for Connecting to Oracle Analytics Cloud

This article describes how to configure an OAuth application for establishing connectivity to Oracle Analytics Cloud with Metric Insights. Both Client credential and OAuth require to follow the same instructions. Additionally, the article explains how to enable embedding.

NOTE:

The following roles must be enabled for the user:

Prior to v7.2.0:

  • BI Service Administrator;
  • DV Content Author.

v7.2.0+:

  • DV Content Author;
  • BI Service Administrator - only if extendedTestConnection=true

1. Access Domains

Access Oracle Analytic Cloud

  1. Access Navigation menu;
  2. Select Identity & Security;
  3. Select Domains.

2. Access Required Domain

  1. Select the required Compartment form the drop-down;
  2. Access the required domain;
  3. Access Integrated applications;
  4. [Add application]

3. Launch Add Application Workflow

  1. Select Confidential Application;
  2. [Launch workflow]

4. Provide Application Name

  1. Name: provide a descriptive phrase;
  2. [Next]

5. Configure OAuth Settings

  1. Client configuration: set to "Configure this application as a client now";
  2. Authorization: activate the required grant types:
    • Resource owner;
    • Client credentials;
    • Refresh token;
    • Authorization code.
  3. Redirect URL: provide the redirect URL for getting OAuth token in the following format:
    • <hostname>/editor/service/validateoracleanalyticsoauth
  4. Client IP address: set to "Anywhere".

5.1. Add Scope

  1. Authorized resources: set to "Specific";
  2. Activate Add resources;
  3. [Add scope]
  4. Choose the ANALYTICSINST instance;
  5. [Add]
  6. [Next] and [Finish]

6. Activate Application

[Activate] and confirm your consent.

7. Locate Client ID/Secret

On the application overview page, under General Information, locate Client ID and Client secret.

8. Locate Scope

On the application overview page, under Token issuance policy, locate the application Scope.

9. Locate IDCS Instance

Under Identity & Security > Domains > Your current domain, locate Domain URL that will be used in MI for the IDCS Instance field.

10. Enable Embedding

For security reasons, external content cannot be added to reports, reports cannot be embedded in other applications, and connections to certain data sources are restricted unless explicitly approved by an Oracle Analytics Cloud (OAC) administrator.

Only administrators can designate trusted domains. To register a safe domain:

  1. In Oracle Analytics, open the Navigator and select Console.
  2. Go to Safe Domains.
  3. Click Add Domain and enter the domain name in the following format: <hostname>.metricinsights.com.
  4. Enable Allow Frames and Embedding.