This article takes a look at the Oracle Cloud solution “Oracle Database Actions”. An ADW database will be created thanks to Oracle Autonomous and in it, we will create an example database. For this, the well-known HR test database will be used.
For this exercise you will need to have an Oracle Cloud account. Although, as in all cloud there are paid services, it also has some free ones. In this exercise, only free resources will be used so that you can continue without problems, although when opening the account you will be required to enter a credit card. But do not worry that you will not be charged anything, unless you use services that are not free of course.
First, go to the Oracle Cloud site and proceed to enter with your credentials.
Once you have entered the Dashboard, you can view various services that you can use for free:
Attention! To avoid fees, choose options labeled "Always Free Eligible."
Autonomous Data Warehouse
The following window will open. We are going to build an ADW (Autonomous data warehouse) database.
In the opened window, fill in the fields to create the database. You should already have a ‘compartment’ assigned, which is created when you open your account. Here you can choose the one that offers you.
In ‘Display name’ and ‘Database name’ you can give it any name or leave the one that appears by default.
You can leave the other default options as shown here to avoid charges.
Next, create a password to manage your database. The ADMIN user will not be able to edit it in this free plan.
The type of network and the license, you must leave it as indicated here:
Finally, enter a valid email and press the ‘Create Autonomous Database’ button.
The system will redirect you to a window like this, in which you must wait until the logo turns green and ‘available’, as shown in the image.
Once here, you can now go to the ‘Database Actions’ option.
Here you will find various options, among which is SQL. This will open the ultimate console for you to work with.
Access to sample data
To access the data that we will use as an example, in this case the Oracle human resources database, we must go to the following Oracle repository: github.com/oracle/db-sample-schemas/tree/main/human_resources
Once here and for this example, just download these two files:
These files contain the queries needed to create the tables and populate them with data.
Visualizing the data
When executing these statements, Oracle Database Actions already shows us the tables with their corresponding data.
Now you can start working with them.
Connect through SQL Developer
Create a new connection.
Now enter the following information:
Name : Create a name for this connection.
Username: ADMIN (Only option for this free service.)
Password: Enter the password for the database user.
Connection type: select Cloud Wallet (with previous version, SQL Developer 18.2, it is Cloud PDB)
Configuration File : Click Browse and select the client credentials zip file.
This file can be downloaded from:
DB Connection -> Download wallet
Service: enter the name of the service. The client credentials file provides the service names.
Finally Test and Connect.
source of the images: https://www.oracle.com/database/technologies/appdev/db-actions.html