Connecting Data Visualization Desktop Version 5 to the Autonomous Data Warehouse

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

      Latest Validation: February 5, 2019 using DVD 12.2.5.1.0

Past Validations: 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

___________________________________________________________________________

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.

For more OAC, BICS and BI best practices, tips, tricks, and guidance that the A-Team members gain from real-world experiences working with customers and partners,

visit Oracle A-Team Chronicles for BICS and Oracle A-Team Chronicles for OAC.

___________________________________________________________________________

References

Autonomous Data Warehouse

Oracle Data Visualization

Downloading Client Credentials (Wallet)

Oracle A-Team Chronicles for BICS

Oracle A-Team Chronicles for OAC

 

Add Your Comment