KNOWLEDGE BASE

How to connect to Oracle ADW by using Oracle wallet files


Published: 26 Sep 2022
Last Modified Date: 27 Sep 2022

Question

How to connect to Oracle ADW by using Oracle wallet files.

Environment

  • Tableau Desktop 2022.2.0
  • Windows Server 2019
  • Oracle

Answer

Prerequisites
  1. Start fresh - remove all Oracle .jar files, Oracle Wallets, oracle.properties files, and ORACLE_HOME or TNS_ADMIN environment variables.
  2. Download the ojdbc8-full.tar.gz file under the "Oracle Database 19c" section: https://www.oracle.com/database/technologies/appdev/jdbc-downloads.html
    • Unzip the file and copy ojdbc8.jar, oraclepki.jar, osdt_core.jar, osdt_cert.jar, and ucp.jar to C:\Program Files\Tableau\Drivers
  3. Obtain the Credentials Zip File (instance wallet) and the encryption password for the wallet from your Oracle Autonomous Data Warehouse database administrator. See this document.
    • Extract the zip file to a location where the user running Tableau Desktop will have read permissions to it. If you are unsure what location to use, try placing the folder under My Tableau Repository as a start.
  4. Open the "ojdbc.properties" file in the unzipped folder and comment out all lines.
Creating the connection
  1. Create an "oracle.properties" file to My Tableau Repository/Datasources and add these lines:
    • oracle.net.tns_admin=C:\\Users\\User name\\Downloads\\Wallet file name
      oracle.net.wallet_location=(SOURCE=(METHOD=FILE)(METHOD_DATA=(DIRECTORY=C:\\Users\\User name\\Downloads\\Wallet file name)))
    • Replace the paths above with the path to the unzipped Oracle Wallet folder on your machine.
    • *****Please note on this step****** a. the path should be double slash "\\" not single. b. make sure the path only include UNZIPPED wallet folder, DO NOT put zipped folder with same name in this path. 
  2. Open the tnsnames.ora file and copy one of the database service names (high, medium or low). 
  3. Open Tableau Desktop, select the Oracle connector, and use these connection details:
    • Server: The service name from Step 2 (the one with high or medium or low in the beginning of the tnsname.ora file)
    • Service: Leave blank
    • Port: Leave blank
    • Username/password: The credentials to a user from your Oracle ADW database.
    • Tick the "Require SSL" checkbox
  4. Click Sign In.
Did this article resolve the issue?