Login Challenge on Lumira Server-based Refresh?

[Former Member]

Hey folks, we're very new to Lumira implementation and having some startup challenges. Our implementation partner is telling us certain things aren't supported or possible and yet I find it very hard to believe.

The use case is a Lumira story pulling data from a SQL 2008 database and published to the SAP BI Platform. We want consumers of the published story to be able to refresh the data without being prompted for login, but that doesn't seem to be possible. Can someone confirm this? Is it not possible to pass the current user identity over to the database? Or even use a service account on the back end without prompting the users on the front end?

Thanks!

[varunanand · Accepted solution]

Hi Darin,

At present, even I don't think we have an option to refresh the document without being prompted for login in the BI platform.

Please refer to this article,

Thank you,

Varun Anand

[Former Member · Accepted solution]

Based on that document...

Universe based on Query Panel Extension

• DB Authentication
  • The behavior depends on the authentication mode configured on Connection
    • Pre-Defined: Passed the pre-defined credential to DB for refresh
    • SSO: does SSO to DB with user credentials and mapping
  • In both the case user wouldn’t be prompted for credentials

So, it's possible if using a universe, correct? The "pre-defined" method would be using some form of service account, and "SSO" would pass the current report user? Can someone explain "mapping" component of that last item?

[varunanand · Accepted solution]

Yes Darin, if using an universe layer or other SAP sources we can enable SSO to avoid the prompts. If it is Free Hand SQL then we would need to enter the credentials for every refresh.

Thank you,

Varun Anand

[ashutosh_rastogi · Accepted solution]

Hi Darin,

If you connect to SQL 2008 directly and publish this to BI Platform then you will not be able to use the option of SSO.

However, if you connect to universe to create your document. You will be able to use the following options

• A service user account configured at the connection level
• Credential mapping for BI platform (Details available at https://apps.support.sap.com/sap/support/knowledge/public/en/0001387622)

Hope this helps,

Regards,

Ashutosh