Connect to DSS1PRD from Tableau Server

When you connect to DSS1PRD from Tableau Server, 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 install the Oracle client, create a configuration on your computer using Oracle Net Manager, and then change your connection information in Tableau Desktop and republish the workbook to Tableau Server:

1. Configure Oracle Net Manager:
   1. Open Oracle Net Manager and, from the file tree on the left, select Oracle Net Configuration > Local > Service Naming > dss1prd.
   2. From the "Protocol:" menu, select TCP/IP.
   3. In the "Host Name:" field, enter iedss.uits.indiana.edu.
   4. For "Port Number:", enter 1521.
   5. In the "Service Name:" field, enter DSS1PRD.
   6. From the "Connection Type:" drop-down menu, select Database default.
   7. When testing the connection, use your DSS connection credentials.
2. Edit the workbook's data source in Tableau Desktop:
   1. Open Tableau Desktop, and edit the connection information for 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 DSS connection credentials in the fields for username and password. (If you don't know your DSS password, see Change your DSS1PRD password in the IUIE.)
      4. Select Sign In.
   2. Republish the workbook to Tableau Server.
3. If you plan to refresh your workbook by running an extract using your data source, you'll need to edit the workbook's data source on Tableau Server. Edit the connection for the data source on Tableau Server as follows:
   1. In the "Server name" field, enter dss1prd.
   2. In the "Username" field, enter your IU username.
   3. Select Embedded password in connection, enter the passphrase for your DSS connection, and select Test Connection to see if your connection is functional. (If you don't know your DSS password, see Change your DSS1PRD password in the IUIE.)