R19 - Hi Team, We have requirement where we nee...
Hi Team, We have requirement where we need to setup connection between ThoughtSpot and Amazon RDS Postgres, the challenge we have is they have authentication for Postgres done via Vault generating username and cred for every 6h, any solution we have to setup connection in this scenario.
5 Replies
you can use api to create/update connections..
{url}/api/rest/2.0/connections/{conn_id}/update'
{url}/api/rest/2.0/connection/create'
The credentials are not static and has the system to get generated and unique after every 6hrs
you can setup a job to update the credentials using the API.. I don't see any other way of how TS can know that credentials have been changed
Periodic Job: You can use the API's for your Vault to read specific entries periodically and use TS API's specified by @shikharTS to update connection configuration.
Again if the code/process/pipeline which is responsible for generating the username/cred then it can push an event or can also update TS connection configuration via TS API's.
Okay, will check with that, Thanks @shikharTS and @RT