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

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

After 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.

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.

yep, it's easy to miss as it's not so well advertised, glad it helped!

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!