So my IT team is moving my databases to an upgraded server and I, being thoughtless, created a connection to the new server while keeping the connection to the old one - without noting down which tables in my Tableau workbook were from which connection. This is a problem because in the new server, the databases and tables have the same names as they did in the old server.
I've tried converting my tables to custom SQL to find the databases they're pulling from, but the custom sqls only give me [dbo].etc. Is there a way to find out which data connections I got which tables from without having to make a copy of the workbook and delete one connection at a time to see what breaks?
Also, is there a way to not have to re-create my custom SQL tables once I start replacing the old data connection with the new one?
Hi @Emma Fan
To determine the data connection of a table in Tableau, navigate to the Data Source tab. Review connection details by clicking on each connection. Temporarily rename connections for better clarity. Hover over table names to view connection details. Additionally, utilize Tableau's Metadata API for in-depth information. To prevent recreating custom SQL tables when replacing old connections, leverage the Replace Data Source function. Ensure that the new connection maintains the same schema and table names, and verify mappings to retain custom SQL queries..
