1 of 1 people found this helpful
I have a search and replace tool for the large objects, drop a mail to tfoldi at starschema .net so I can share it with you
Anyway, with REST API you can change the workbook connections as well so there is no need to download/publish the workbooks: https://onlinehelp.tableau.com/current/api/rest_api/en-us/help.htm#REST/rest_api_ref.htm#Update_Workbook_Connection%3FTo… Chris Toomey has a mass update tool using the REST API somewhere on the internet, I can try to find it
Hi Tamas Foldi,
Tried sending you an email from my work email. If you haven't seen received it you could share your tool with me on tor.helge.huse at sparebank1 .no (work) OR torhhu at gmail .com
I'm very grateful for your assistance
First, thank you for all the great tools and knowledge that you share with the community - Much appreciated! We have a need to update the database name for over 5000 workbooks across 700+ sites. These workbooks use a live connection (with embedded credentials) and are published on Tableau Server. I download the TableauFS application code from GitHub and compiled and built it on Ubuntu and now able to mount all the sites and workbooks as a file system. Thank you for building such a wonderful tool. I am now able to use the search and replace functionality of Linux (Find or Sed) to replace the dbname across all the workbook xml files. However, after the update, the workbooks lose the embedded credentials and asks for a password when the workbook is loaded. Do you have any thoughts on how to avoid this from happening so that the embedded credentials are preserved upon updates via TableauFS? Perhaps the "search and replace" tool for large objects might prove beneficial in our case? Any ideas or thoughts would be greatly appreciated.
It's not automatic per say, but couldn't you also do this fairly quickly just via the UI?
I.e. go to datasources tab, change datasource filters to show Embedded in Workbooks, search server name with the old Netezza IP, and then select all and Edit Connection