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

You can use the SQL Developer desktop client to connect to Autonomous Data Warehouse. However, this connection method is optional, and using Database Actions (SQL Developer Web) is the preferred method.

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 the ADMIN user by setting the following values in the New/Select Database Connection dialog:
   1. Define a Name for the connection, such as PROD_ADMIN.
   2. Set the Username to ADMIN.
   3. Enter the password for the ADMIN user.
   4. Set the Connection Type to Cloud Wallet.
   5. For the Configuration file, click Browse and select the wallet.zip file.
   6. Service: 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 to validate the connection.
   9. Click Save.
   10. Click Connect.
4. Run this query to verify proper configuration:

   select sum(bytes)/1024/1024/1024/1024 as USED_STORAGE_TB from dba_segments
         where owner not in ('SSB', 'SH');