Prepare Oracle Analytics Cloud

Provision Oracle Analytics Cloud and use a remote data gateway (RDG) to connect to Oracle Autonomous Data Warehouse.

Provision Oracle Analytics Cloud

Provision an instance of Oracle Analytics Cloud in the Oracle Cloud Infrastructure service console.

  1. Sign in to your Oracle Cloud account as a federated user with your single sign-on (SSO) credentials).
  2. Click the navigation menu in the top left corner, select Analytics, then select Analytics Cloud.
  3. Click Create instance.
  4. From the Compartment list, select the compartment in which you want to create the service
  5. Enter an Instance Name and a brief description.
    The name must start with a letter and can contain only letters and numbers.
  6. Select Enterprise Analytics as the feature set.
  7. For production services, select the number of OCPUs you want to deploy (between 2 and 52). If you want to create an instance for trial purposes, you can select 1 OCPU.
  8. For License Type, select whether you want to use your Oracle Middleware on-premises license with Oracle Analytics Cloud and be charged the Bring Your Own License (BYOL) rate or subscribe to a new Oracle Cloud license for Oracle Analytics Cloud.
  9. Verify that the details are correct, and click Create.

    It takes about 20 minutes to create the service. Display the Instance page to check the current status.

Enable the Remote Data Gateway in Oracle Analytics Cloud

  1. Log into Oracle Analytics Cloud and from the home page, click the hamburger icon and then click Console.
  2. In the console, click Remote Data Connectivity.
  3. Click Enable Data Gateway.

Configure the Remote Data Gateway Agents

Use the remote data gateway configuration utility to identify the gateway and Oracle Analytics Cloud to each other.

To complete this task, you need the following pieces of information:

  • The host name for the instance that hosts the remote data gateway. You should have noted this information when you installed and started the gateway.
  • The HTTP port for the instance that hosts the remote data gateway. You should have noted this information when you installed and started the gateway.
  • The URL for the Oracle Analytics Cloud instance (up through the end of the host name). For example:
    <instance>-<tenancy>.analytics.ocp.oraclecoud.com
  1. Verify access to the remote data gateway instance in a browser. For example:
    http://<gateway host name or IP>:<gateway port>/obiee/javads?status

    A successful connection returns an XML response.

  2. Start the remote data gateway configuration utility in a browser. For example:
    http://<gateway host name or IP>:<gateway port>/obiee/config.jsp
    1. Enter the URL of the Oracle Analytics Cloud instance and then click Generate Key.
    2. Click Copy to Clipboard to copy the key.
      Leave the rest of the fields as is. You will perform the next steps in the Oracle Analytics Cloud interface.
  3. Access the Remote Data Connectivity page in Oracle Analytics Cloud where you enabled the remote data gateway.
    1. Click Add to add a gateway agent.
    2. Paste the contents of the clipboard into the Public Key field. Note that the ID and Host are populated from the key contents.
    3. Optionally enter a Name or one is created for you, then click OK.
      You will perform the next steps in the remote data gateway configuration utility.
  4. Return to the browser that is running the remote data gateway configuration utility.
    1. Click Test.

      A message indicates that the agent successfully authenticated.

    2. Click Save.

      A message indicates that the agent was successfully submitted.

    3. Click Enable.

Connect to Oracle Autonomous Data Warehouse

Create a connection between Oracle Analytics Cloud and Oracle Autonomous Data Warehouse.

To perform the following steps, you need the service URL for the Oracle Analytics Cloud instance.

  1. Open the service URL for the Oracle Analytics Cloud instance.
  2. On the Home page, click Create then click Connection.
  3. Click Connect to Oracle Autonomous Data Warehouse.
  4. Enter the connection name, for example, adwus1.
  5. Enter and optional description.
  6. Locate and select the client credentials file you previously downloaded from the Oracle Autonomous Data Warehouse service console, for example, Wallet_adwus1.zip.
    The Client Credentials field displays the cwallet.sso file.
  7. Enter the Username and Password.
  8. Select a Service Name from the list, for example, adu_high.
  9. Click Use Remote Data Connectivity.
  10. Click Save to create the connection.