There is a scenario where i store the user details in a Teradata database and i want Tableau server to connect to that database to take in the user list. So that we will not create any users in Tableau server and the server points to that database for the users list
Or How can i change the Tableau server database (i.e PostgreSQL ) to connect to Teradata or any other database for that matter?
Updating the PostGres DB directly is not recommend or supported. You can however, import these users with a script using TabCMD (see TabCMD documentation here). You should be able to either iterate through them or else pull the users into a .csv and then sync them with Tableau all at once.