KNOWLEDGE BASE

Connecting to Oracle in Tableau Desktop using Oracle Wallet


Published: 22 Apr 2020
Last Modified Date: 21 Jul 2020

Question

Connecting to Oracle using Oracle Wallet with Tableau Desktop.

Environment

Tableau Desktop

Answer

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. Also provide the database username and the password and 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.

Additional Information

The attached PDF covers all steps in greater detail with screenshots.
Did this article resolve the issue?