Hi Andy -
You're going to need your joins, sorry. Tableau 7's new Data Server features are awesome but aren't really going to buy you much in terms of what you're looking for.
The good news is that it's really easy to globally find/replace a value across all your data connections. Just search for a string (for example, I'm searching for "." (the local pipe) as my server name, and I find X connections that use it. I then select them all and edit them all at the same time. See attached screenshots - took me about 3 seconds.
Thanks for the response. Very helpful.
I note that I cannot change the database name. Suppose I want to, for instance, copy 10 workbooks and point them to a different database on the same server. Is there any convenient way to do that?
Messing around with the connection string will be easy, but copying the workbooks will be your speed bump - as you've probably discovered, there isn't a fast way to copy on Server, only move.
In your shoes, I would probably move to the command-line and use the TabCmd utility - You could do a TabCmd GET 10 times to pull down your 10 workbooks, a TabCmd PUBLISH to push them back to the server under a different name, and then fix up the connection strings...Not optimal, but it would get you there.
Thanks for the response. Very helpful. I see how this works if I am using a direct connection to the database specified in the workbook. But suppose I am using either a Tableau Server connection or an Tableau Server Extract?
For instance, let's say site 1 has all my data sources and I want to copy them to site 2 and point then point them to a different source data server or different logon and password. Is there anyway to accomplish this without rebuilding everything from scratch?