1. Ensure that Oracle Instant Client 12.1 or later has been downloaded to the workstation.

2. Download your Oracle Wallet file from the Oracle Database Server to the same workstation. Please ensure that the wallet file is server based and not individual based. For more information on the configuration of the Wallet file, please see https://community.tableau.com/docs/DOC-10972

3. Open your TNSNames.ora file and locate the net_service_name for your service. By default you will see three net_service_name definitions in the tnsnames.ora file. Please take note of the net_service_name.

Here is a potential example of the tnsnames.ora entries for the net_service_name.

ADWCDemo_high = (description= (address=(protocol=tcps)(port=1522)(host=adwc.uscomeast1.oraclecloud.com))(connect_data=(service_name=yk2ddvkx2pyiekt_virtualitydemo_high.a dwc.oraclecloud.com))(security=(ssl_server_cert_dn= "CN=adwc.uscom-east-1.oraclecloud.com,OU=Oracle BMCS US,O=Oracle Corporation,L=Redwood City,ST=California,C=US")) )

ADWCDemo_low = (description= (address=(protocol=tcps)(port=1522)(host=adwc.uscomeast1.oraclecloud.com))(connect_data=(service_name=yk2ddvkx2pyiekt_virtualitydemo_low.ad wc.oraclecloud.com))(security=(ssl_server_cert_dn= "CN=adwc.uscom-east-1.oraclecloud.com,OU=Oracle BMCS US,O=Oracle Corporation,L=Redwood City,ST=California,C=US")) ) ADWCDemo_medium = (description= (address=(protocol=tcps)(port=1522)(host=adwc.uscom-east1.oraclecloud.com))(connect_data=(service_name=yk2ddvkx2pyiekt_virtualitydemo_mediu m.adwc.oraclecloud.com))(security=(ssl_server_cert_dn= "CN=adwc.uscom-east-1.oraclecloud.com,OU=Oracle BMCS US,O=Oracle Corporation,L=Redwood City,ST=California,C=US")) )

ADWCDemo_medium = (description= (address=(protocol=tcps)(port=1522)(host=adwc.uscom-east1.oraclecloud.com))(connect_data=(service_name=yk2ddvkx2pyiekt_virtualitydemo_mediu m.adwc.oraclecloud.com))(security=(ssl_server_cert_dn= "CN=adwc.uscom-east-1.oraclecloud.com,OU=Oracle BMCS US,O=Oracle Corporation,L=Redwood City,ST=California,C=US")) )

4. Test to make sure that your TNS_ADMIN environment variable is set correctly. Open up a CMD promt and issue the following command: echo %TNS_ADMIN%

The output of the command should produce a valid directory pathway to the TNS_ADMIN directory. For example:

C:\Users\RPANDYA>echo %TNS_ADMIN%

C:\app\client\RPANDYA\product\12.1.0\client_1\network\admin

5. Open the Tableau Desktop and Choose Oracle as a data source under the ‘To a Server’ section.
6. Use the net_service_name from the tnsnames.ora in the Server section. Press Sign In.
7. You are now ready to analyze/visualize.

Note: Please bear in mind that Oracle Wallet and configuration of the tnsnames.ora file are best configured by the Oracle Database Administrator. Tableau Support has limited ability to assist with the configuration of these technologies as they will be based largely on your organization's environment.