Mass Update Data Source Connection

Issue

Unable to bulk update connection information or credentials for published data source.

Environment

Tableau Server
Tableau Online

Resolution

Use one of the below options to bulk update the data source connection information.

Option 1 Bulk update the connection information using the user interface. See Edit Connections on Tableau Online for more details.

Sign in to the site that has the data sources you want to modify, select Explore and All Data Sources.
Select the Toggle Filters icon on the far right of the screen.
Under the Data Source menu, specify, All data sources, Published or Embedded within workbook.
Use the Connection type or Server name fields to filter the data sources down to which you would like to update.
Select the Select All button or check boxes for the data sources which you would like to update.
Select the Actions menu and Edit Connection... button.
Update the connection information and select Save.

Note: If you receive an error "The selected connections have different connection types and cannot be edited together." then first, under the the Show As menu, select Connections.

Option 2 Use Rest API to programmatically update the server address, port, username, or password for the specified data source connection. For more information, see the Update Data Source Connection REST API documentation.

Option 3 Write a batch script that uses the tabcmd publish command to republish the affected data sources with updated data credentials. Be certain to use "--save-db-password" parameter to embed the credentials in the published workbook/data source. For more information, see tabcmd Commands.