2628688 - Unable to connect to OData Services in SAP Analytics Cloud (SAC)

SAP Knowledge Base Article - Public

2628688 - Unable to connect to OData Services in SAP Analytics Cloud (SAC)

Symptom

Unable to connect to OData Services with error: Error send request to proxy. Status 403 Reason: Forbidden. Check the connection details and user credentials the try again in SAP Analytics Cloud (SAC)

Environment

  • SAP Analytics Cloud 2018.5.1

Reproducing the Issue

  1. Connect SAP Cloud Connector to SAP Analytics Cloud per  https://help.sap.com/doc/00f68c2e08b941f081002fd3691d86a7/release/en-US/ae39ab60b1154c179e2baabd26aa249c.html
  2. Create an SAP Analytics Cloud OData Connection to an On-Premise OData service per https://help.sap.com/doc/00f68c2e08b941f081002fd3691d86a7/release/en-US/1c1e36eeb99e420aa20ebe6e39af2b65.html
  3. Notice the error

Cause

SAP Cloud Connector entry for On-Premise OData service host has not been created.

Resolution

For On-Premise OData service host http://<HOST>:<PORT>/<Package>/<Service> create SAP Cloud Connector Entry:

  1. In the navigation panel select Cloud to On-Premise
  2. Under the Access Control tab, select + (Add)
  3. Fill in the Edit System Mapping dialog
    • Back-end Type: Other SAP System
    • Protocol: HTTP (or HTTPS depending on whether you implemented SSL)
    • Virtual Host: <HOST>
    • Virtual Port: <PORT>
    • Internal Host: <HOST>
    • Internal Port: <PORT>
    • SAProuter: <leave empty>
    • Principal Type: None
    • SNC Partner Name: <leave empty>
    • Description: OData service host
    • Check Internal Host: [Checked]
  4. Click Save
  5. Now when you specify Data Service URL = http://<HOST>:<PORT>/<Package>/<Service> in SAP Analytics Cloud it will use SAP Cloud Connector to look up <HOST>:<PORT> under <Virtual Host>:<Virtual Port> and route the reques to <Internal Host>:<Internal Port>
  6. Select the system you added to the Mapping Virtual To Internal System list
  7. In the Resources Accessible area, select + (Add)
  8. Fill in the Add Resource dialog
    • URL Path: /<Package>
    • Enabled: [Checked]
    • Access Policy: Path and all sub-paths
    • Description: OData service for <purpose>
  9. Click Save
  10. Now when you specify Data Service URL = http://<HOST>:<PORT>/<Package>/<Service> in SAP Analytics Cloud SAP Cloud Connector will permit access to /<Package> and all sub-paths on <Internal Host>:<Internal Port>

See Also

Your feedback is important to help us improve our knowledge base.
Please rate how useful you found this article by using the star rating feature at the beginning of this article.
Thank you.

Keywords

EPM, SAP Cloud for Planning, sc4p, c4p, cforp, cloudforplanning, EPM-ODS, Cloud for Analytics, Cloud4Analytics, CloudforAnalytics, Cloud 4 Planning, BOC, SAPBusinessObjectsCloud, BusinessObjectsCloud, BOBJcloud, BOCloud., SAC, SAP AC, Cloud-Analytics, CloudAnalytics, SAPCloudAnalytics, OData, 403, On-Premise, premise, connector, hcc, scc , KBA , LOD-ANA , SAP Analytics Cloud , LOD-ANA-BI , SAP Analytics Cloud - Business Intelligence (BOC) , LOD-ANA-BR , SAP Analytics Cloud - Digital Boardroom , LOD-ANA-PL , SAP Analytics Cloud – Planning (BOC) , LOD-ANA-PR , SAP Analytics Cloud – Predictive (BOC) , Problem

Product

SAP Analytics Cloud 1.0