I have to handle this. In the short term, I manually go onto the "data connections" admin tab usually about once a week, then choose my database connection type (e.g. Pivotal Greenplum) and then bulk update all the connections to the proper credentials, but this does require me to have access to the service account password.
With 9.0, our plan is to programmatically do this on a nightly basis prior to the schedules running. Apparently it can be done by way of the REST API, we just have to figure out how to do it.
Hi The specified item was not found.
How one can change the published data source credentials from server UI ? Can you please list the steps .
The best way to update connections is via the tableau interface( screen shots that Jeffrey posted). This has been a pain point for quite some time because, only an admin has the access to update the data connections. So the users are dependent on the admin. I had to deal with this all time in my previous role.
Good news, the rest API in version 9.0 update has this option available.Now you can pragmatically update the connections. Documentation is here.
Hope this helps.
Vikram, do you have a working copy of the REST API to update the data connections?
Also, in 9.0, non-admins can update their own data connections within Workbooks and Data Sources published to Tableau Server.
Thanks Matt Coles @Jeffrey_strauss
Say user opens tableau desktop -> say connect to data-> connect to oracle/teradata tables /create joins /...etc and published that data source to tableau server
--- now the development part ... user opens tableau desktop->say connect to data -> say tableau server -> select the data source which he published earlier ..and do his development ... now lets say after 30 days his password got expired ,so what he need to do it go to data connection tab and edit the credentials (new one ) ..that's it ??
Now next thing what if data base changed(like tables updated ,columns renamed or lets say user needs to add tables to connection) then User just needs to connect to tableau desktop-> say connect to data->tableau server -> select earlier published data source-> right click on data connection-> say edit data source and make the changes and republish it ..??
so there is no need to have a non-human database account because data source publisher can edit credentials once it expires and also can edit the data source which is already in server per database changes in background.??
Jeff, I currently don't have one. I plan to write something this weekend.