Oracle Autonomous Data Warehouse Cloud Service (ADW), Part 2: Connect to the ADW database
This is the second post in a series, where I explain the summarized steps that show how to use the Oracle Autonomous databases.
Now I’m going to explain how to connect to an ADW database.
Connect to the ADW database
There are many connection options that will allow you to securely connect using client credentials wallets via SQL*Net, JDBC, and ODBC for example.
Your client credentials wallet can be downloaded from the service console or by using its REST API.
Below we have the steps you can follow in order to download it from the console. Click the link with the name of your database as shown below:
The next screen will be shown, click the DB Connection option.
You’ll see the next screen from where you can download the client credentials wallet. Click the Download button and then provide your password, the one that was used when you provisioned the database.
As soon as you provide the right password, the Download button will be enabled and then you can save the wallet file (a zip file).
SQL Developer tool
Oracle has an excellent tool for database development, Oracle SQL Developer, and it’s free! It offers an Integrated Development Environment (IDE) that simplifies the development and management of Oracle Database in both traditional and Cloud deployments.
SQL Developer offers complete end-to-end development of your PL/SQL applications, a worksheet for running queries and scripts, a DBA console for managing the database, a reports interface, a complete data modeling solution, and a migration platform for moving your 3rd party databases to Oracle.
It’s advised to use versions 18.2 or later of SQL Developer as they contain enhancements for key Autonomous Data Warehouse features.
Besides, if you are a Windows user on a 64-bit platform, download the ‘Windows 64-bit with JDK 8 included’ distribution as it includes all the files necessary to run SQL Developer and connect to your Autonomous Data Warehouse database.
Connecting SQL Developer to Autonomous Data Warehouse
Let’s explore then how we can use the SQL Developer tool in order to connect to an Autonomous Data Warehouse database.
Install the SQL Developer Tool and start it, you will see its main screen below:
In the Connections panel, right-click Connections and select New Connection. You will see the connection configurations screen. Provide the connection information as shown below:
You also need to provide the client credentials wallet. Click the Browse button for the Configuration file option above, navigate to its location and provide it as required.
Now you can test the connection, so click the Test button.
Provided that everything is correct including your network path to your remote ADW DB, you will see the Success message as shown below:
Click the Save button, then the Connect button and you will have a valid connection to your ADW database.
Wrap up
That’s it! Now we have a good development tool (IDE) as well as the connection to ADW is properly configured as required.
Oracle Developers and Oracle OCI Free Tier
Join our Oracle Developers channel on Slack to discuss Microservices, Java, JDBC, Oracle Cloud Infrastructure, Oracle Database, and other topics!
Build, test, and deploy your applications on Oracle Cloud — for free! Get access to OCI Cloud Free Tier!