Configure the Connection to Autonomous Data Warehouse for OAX_USER with SQL Developer Desktop Client

You can use the SQL Developer desktop client to connect to Autonomous Data Warehouse.

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. Launch SQL Developer.
2. In the Connections pane, click New Connection.
3. Create an SQL Developer connection for OAX_USER. Set the following values in the New/Select Database Connection dialog:
   1. Define a Name for the connection, such as PROD_OAX_USER.
   2. Set the Username to OAX_USER.
   3. Enter the password for OAX_USER.
   4. Set the Connection Type to Cloud Wallet.
   5. For the Configuration file, click Browse and select the wallet.zip file.
   6. Service Name: Select <service name>-low. Using low prevents pipeline conflicts.
   7. When connecting with a virtual private network (VPN), enter details in the Proxy tab.
   8. Click Test.
   9. Click Save.
   10. Click Connect.
4. Expand Synonyms to see all of the prebuilt synonyms for OAX_USER.
5. Run this query to verify proper configuration:

   select * from DW_CUSTOMER_LOCATION_D