This feature requires an Advanced Data Sources.
Accessing passwords stored in your data source by querying the underlying database is not possible because of the encryption we apply on the passwords. For those of you that need to access passwords directly in the database, for example by a CRM system, we have created a way to achieve this.
The session information, which is an XML structure, is stored in the Data field of the Connections table in the underlying database.
However, getting the encrypted password from the database requires that the Allow password for external system be configured.
Password Policy - Allow password for external system
Enter an encryption key in the Key field. Once a key is provided it will cause the system to extract a copy of the password from our XML structure, this will then be re-encrypted using the key you have provided and stored back into the UnsafePassword field of the Connections table.
Use the following .net code to decrypt your passwords.