Connecting Data Visualization Desktop Version 5 to the Autonomous Data Warehouse

October 5, 2018 | 4 minute read
Text Size 100%:

Last Validated December 8, 2020 using OAD 5.8

Introduction

This post details the steps required in Oracle Analytics Desktop (OAD) version 5 to create ADW data connections.

For additional details on ADW, visit the Autonomous Data Warehouse page. For additional details on OAD visit the Oracle Data Visualization page.

Note: VPN may need to be disconnected.

Past Validations

December 8, 2020 using OAD 5.8

February 5, 2019 using DVD 12.2.5

October 1, 2018 using DVD 12.2.5.0.0

Topics

Preparing Mac OS for Data Visualization Desktop

Preparing Windows for Data Visualization Desktop

Using ADW Wallets in DVD

Creating an ADW Data Connection

Preparing Mac OS for Data Visualization Desktop

If you're using a Mac and have Oracle Data Visualization Desktop installed, then you must uninstall it before installing the new version. See Known Issues.

Preparing Windows for Data Visualization Desktop

Windows environment variables play an important role for DVD and ADW connections. Some modifications may be necessary before you download, install and start DVD.

About Installation Variables

The first time DVD starts, it creates a directory named DVDesktop in the folder specified in the %TEMP% environment variable. If that variable is not set, it creates the DVDesktop directory in the %LOCALAPPDATA%\TEMP folder. DVD also creates a directory named DVDesktop in the %LOCALAPPDATA% directory.

Prior versions created a directory named DataVisualization in the %LOCALAPPDATA% directory.

If you have issues because of a prior installation, you might try saving any existing DVD Projects, deleting those directories, and reinstalling.

If desired, run the SET TEMP and SET LOCALAPPDATA in a command window to view where those variables point to.

From the Windows Start menu, type in CMD to open a command window.

C:\Users\dcarley>SET TEMP
TEMP=C:\Windows\MYTEMP

C:\Users\dcarley>SET LOCALAPPDATA
LOCALAPPDATA=C:\Users\dcarley\AppData\Local

C:\Users\dcarley>DIR /A:D %TEMP%\DVD*
Directory of C:\Windows\MYTEMP
02/05/2019 06:42 AM < DIR > DVDesktop

C:\Users\dcarley>DIR /A:D %LOCALAPPDATA%\DVD*
Directory of C:\Users\dcarley\AppData\Local
02/05/2019 06:41 AM < DIR > DVDesktop

About the TNS_ADMIN Variable

Run the SET TNS_ADMIN command to see if it exists and/or view where the variable points to.

If it exists, unset it before starting DVD if it points to an existing ADW wallet location. If it is necessary to keep the variable set, ensure that the sqlnet.ora file in that location does not contain a WALLET_LOCATION parameter.

Run the SET TNS_ADMIN= command to unset it.

Downloading, Installing, and Starting DVD

Download and install DVD from Oracle Data Visualization Desktop Downloads.

Unzip the downloaded folder and run the installer.

Check the Launch after Install box so DVD starts after the installation.

If you did not check the box, start DVD after the installation completes.

Using ADW Wallets in DVD

To enable secure communication between DVD and the Autonomous Data Warehouse, you must use trusted SSL certificates contained in an ADW wallet.

Obtaining the Client Credentials Zip File from the ADW Console

The ADW wallet file is one of the files provided in the Client Credentials zip file. Refer to Downloading Client Credentials (Wallet) for the steps..

Creating an ADW Data Connection

A data connection is used to create DV data sets. With DVD versions 12.2.5+, an ADW wallet is uploaded for each ADW Data Connection.

Click Home to access the DV home page.

Click Create

Click Connection

Click ADW

Enter a Connection Name and optionally a Description.

Select the downloaded ADW Wallet Zip File - Client Credentials. Select the appropriate Service Name from the drop-down.

Enter an ADW schema owner Username and Password.

Then click Save.

Summary

This post detailed the steps required in DVD version 5 (12.2.5+)  to create ADW data connections.

For other posts relating to analytics and data integration visit  http://www.ateam-oracle.com/dayne-carley

 

Dayne Carley


Previous Post

Connecting Oracle Analytics Cloud Version 5.1+ to the Autonomous Data Warehouse

Dayne Carley | 7 min read

Next Post


Address Validation Integration in CPQ

Julio Camara | 4 min read