There's a "password" field in the data_connections table, but that won't tell you what kind of auth is being used. So, nope--you'd need to dig up the workbook XML or open it up manually to find out.
Okay, so I forgot--there is also the "keychain" field in data_connections which contains a string in yaml format that reveals some authentication details. I don't know enough about how that info is stored to be able to tell you much more about it, but in checking our own data, it seemed to be useful for distinguishing credential-based auth from SSPI, at least. Might be a little helpful to you.
1 of 1 people found this helpful
Thanks Matt! I actually have been playing around with this field quite a bit.
We have built out some logic:
-If the "username" field is populated, then there are "embedded credentials".
-If not, then if the data source is a live data source then its either using "Run as Service Account" or "Kerberos Authentication."
We think we can narrow it down a bit more because our users must request to use Kerberos... thus we should know the servers that are using Kerberos.... as long as PostgreSQL populates the "Server" field...
Thanks for the discussion guys!