Configure the Connection for OAX_USER in Oracle Analytics Cloud

You can connect to an Autonomous Data Warehouse with Oracle Analytics Cloud.

When you configure the connection, select the service name with the "low" prefix in its name. Connecting with the "high" or "medium" service might lead to performance issues in reports in Fusion Data Intelligence and delays in completion of daily incremental data pipeline loads. See Database Service Names for Autonomous Transaction Processing and Autonomous JSON Database for more information.

1. Sign in to your Fusion Data Intelligence instance.
2. Click Go to Home Page.
3. Click Navigator and then Data.
4. Click the Connections tab.
5. On the Oracle Analytics page, click Create, click Connection, then click Oracle Autonomous Data Warehouse.
6. Enter these values and then click Save:
   1. Connection Name: ADW - OAX_USER
   2. Description: ADW - OAX_USER
   3. Client Credentials: Click Select, then browse to select the wallet.zip file.
   4. Username: OAX_USER (default)
   5. Password: The OAX_USER password.
   6. Service Name: Select <service name>-low. Using low prevents pipeline conflicts.
7. In the Connections tab, click the ellipsis icon to the right of the name of the connection you just created to open the Actions menu and click Inspect.
8. Click Access and then Roles.
9. Type ServiceAdmin in the Search By Name field, then click to add it.
10. Click the Full Control radio button for the ServiceAdmin user.
11. Click Save and then Close.