SAP Knowledge Base Article - Public

2377790 - "Error occurred in OData driver: Invalid resource URI." when creating new OData connection to SAP Business ByDesign Analytics in SAP Analytics Cloud

Symptom

  • Connecting to SAP Business ByDesign Analytics through an OData connection is failing with Error occurred in OData driver: Invalid resource URI.
    ODATA_1.jpg

  • The following Stack appears in System >> Traces:
    Exception
    @/sap/fpa/services/core/system/Exception.xsjslib:105
    ExceptionCloudAgentBase
    @/sap/fpa/services/dm/agent/CloudAgentBase.xsjslib:21
    @/sap/fpa/services/dm/agent/CloudAgentBase.xsjslib:130
    @/sap/fpa/services/dm/RestDataIntegration.xsjslib:164
    handleRequest
    @/sap/fpa/services/GetResponse.xsjs:270
    @/sap/fpa/services/GetResponse.xsjs:309

Environment

SAP Analytics Cloud (formerly known as SAP BusinessObjects Cloud)

Reproducing the Issue

  1. Login to SAP Analytics Cloud.
  2. Go To Connections.
  3. Create a new OData Connection.
    1. Connection Name: Provide a Connection Name
    2. Data Source Type:  SAP Business ByDesign Analytics
    3. Data service URL: https://my<xxxxxx>.sapbydesign.com/sap/byd/odata/<xxxxx>.svc/<QueryName>
    4. Authentication Type: Basic Authentication
    5. User name: <ByDesign Analytics User name>
    6. Password: <ByDesign Analytics password>
      ODATA_2.jpg
    7. Click on "OK"
  4. Notice the Error: Error occurred in OData driver: Invalid resource URI

Cause

  • The provided Data service URL is incorrect
  • Data service URL should not contain the entity metadata or any specific entity

Resolution

The correct Data Service URL should end by ".svc", which contains all the OData entities within that container

  • For Example: https://my<xxxxxx>.sapbydesign.com/sap/byd/odata/<xxxxx>.svc
  • Specific query can be selected when creating model in Modeler

See Also

Your feedback is important to help us improve our Knowledge Base Articles (KBA).
Please rate how useful you found this KBA by using the star rating facility at the top of this article.
Thank you.

Keywords

C4A, Cloud, for, Anaytics, C4P,  cloudforplanning, cloudforanalytics, BOC, BOBJC, BOBJ, O, data, By, Design, ByDesignAnalytics, BDA, connect, not, working, failing, , KBA , LOD-ANA-BI , Business Intelligence Functionality, Analytic Models , LOD-ANA , SAP Analytics Cloud (SAC) , Problem

Product

SAP Analytics Cloud 1.0