Skip to Content
0

Access stored database credential from SDK

Oct 04, 2017 at 10:06 AM

36

avatar image

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 !

10 |10000 characters needed characters left characters exceeded
* Please Login or Register to Answer, Follow or Comment.

1 Answer

Best Answer
Dell Stinnett-Christy Oct 17, 2017 at 03:42 PM
3

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

Show 1 Share
10 |10000 characters needed characters left characters exceeded

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

0