I would take a look at the REST API functionality
This gives you the ability to add / remove user. Change their details (including passwords)
Add / Remove the accounts from groups, etc
Hope this helps
We are not using REST API functionality in our project. Is there any other way that we can write batch type scripts to achieve this requirement.
You could do this using Tabcmd (I think)
Using Tabcmd createusers command will create users based on a CSV list (this can contain the username, password, site role)
The tabcmd addusers command will add a list of users in a CSV file to a group.
And the tabcmd deleteusers command will delete a list of users in a CSV file.
This option is definitely more clunky then using REST API, but could be workable
All the best
Thanks Glen for your response but using tabcmd option how can we automate this process?
Can we write any batch script to achieve this?
Yes. Batch scripts can be written to automate TabCmd. However, as Gary mentioned using the REST API is probably the most robust approach.
Absolutely, you can have a batch script to run these commands
It would look something like this
tabcmd login -s http://server -u admin -p password
tabcmd createusers UsersToAdd.csv
tabcmd addusers "HR Users" HR_Users.csv
tabcmd addusers "Sales Users" Sales_Users.csv
tabcmd deleteusers UsersToDelete.csv
The above batch will login to a tableau server, create users (held in UsersToAdd.csv), add users to groups 'HR Users' and 'Sales Users', and will delete users listed in UsersToDelete.csv.
So this part is straight forward. The trickier part is populating the different CSV files that will be used by the batch file.
Hope this makes sense
All the best
Thank you Glen and all for your inputs