How to Connect to Oracle Autonomous Data Warehouse for Oracle Fusion Analytics Warehouse Using SQL Developer

December 15, 2021 | 3 minute read
Krithika Raghavan
Director, Oracle Analytics
Gunaranjan Vasireddy
Senior Director
Text Size 100%:

 Introduction

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.

Connect to the Database in Autonomous Data Warehouse for Fusion Analytics Warehouse Using SQL Developer

Use these steps to connect to the database:

  1. As the Administrator for ADW with FAW, download the ADW wallet file. Locate the database details on the FAW instance page.

Click on the database name.

Navigate to DB Connection.

 

 

  1. Configure a connection to ADW for the administrator user in SQL Developer.

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.

  1. Configure a connection to ADW for the OAX_USER user in SQL Developer.

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.

 

  1. Connect as the OAX_USER user and browse through Synonyms.

 

Best Practices for Connecting to the Database in Autonomous Data Warehouse for Fusion Analytics Warehouse Using SQL Developer

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.

Summary

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.  

Check these resources for more information:

Table Structures

https://docs.oracle.com/en/cloud/saas/analytics/faiae/tables.html#tables

Relationship Diagrams

https://docs.oracle.com/en/cloud/saas/analytics/faiae/relationship-diagram.html#relationship-diagram

Loading Customization Data to ADW

https://docs.oracle.com/en/cloud/saas/analytics/fawag/load-customization-data-autonomous-data-warehouse.html

 

Learn More

To learn more about FAW, visit Oracle.com/analytics, and follow us on Twitter@OracleAnalytics. 

Krithika Raghavan

Director, Oracle Analytics

Gunaranjan Vasireddy

Senior Director


Previous Post

How every analytics user can benefit from machine learning

Nick Engelhardt | 9 min read

Next Post


Connecting Supply Chain and Workforce Insight to Improve Operational Execution and Flexibility

Jake Krakauer | 5 min read
Oracle Chatbot
Disconnected