This post details the steps required in Data Visualization Desktop (DVD) aka Oracle Analytics Desktop (OAD) version 5 (12.2.5+) to upload Autonomous Data Warehouse (ADW) wallets and to create ADW data connections.
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.
February 5, 2019 using DVD 12.2.5
October 1, 2018 using DVD 18.104.22.168.0
ADW 18C 19C
Windows environment variables play an important role for DVD and ADW connections. Some modifications may be necessary before you download, install and start DVD.
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>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
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.
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.
To enable secure communication between DVD and the Autonomous Data Warehouse, you must use trusted SSL certificates contained in an ADW wallet.
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..
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.
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.
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