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.
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
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.
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>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
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.
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.
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
Previous Post