Every workbook that is published to the server contains one or more connections. These connections are listed on the Data Connections page. Connections are different from data sources in that each connection is associated with a single workbook. That means if you have three workbooks that connect to the same data source, you will have three connections listed on the Data Connections page.
The Data Connections page allows you to manage the connection information for all of the workbooks published to the server. For example, you may have a large number of workbooks that connect to a database on a specific server. If the name of the server changes you can update all of the workbooks at once so they reference the new server name. Another example is if a workbook connects to a data source using a specific user name and password. You can quickly update all of the workbooks to use different credentials.
Navigate to the Data Connections page.
Use the search box at the top of the list of connections to find the connections to modify. You can search by Server, Connection Type, the Server Port, Database User Name, and whether it Has Embedded Password.
Note: The values you type into the Server and Database User Name fields are treated as regular expressions.
Select the connections to modify in the list of search results and then select Modify on the Actions toolbar.
Type in a new value for one or more of the connection attributes. All attributes selected to Change will be updated, so if you select the Change check box and leave the New Value field blank, the attribute will be set to blank as well.
When finished click Modify.
A monitor dialog opens automatically where you can watch the progress of the changes. If you close the monitoring dialog box, the modifications will run in the background until completed. Tableau Server will make as many changes as possible. Any failures will be skipped but will not impede other changes from being made. For example, if you try to change the server name and add a password to several connections, the server names will be changed, and the passwords on workbooks will be changed, but because you cannot add a password to a data source, the passwords for the data sources will not be changed.
There is an administrative view that allows you review details for completed and pending tasks. Refer to Server Maintenance to learn more about administrative views.