SAP Analytics Cloud OData Import job to ask user credentials

[erginozturk]

Dear experts,

I have a model which is extracting data from Odata datasource. After first load it is stored as a job, but even in my Odata connection I have selected Basic authentication, this job does not ask for user password but uses the first uploaders credentials.

My Odata service is located at SAP on-premise and according to username supplied data region should change.

We do not want to create Import jobs for every user but we expect system to ask user/password when a user triggers Refresh job. Is there a setting for this job to be triggered by user password entry?

We found out in OSS Note 2884665 there is a setting in Odata connection string, but it did not helped..

"OData Service URL uses ?auth=b parameter to force Basic Authentication to be used, bypassing SAML authentication"

[erginozturk]

Hi Martijn,

You may have a point but you may have been misunderstood the need.

In on premise system 250+ users enter some data to specific costcenters, and when their entry is finished they should upload on-prem data to cloud "only once". We do not need to schedule anything.

In models they have costcenter authorizations/restrictions so when uploading data only their costcenters should be uploaded, otherwise uploaded data is rejected.

So the matter is not related with accessing data from story, but uploading data with only related costcenters when user triggers it and with the restriction of Odata service data.

Best Regards,

Ergin

[mfoeken]

Hi Ergin,

When you are using an OData connection you are importing data into the model. If you want to limit the data that is displayed when a user accesses the model and story you should create data restrictions in the model based on user/team and dimensions. If you import data into a model with different users and different authorizations, each time users access the story they get a different dataset which is not compliant with your restrictions.

Kind regards,

Martijn van Foeken | Interdobs