-
1. Re: How to change all datasources to point to new Database
Madhusudhan Khambham Aug 11, 2016 10:43 AM (in response to Al Reynolds)Hi AI Reynolds.. Please see this link ..this might be helpful for you . http://tableaufriction.blogspot.com/2012/12/changing-database-server-name-in.html
-
2. Re: How to change all datasources to point to new Database
Jeff James Aug 11, 2016 10:53 AM (in response to Al Reynolds)Al,
Depending on your coding skills, you can use the REST API to cycle through and update the server in your published data sources.
If you're using connections built in the workbooks, you can use the REST API or command line tools to download the workbooks, then follow the approach that Madhusudhan mentioned above, and finally publish the workbooks back to the server. Note that approach only works with twb files. You'll need a more complex approach for twbx files since you'll need to unzip them, modify the resulting twb, and then package them again.
Jeff
-
3. Re: How to change all datasources to point to new Database
Jeff StraussAug 11, 2016 11:42 AM (in response to Al Reynolds)
4 of 4 people found this helpfulAfter the move, you should be able to update in bulk via the server interface. Go to the datasources tab, select the mysql connections (I did SQL Server in my case) and then edit connection.
-
4. Re: How to change all datasources to point to new Database
Jeff James Aug 11, 2016 11:52 AM (in response to Jeff Strauss)Interesting. I never even thought to look at the native interface. That's could be very useful.
I've got 50+ sites to deal with, so in general, we'll keep using the API.
-
5. Re: How to change all datasources to point to new Database
Al Reynolds Aug 13, 2016 10:04 AM (in response to Jeff Strauss)Ok cool. thanks Strauss. Let me give this a go and will post back to the forum.
-
6. Re: How to change all datasources to point to new Database
Al Reynolds Aug 14, 2016 12:48 AM (in response to Al Reynolds)Ok worked like a charm. Cant believe i missed this before. Thanks
-
7. Re: How to change all datasources to point to new Database
Jeff StraussAug 14, 2016 6:44 AM (in response to Al Reynolds)
yep, it's easy to miss as it's not so well advertised, glad it helped!
-
8. Re: How to change all datasources to point to new Database
Daniel Schauder Aug 17, 2016 7:27 AM (in response to Jeff Strauss)We are facing a similar situation in my environment. I assumed we were going to have to go the download, unzip twbx, edit xml, republish route, but using the interface will be about 1000x easier. Thanks for this idea, Jeff!