Connecting SQL Developer with Oracle Autonomous Database

You can connect Oracle SQL Developer with Oracle Autonomous Database using mTLS authentication. You require the wallet files or client credentials to establish a secure connection with your Oracle Autonomous Database.

Oracle client credentials or wallet files can be downloaded from an Autonomous Database instance by a service administrator. If you are not an Autonomous Database administrator and your application requires a wallet to connect, then your administrator should provide you with the client credentials.

• For connecting with mTLS authentication, Oracle SQL Developer provides support for wallet files using the Cloud Wallet Connection Type. Oracle recommends that you use version 18.2 (or later). However, earlier versions of SQL Developer will work with Autonomous Database using an Oracle Wallet.
• For connecting with TLS authentication, Oracle SQL Developer provides support using the Custom JDBC Connection Type. See Connect with Oracle SQL Developer with TLS Authentication for details on connecting using TLS authentication.

• Access to Oracle Cloud Infrastructure Console or the Autonomous Database Service Console.

• Download the latest version of Oracle SQL Developer

• Download the Wallet or client credentials

To create a new mTLS connection to Autonomous Data Warehouse, to install Oracle Data Miner, grant privileges to an existing user, and to create a new user and granting the required privileges to the user:

1. Start Oracle SQL Developer and in the connections panel, right-click Connections and select New Database Connection....

   Figure 4-1 New Database Connection

   
2. In the Connection Type field, select Cloud Wallet.
3. In the New /Select Database Connection dialog, enter the following information:
   1. Name: Enter the name for this connection.
   2. Username: Enter the database user name. You can either use the default administrator database account ADMIN provided as part of the service or create a new schema, and use it.
   3. Password: Enter the password for the database user.
   4. Connection Type: Select Cloud Wallet.

      Note:

      If you are using SQL Developer 18.2, then it is Cloud PDB.
   5. Configuration File: Click Browse, and select the client credentials zip file.
   6. Service: Enter the database TNS name. The client credentials file includes a tnsnames.ora file that provides database TNS names with corresponding services.

   Figure 4-2 Connection to Oracle Autonomous Database

   
4. Click Connect to connect to the database.
5. Run the following scripts in SQL Worksheet:
   1. To install the Oracle Data Miner under the ADMIN account, run the following SQL script from the SQL Developer home directory sqldeveloper/dataminer/scripts :

      @@installodmr.sql DATA TEMP

      Here, DATA and TEMP are tablepsaces created in Autonomous Database.
   2. To grant required privileges to an existing user, run the following sql script in sqldeveloper/dataminer/scripts

      @@usergrants.sql {username}

   3. To create a new user and grant required privileges, Run the following sql script in sqldeveloper/dataminer/scripts:

      @@createuser.sql {username} {password}

This completes the task of connecting SQL Developer with Oracle Autonomous Database. Next, you must install the Oracle Data Miner repository