Let’s get connected: ADW and SQL Developer

In this blog we’re going to discuss how to connect to ADW through SQL developer and upload some data.

Credentials Wallet

Log into your Oracle environment and select the ADW environment that you have provisioned.

The details screen allows you to perform some basic operations with the service, including scale up/down, manual backups and restores from backups. Click on the "Service Console" button.

Example: Scaling Up/Down can be done in the Service Management screen

The administration screen allows you to perform some basic administration of the service, one of which is downloading the Credentials, click the "Download Client Credentials".

When you download the wallet, you will be asked to enter a password to protect the credential store. 

SQL Developer: Getting Connected

Open SQL Developer and create a new connection. 

Use the username and password specified when you provisioned the service. Use a connection type of "Cloud PDB" 

Click the browse..to find the zip file location (downloaded in the previous section) and keystore password you associated with it. You can now click the Test or Connect.

Once connected you should be able to see a list of tables available to you in the ADW environment.