Loading

How to connect to Oracle ADW by using Oracle wallet files

Дата публикации: Apr 13, 2024
Задача

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

Действия
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. 
  1. Open the tnsnames.ora file and copy one of the database service names (high, medium or low). 
  2. 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
  3. Click Sign In.
Дополнительные ресурсы
For the connection steps using JDBC and key/certificate, refer to the article below:

Connecting to Oracle Autonomous Data Warehouse Using JDBC

Номер статьи базы знаний

001458655

 
Загрузка
Salesforce Help | Article