-
1. Re: Proxy Connection to entire database
Russell Christopher Jan 25, 2012 6:12 PM (in response to Andy.Webb)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.
-
2. Re: Proxy Connection to entire database
Andy.Webb Jan 25, 2012 7:05 PM (in response to Andy.Webb)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?
-
3. Re: Proxy Connection to entire database
Russell Christopher Jan 26, 2012 3:42 AM (in response to Andy.Webb)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.
-
4. Re: Proxy Connection to entire database
Andy.Webb Feb 20, 2012 12:55 PM (in response to Russell Christopher)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?