Oracle Data Visualization Desktop Connecting to Oracle Cloud Always Free Autonomous Database

0

Oracle Cloud now offers the Always Free Tier that comes with an always free Autonomous Data Warehouse (up to 20 GB data storage) as well as an free Autonomous Database for Transaction Processing. In an earlier article, I described how to provision your own Free Autonomous Data Warehouse in Oracle Cloud (in 10 minutes and a little bit). A second article shows how to connect desktop based SQL Developer to the cloud based ADW or ATP instance. In this article, I will show how to connect the desktop tool Oracle Data Visualization for Desktop (the local counterpart to Oracle Analytics Cloud) to the always free Autonomous Data Warehouse instance. (note: connecting to a trial or paid for instance works in exactly the same way).

Oracle Data Visualization for Desktop is a tool you can download from OTN and run locally. It falls under the OTN license, which means that for evaluation and training purposes, you can work with the tool for free.

As a prerequisite, you should download the Client Credentials Wallet for the ADW or ATP instance. You can do so from the OCI Dashboard | Autonomous Database | <Database Instance Dashboard>

image

Click on Download, provide the password for user admin and download the zip-file:

image

Next, run Oracle Data Visualization for Desktop:

image

On the Home Page, click on CreateimageSelect Connection in the popup palet:

image

Next, select Oracle Autonomous Data Warehouse Cloud:

image

The Create Connection dialog appears. Provide the following details:

  • Connection Name
  • Description
  • Host (learn this from the tnsnames.ora file in the client credentials wallet)
  • Port (probably 1522,  learn this from the tnsnames.ora file in the client credentials wallet)
  • Client Credentials – extract the cwallet.sso file from the client credentials wallet and select this file
  • Username – for example admin or some other database user in the ADW instance
  • Password – password for the ADW user
  • Service Name (learn this from the tnsnames.ora file in the client credentials wallet)

image

The contents of the Client Credentials Wallet for the ADW instance and specifically the contents of the tnsnames.ora file (which includes host, port, service name)

SNAGHTML389f9998

Click on Save. The tool will now validate the data provided. Hopefully you will get:

image

After this success indicator, we can start the creation of data sets based on tables in this ADW instance.

For example: click on create and select Data Set:

image

Now select the Connection to the ADW instance:

image

A list of schemas is shown and after selecting the SH schema, we can select the table to base the Data Set on:

image

This means the Data Visualization Desktop tool [in this case running on my laptop] can work with the data in our always free ADW instance on Oracle Cloud Infrastructure. Enough for now. Good luck!


About Author

Lucas Jellema, active in IT (and with Oracle) since 1994. Oracle ACE Director and Oracle Developer Champion. Solution architect and developer on diverse areas including SQL, JavaScript, Kubernetes & Docker, Machine Learning, Java, SOA and microservices, events in various shapes and forms and many other things. Author of the Oracle Press book Oracle SOA Suite 12c Handbook. Frequent presenter on user groups and community events and conferences such as JavaOne, Oracle Code, CodeOne, NLJUG JFall and Oracle OpenWorld.

Leave a Reply

This site uses Akismet to reduce spam. Learn how your comment data is processed.