I would create an extract of the data source (Right click data source in workbook, then click "extract data"). It will provide data access faster and will allow the data to be stored in the workbook or on the server as an extract.
You will need to publish the workbook with the extracted data source.
Thanks Bob for your reply .
I am not sure if we are on same page .
This report will be used to monitor who is accessing which database , It will be a monitoring kind of report for me ,Its for all the workbook present in tableau server . do you think this can be done using postgresql connection to tableau repository ?
How often are you updating the data? I have workbooks that have data extracts from actual data sources updating on schedules.
It depend on users what they choose ,I have extract refresh schedule from morning till evening ,Just to let you know these workbook are not mine ,these workbook belongs to my developer(user) , I wont be able to make extract of their connections .
It sounds like you have a difference setup then I do. The other developers can insert their credentials for updating data on schedules and they use extracts.
The act of publishing a workbook automatically publishes "inline" data sources which it contains - so your data sources are getting published one way or the other.
You should be able to create a report which utilizes the PostgreSQL database to do this, though.
The key join will be between:
data_connections.owner_id = workbooks.id
...with owner_id representing the object (the workbook, NOT the user) which owns the connection.