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.