Oracle Autonomous Data Warehouse Cloud Service (ADW), Part 2: Connect to the ADW database

Autonomous — No Human Labor, No Human Error, No Manual Performance Tuning

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.

Database Connection options

There are many connections 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:

Click the DB name link

The next screen will be shown, click the DB Connection option.

DB Connection options

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).

Download the credentials wallet

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.

SQL Developer downloads

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 as below:

Connections tab

In the Connections panel, right-click Connections and select New Connection. You will see connection configurations screen. Provide the connection information as shown below:

Database connection information

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.

Client credentials wallet

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:

Connection successful

Click the Save button, then the Connect button and you will have a valid connection to your ADW database.

That’s it! Now we have a good development tool (IDE) as well as the connection to ADW is properly configured as required.

Would you like to try the steps above and see the ADW in action? Give Oracle Cloud a try! Get Started with Oracle Cloud for Free!

Oracle Cloud




Azure Developer Relations Lead @ Microsoft. Invite me to speak about #Blockchain #IoT #AI #Java #Python #EmergingTechnologies #DevRel 🥑

Love podcasts or audiobooks? Learn on the go with our new app.

Recommended from Medium

Introducing Trademarks

Clean Code

Gateway — overcoming GCP Ingress limitations

JAMstackConf: A Sugar Rush

How to use enum class with dart

5 Tips for Creatives Navigating a Coding Bootcamp

A Basic Interview Question: Can You Explain What a Closure Is?

MicroStation V8i + MicroStation CONNECT Edition Hybrid Workflows for Easy Transition

Get the Medium app

A button that says 'Download on the App Store', and if clicked it will lead you to the iOS App store
A button that says 'Get it on, Google Play', and if clicked it will lead you to the Google Play store
Juarez Junior

Juarez Junior

Azure Developer Relations Lead @ Microsoft. Invite me to speak about #Blockchain #IoT #AI #Java #Python #EmergingTechnologies #DevRel 🥑

More from Medium

Azure Data Factory — Run single instance of pipeline at a time

How to install Apache HBase on Ubuntu?

Installing Cloudera Quickstart VM using Docker Hub (on Mac M1)

Not Only Kibana: Using PowerBI to Visualize Elasticsearch Data