Access stored database credential from SDK

[sylvain_dutilh]

Hello,

Is it possible to access the user's database credentials from the SDK ?

I would like to create an extension point for Webi, that checks when a report is opened if the user can connect to the datasource or not, and then inviting the user to enter the credentials again.

We have SSO to the platforms, and we can't have SSO to the database for technical reasons, so we wish to use the "Database credential mapping" option to connect to the DB. Because we use SSO to the launchpad, the database credentials are not stored for users. Hence the idea of an extension point to try the connection before refresh and prompt users for credentials if they are invalid.

Version is SAP BI platform 4.2 SP3 patch 2 hotfix 1.

Windows 2012 R2 servers.

Thank you !

[DellSC · Accepted solution]

I don't think this is possible. The password is stored in an encrypted format and there is no option through the SDK to decrypt it. SAP has some internal options that it uses for this, but it doesn't expose them to be available to folks extending the application through the SDK.

-Dell

[sylvain_dutilh · Accepted solution]

It makes perfect sense.

I was just hoping that there would be an option to try and connect to a datasource (and implicitly specify to use the stored credentials without actually retrieving them decrypted) and invite people to re-enter them if the connect fails.

We'll have to find another solution then...

Thank you Dell for your answer.

-Sylvain