Last Modified Date: 06 Mar 2017
- Tableau Server
ResolutionUse one of the following workarounds to modify the Oracle connection:
1. Open the workbook in Tableau Desktop, edit the connection details, and re-publish.
2. Use a TNSNAMES.ORA file and enter the TNS name as the 'Server Name' with no Service name or port when connecting. Refer to Setting an Oracle Connection to Use TNSNames.ora for configuring the Tableau Server machine to utilize a TNSNAMES.ORA file.
In this scenario, simply changing the 'Server Name' in the Edit Connection Dialog from one TNS name to another should be successful, as long as both of the TNS names are configured in TNSNAMES.ORA.
CauseThis is related to known issue in Tableau Server that occurs when the Oracle connection is using service name and port rather than a TNSNAME. Tableau Server does not display a field for the service name in the Edit Data Connection dialog.
Thank you for providing your feedback on the effectiveness of the article.
Open new Case
Training and Tutorials