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 Transaction Processing using an Oracle Wallet and this version contains enhancements for key Autonomous Transaction Processing 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 Transaction Processing.

To create a new connection to the Autonomous Transaction Processing, do the following:

Obtain your credentials to access Autonomous Transaction Processing. 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 Transaction Processing.

      See Download Client Credentials (Wallets).
    • Service: Enter the database TNS name. The client credentials file includes a tnsnames.ora file that provides database TNS names with corresponding services.

    Note:

    If you are using Microsoft Active Directory with your Autonomous Transaction Processing 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.