Connect with Oracle SQL Developer (earlier than Version 18.2)

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 versions after SQL Developer 17.4.1 (or later) can connect to Autonomous Data Warehouse using an Oracle Wallet and this version contains enhancements for key Autonomous Data Warehouse features. Oracle SQL Developer and later provides support for wallet files using the Cloud PDB Connection Type. Oracle recommends that you use version 18.2 (or later); however, earlier versions of SQL Developer will work with Autonomous Data Warehouse.

To create a new connection to the 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 Connection.
  2. Choose the Connection Type Cloud PDB.
  3. Enter the following information:

    Note:

    Versions of SQL Developer starting with 18.2.0 do not require that you enter a Keystore Password and do not provide this field. For more information, see Connect with Oracle SQL Developer (18.2 or later).
    • 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 PDB.

    • Configuration File : Click Browse, and select the client credentials zip file.

    • Keystore Password: Enter the password generated while downloading the client credentials from Autonomous Data Warehouse.

      See Download Client Credentials (Wallets).
    • Service: Enter the service name. The client credentials file provides the service names.