As an Oracle Fusion Analytics Warehouse customer, you might need to access the underlying database in Oracle Autonomous Data Warehouse (ADW) for various reasons.
This article describes the steps and best practices for using SQL Developer to connect to the database in Oracle Autonomous Data Warehouse that corresponds to your Oracle Fusion Analytics Warehouse (FAW) instance.
Use these steps to connect to the database:
Click on the database name.
Navigate to DB Connection.
Launch SQL Developer, and select New Database Connection.
Provide a Name for the connection.
In the User Info section, enter the credentials for the administrator user for the FAW schema.
Select Cloud Wallet as the Connection Type.
Browse and select the Configuration file that you downloaded in the prior step.
For service, select the one named with the “_low” prefix.
Save and test the connection.
Repeat the tasks from Step 2 above, except save the connection for the OAX_USER user.
The password for the OAX_USER user should be the same as the initial password for the administrator user when the instance was created. The administrator user can reset the password for OAX_USER, if required.
Save and test the connection.
When you configure the connection, ensure that you select the service with the “low” prefix in its name. Connecting with the “high” service might lead to:
Performance issues in reports in FAW.
Delay in completion of daily incremental data pipeline loads.
Close unused sessions in a timely manner to ensure no adverse impact on the performance of FAW.
This article attempts to simplify the steps involved in using SQL Developer to connect to the database in Oracle Autonomous Data Warehouse that corresponds to your Oracle Fusion Analytics Warehouse (FAW) instance, and to outline best practices that you can follow to ensure there is no performance impact to FAW while connecting to the database directly.
https://docs.oracle.com/en/cloud/saas/analytics/faiae/tables.html#tables
https://docs.oracle.com/en/cloud/saas/analytics/faiae/relationship-diagram.html#relationship-diagram
Learn More
To learn more about FAW, visit Oracle.com/analytics, and follow us on Twitter@OracleAnalytics.
Previous Post
Next Post