X

Best Practices from Oracle Development's A‑Team

Connecting Data Visualization Desktop Version 5 to the Autonomous Data Warehouse

Last Validated June 24, 2019 using DVD 12.2.5.3.0 and MAC-OS 10.13.6

Introduction

This post details the steps required in Data Visualization Desktop (DVD) version 5 (12.2.5+) to upload Autonomous Data Warehouse (ADW) wallets and to create ADW data connections.

For DVD Version 4 ADW Connections refer to Creating a Connection in Data Visualization Desktop Version 4 to the Autonomous Data Warehouse Cloud

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

The instructions found in Create Connections to Oracle Autonomous Data Warehouse Cloud are sufficient for experienced users. This post supplements the instructions with images of the screens used.

Updates

Past Validations: February 5, 2019 using DVD 12.2.5.1.0

                                October 1, 2018 using DVD 12.2.5.0.0

Published on:      October 2, 2018

Topics

Preparing Windows for Data Visualization Desktop

Using ADW Wallets in DVD

Creating an ADW Data Connection

Versions Used

DVD 12.2.5.0.0 and DVD 12.2.5.1.0

ADW 18.x 18.4.0.0

___________________________________________________________________________

Preparing Mac OS for Data Visualization Desktop

The following is from the 5.3 Release notes:

Mac users:

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.

Topics

Obtaining the Client Credentials Zip File from the Oracle Autonomous Data Warehouse Console

Unzipping the Client Credentials Wallet Zip File

_______________________________________________________________________

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.

_______________________________________________________________________

Unzipping the Client Credentials Zip File

Version 5.1 does not require the file to be unzipped

Use an unzip utility to unzip the Client Credentials Zip File e.g. wallet_DB201806211045.zip to a directory e.g. wallet_DB201806211045.

___________________________________________________________________________

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.

Both the 5.0 and 5.1+ Connection screens are shown.

 Click Home to access the DV home page.

Click Create

Click Connection

Click ADW

_______________________________________________________________________

Completing 5.0 Connection Details

Enter a Connection Name.

Enter the Host, Port, and Service Name found in the tnsnames.ora file in the unzipped ADW client credentials directory.

Select the cwallet.sso file in the unzipped ADW client credentials directory for the Client Credentials

Enter the Username e.g. Admin and Password

Click Save.

_______________________________________________________________________

Completing 5.1+ Connection Details

Enter a Connection Name.

Select the downloaded ADW client credentials .zip file for the Client Credentials. The cwallet.sso file is extracted and shown.

Enter the Username e.g. Admin and Password

Click Save.

___________________________________________________________________________

Summary

This post detailed the steps required in DVD version 5 (12.2.5+) to upload Autonomous Data Warehouse (ADW) wallets and to create ADW data connections.

___________________________________________________________________________

References

Autonomous Data Warehouse

Oracle Data Visualization

Downloading Client Credentials (Wallet)

 

 

 

Be the first to comment

Comments ( 0 )
Please enter your name.Please provide a valid email address.Please enter a comment.CAPTCHA challenge response provided was incorrect. Please try again.Captcha