This content has been marked as final. Show 1 reply
Hey Inez -
There are two ways you could approach this:
- Don't use a script at all - The Tableau Server portal allows one to modify the username and password associated with a data source. The IT team could go into Tableau Server after it has been restored from TEST to PROD and simply update the appropriate information right in the "Data Connections" list
- Using tabcmd (a command-line tool), one can specify what the username and password for a database should be. Your IT people would essentially need to overwrite the existing data source with the essentially the same information - except with a different uid/pwd. Example :tabcmd publish "mydatasource.tds" --db-username theuser --db-password thepassword
Hope this helps!