Skip to Content

SAP Analytics Cloud OData Import job to ask user credentials

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"

Add a comment
10|10000 characters needed characters exceeded

Assigned Tags

Related questions

2 Answers

  • Posted on Jul 21, 2020 at 02:02 PM

    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

    Add a comment
    10|10000 characters needed characters exceeded

  • Posted on Jul 21, 2020 at 02:17 PM

    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,


    Add a comment
    10|10000 characters needed characters exceeded

Before answering

You should only submit an answer when you are proposing a solution to the poster's problem. If you want the poster to clarify the question or provide more information, please leave a comment instead, requesting additional details. When answering, please include specifics, such as step-by-step instructions, context for the solution, and links to useful resources. Also, please make sure that you answer complies with our Rules of Engagement.
You must be Logged in to submit an answer.

Up to 10 attachments (including images) can be used with a maximum of 1.0 MB each and 10.5 MB total.