Oracle Autonomous Database connection in SQL Developer Tool

 There are two pre-requisite to connect your oracle Autonomous database with the SQL Developer tool:

1. Later Version of SQL Developer (by the time of writing this blog it was 20.4.1)

2. Client Credential Wallet.

You can download the SQL developer tool from the oracle website.

Now to get the Client credential wallet, login to your oracle cloud account and navigate to the Autonomous Database section, select the database you want to connect in the SQL developer tool.

Navigate to the DB Connection tab

You will be prompted to download the client credential wallet (Its a zip file)

enter the password to start downloading and save the downloaded zip file at some locations on your PC.

This password is for opening the zip file so make note of it.

Now open SQL Developer -> New Connection.

Name your connection.

provide the username and password of your database user.

you can use the admin user and password as well.

Set connection type to Cloud wallet.

Navigate to the folder where you have saved your zip file.

Test the connection and voila.