Connecting to DSS1PRD from Tableau Server

When you're connecting to DSS1PRD from Tableau Server, you'll need to make sure you configure the data source connection correctly. In Tableau Desktop, you can define a connection using the fully qualified domain name (FQDN) of the Oracle Server, but if you try to do this in Tableau Server, you'll be unable to publish your report and will see the following error:

Unable to connect to the data source. Try connecting again. If the problem persists, disconnect from the data source and contact the data source owner.

To properly configure the connection from Tableau Server, you'll need to create a configuration on your desktop using Oracle Net Manager, and then change your connection information in Tableau Desktop and republish the workbook to Tableau Server:

  1. Open Oracle Net Manager and, from the file tree on the left, select Oracle Net Configuration > Local > Service Naming > dss1prd.
  2. In the "Service Name:" field, enter DSS1PRD.
  3. From the "Connection Type:" drop-down menu, select Database default.
  4. From the "Protocol:" drop-down menu, select TCP/IP.
  5. In the "Host Name:" field, enter
  6. For "Port Number:", enter 1521.
    Oracle Net Manager configuration screen including service name, host name, and port number
  7. Open Tableau Desktop, and change the connection information in the workbook's data source:
    1. In the "Server:" field, enter dss1prd.
    2. Delete the contents of the "Service:" and "Port:" text boxes, and leave them blank.
    3. Make sure Use a specific username and password is selected, and then enter your IU username and passphrase in the appropriate fields.
    4. Click Sign In.
  8. Republish the workbook to Tableau Server.
  9. If you plan to run an extract using your data source, you'll need to edit the connection on Tableau Server and embed a password:
    1. In the "Server name" field, enter dss1prd.
    2. In the "Username" field, enter your IU username.
    3. Select Embedded password in connection, enter your IU passphrase, and click Test Connection to see if your connection is functional.
      Tableau Edit Connection window

This is document aozo in the Knowledge Base.
Last modified on 2018-08-22 10:39:44.

Contact us

For help or to comment, email the UITS Support Center.