KNOWLEDGE BASE

How to connect to Oracle Autonomous Transaction Processing database


Published: 23 Jun 2021
Last Modified Date: 23 Jun 2021

Question

Connecting to Oracle ATP instance with Tableau Desktop

Environment

  • Tableau Desktop 2020.4.2
  • Windows 10
  • Oracle

Answer

  • Download and Install the Oracle Instant Client
  • Visit the Oracle Download page : https://www.oracle.com/database/technologies/instant-client/downloads.html
  • Oracle provides a direct link to the latest Client : https://download.oracle.com/otn_software/nt/instantclient/instantclient-basic-windows.zip
  • Create folder to store the Instant Client. E.g. C:\Oracle\, move and unzip the Instant Client Zip file to this folder E.g. C:\Oracle\instantclient_19_11
  • Designate this folder as the “Oracle Home” folder and manually create the sub-folders (\network\admin) for Oracle to find the network connection information. The full path should be like C:\Oracle\instantclient_19_11\network\admin
  • Set ORACLE_HOME environment variable to locate the necessary files used to make secure connections to the Oracle Cloud. At this point the Oracle Instant Client has been installed and the ORACLE_HOME environment variable has been set. 
  • ORACLE_HOME: C:\Oracle\instantclient_19_11
  • Test to make sure that your ORACLE_HOME environment variable is set correctly. Open up a CMD promt and issue the following command: echo %ORACLE_HOME%
  • Login to Autonomous transaction Processing database and download the Wallet files. Move the Wallet ZIP file from your Downloads folder to the Oracle Instant Client Folder in the network/admin subfolder.
    • Unzip the Wallet Zip file into this same folder (C:\Oracle\instantclient_19_6\network\admin)
    • This will unpack important files such as:
      • tnsnames.ora 
      • sqlnet.ora
      • cwallet.sso
      • ewallet.p12
      • keystore.jks
      • truststore.jks
  • Download Oracle driver. Since we are using the Oracle Cloud Wallet, all the files listed below is required and placed into C:/Program Files/Tableau/Drivers/
    • ojdbc8.jar
    • oraclepki.jar
    • osdt_cert.jar
    • osdt_core.jar
  • Run Tableau Desktop and connect to Oracle by using the net_service_name defined in the tnsnames.ora.

Additional Information

This article covers all the steps with details

http://holowczak.com/connecting-to-oracle-cloud-from-tableau-desktop-using-oracle-instant-client/
Did this article resolve the issue?