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.

NOTE:

The following roles must be enabled for the user:

  • BI Service Administrator;
  • DV Content Author.

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.