Oracle SQL Developer is a free integrated development environment that simplifies the development and management of Oracle Database in both traditional and cloud deployments.
SQL Developer can connect to Autonomous Data Warehouse using an Oracle Wallet and contains enhancements for key Autonomous Data Warehouse features. Oracle SQL Developer provides support for wallet files using the Cloud Wallet Connection Type (SQL Developer 18.2 shows this as Cloud PDB). Oracle recommends that you use version 18.2 (or later); however, earlier versions of SQL Developer will work with Autonomous Data Warehouse.
Download the latest version of Oracle SQL Developer for your platform from the Download link on this page: Oracle SQL Developer.
Obtain your credentials to access Autonomous Data Warehouse. For more information, see Download Client Credentials (Wallets).
- Start Oracle SQL Developer and in the connections panel, right-click Connections and select New Database Connection....
- Choose the Connection Type Cloud Wallet.
- Enter the following information:
Connection Name: Enter the name for this connection.
Username: Enter the database username. You can either use the default administrator database account (
ADMIN) provided as part of the service or create a new schema, and use it.
Password: Enter the password for the database user.
Connection Type: Select Cloud Wallet (with SQL Developer 18.2, this is Cloud PDB)
Configuration File : Click Browse, and select the client credentials zip file.
Service: Enter the database TNS name. The client credentials file includes a
tnsnames.orafile that provides database TNS names with corresponding services.
Note:Versions of SQL Developer before 18.2 require that you enter a Keystore Password. For more information, see Connect with Oracle SQL Developer (earlier than Version 18.2).
- Click Connect to connect to the database.
If you are using Microsoft Active Directory with your Autonomous Data Warehouse database, then for Username enter the Active Directory "AD_domain\AD_username" (you may include double quotes), and for the Password, enter the password for the Active Directory user. See Use Microsoft Active Directory with Autonomous Database for more information.