Connect with Oracle SQL Developer (18.2 or later)

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.

To create a new connection to Autonomous Data Warehouse, do the following:

Obtain your credentials to access Autonomous Data Warehouse. For more information, see Download Client Credentials (Wallets).

  1. Start Oracle SQL Developer and in the connections panel, right-click Connections and select New Database Connection....
  2. Choose the Connection Type Cloud Wallet.
  3. 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 service name. The client credentials file provides the service names.

      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).
  4. Click Connect to connect to the database.