KNOWLEDGE BASE

How to Update Credentials for Published Multi-Connection Data Sources


Published: 26 Feb 2021
Last Modified Date: 09 Mar 2021

Question

How to update credentials for published multi-connection data sources. 

Environment

  • Tableau Online
  • Multi-Connection Data Sources (Cross-database joins)

Answer

Identify Multi-Connection Data Sources

  1. In a web browser, login to Tableau Online as a Site Administrator.
  2. Select Explore and from the Explore drop-down, select All Data Sources.
  3. From the view mode drop-down, select List View.
  4. On the far right side, select the filter icon (User-added image) to expand the filter window. 
  5. Under the Data source drop-down, select All data sources.
  6. The data sources that show +1 (+n) next to the Connects to database name are federated connections.
Note: If the connections in the data source are flat files or do not require authentication, then they do not require updating. 

Engage Database Administrator to Update Passwords

If you are updating the password for any of the identified multi-connection data sources, first engage the database administrator to update the password(s) there, then follow the next section on updating the connection password(s) in Tableau Online. 

Update Password for Multi-Connection Data Sources

From the All Data Sources page, select the name of the multi-connection data source under the Name column.  

If selecting the data source opens a workbook containing embedded data sources, follow the below steps. 
  1. From the Show As: drop-down, select Connections
  2. Select the Actions menu icon (User-added image) next to each connection that needs to be updated and select Edit Connection...
  3. Enter the new database password and select Save.
If selecting the data source opens a published data source, follow the below steps: 
  1. Select the Connections tab. 
  2. Select the Actions menu icon (User-added image) next to each connection that needs to be updated and select Edit Connection...
  3. Enter the new database password and select Save.

For data sources scheduled to refresh using Bridge Legacy schedules, see Update Bridge Connection Information for steps.

If you manage database connector credentials centrally using saved credentials, you can update them by going to your account settings. More information can be found in the Manage Saved Credentials for Data Connections article. 

If you publish multi-connection data sources using REST API or Tableau Server Client Python library, be sure to update the associated database password(s) within your scripts. 
 
Did this article resolve the issue?