Hi there, we are looking to test our new servers and wanted to copy an existing Tableau Site into a Test site and then change the db connections for each workbook and data source to the new db server too. Can someone show me how to do a script in VBA for instance (maybe using httpxml object to post to the tableau server) to go through each wb and ds and change the db connection. The plan is to first export the Site into a zipped file using tabcmd exportSite and then import it into the new Test Site.
This is more detail that i sent to tableau support technician who advised me to post in the community forums for REST API
One problem we had with manually moving workbooks across
to a new site is the need to make published datasources local first within the
workbooks and then publishing to the new site after signing into it. But
perhaps with REST API we can do an import of a whole site using tabcmd
importsite/exportsite and then use the REST API to change connections of the
datasources and then extracts within the workbooks stored in the site. Such
that if we downloaded them from the new site we would see the updated db
connections there. If this is the case then what scripts do we need to update
both the published datasources and the workbook internal extracts so that the
db connections are all updated? I am good with VBA and I was hoping we can use
the xmlhttp object to post to the tableau server maybe and run the scripts.
After the site has been imported to the new server you could use the Update Data Source call in the Tableau Rest API.
This should allow the published data source to be updated.
Hope this helps!