How to connect to Oracle ADW by using Oracle wallet files

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


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


  • Tableau Desktop 2022.2.0
  • Windows Server 2019
  • Oracle


  1. Start fresh - remove all Oracle .jar files, Oracle Wallets, files, and ORACLE_HOME or TNS_ADMIN environment variables.
  2. Download the ojdbc8-full.tar.gz file under the "Oracle Database 19c" section:
    • 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 "" file in the unzipped folder and comment out all lines.
Creating the connection
  1. Create an "" file to My Tableau Repository/Datasources and add these lines:
    •\\Users\\User name\\Downloads\\Wallet file name\\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?