SAP Knowledge Base Article - Public

3645870 - User Authentication in SAC OData Connection to Datasphere

Symptom

 

  • An issue is occurring with establishing an import connection between SAP Analytics Cloud (SAC) and Datasphere with an user that only has SAC access: "result": "{\"error\":{\"code\":\"ERROR_CONNECT_TO_SERVER\",\"rawError\":\"An error occured while connecting to the data source: Error read metadata: An exception of type \\u0027XMLStreamException\\u0027 occurred.\",\"params\":[]}}"
  • The connection is successful only when using a user account that has credentials for both SAC and Datasphere.

 

Environment

SAP Analytics Cloud 2025.14.4 

Reproducing the Issue

    1. Log into SAC;
    2. Try to create an OData Connection to Datasphere with a user who only has access to SAC;
    3. It throws the error above.

Cause

If the SAC user does not exist in Datasphere, the OData connection cannot be created. The user creating the import connection will not have access to any models in DSP and will not be able to find any content. 

When the pop-up opens during the creation of the import connection and the user logs in (by opening and closing it), Datasphere generates a code that is later used to identify the user and create the token via the authorization code flow. All accesses performed with this token will then carry the permissions of the logged-in user.

Resolution

To be able to create an OData Import Connection from Datasphere, the SAC user must have a DSP user as well.

See Also

Your feedback is important to help us improve our knowledge base.

Keywords

SAC, OData, Datasphere, Analytics, error, user, permission, connect to server, metadata, connection, authentication , KBA , LOD-ANA-AQU-ODATA , Acquiring Data into SAC using an ODATA connection , Problem

Product

SAP Analytics Cloud all versions