2412507 - How do I connect SAP Analytics Cloud to a SAP Cloud Platform HANA database using OData?

SAP Knowledge Base Article - Public

2412507 - How do I connect SAP Analytics Cloud to a SAP Cloud Platform HANA database using OData?

Symptom

How to import data using SAP Analytics Cloud connecting to SAP Cloud Platform (SCP) HANA database using OData?

Environment

  • SAP Analytics Cloud

Resolution

Note: Intended for use with small planning datasets.

Create the OData ServiceBased on: HANA Development: XS OData Services

  1. Browse to SAP Cloud Platform Cockpit (https://account.hanatrial.ondemand.com/cockpit or other)
  2. Under DATABASE SYSTEMS cick Database
  3. Click the DB/Schema ID you wish to work with
  4. Click SAP HANA Web-based Development Workbench
  5. Under SAP HANA Web-based Development Workbench click Security
  6. Log in as SYSTEM
  7. Expand Security > Users and select the User you wish to use for development (can be SYSTEM)
  8. Grant Role sap.hana.ide.roles::Developer to the selected user and click Save
  9. Click Logout
  10. Under SAP HANA Web-based Development Workbench click Editor
  11. Log in as your development user (can be SYSTEM)
  12. Create a Package for your OData Services or select an existing Package
  13. Right-click the Package and choose Create Application
    • Template: Empty application (with XSAccess and XSApp)
    • Package: Desired Package for your OData Services
    • Click Create
  14. Delete index.html
  15. Change .xsaccess content to {"exposed" : true} and save
  16. Develop the OData Services
    • For a Table create <myservice>.xsodata as service {"<SCHEMA>"."<TABLE>" as "<Name you want>";}
    • For a Calculation View create <myservice>.xsodata as service {"<PACKAGE>/<ANALYTIC VIEW>.calculationview" as "<Name you want>" key ("<Key Field>");}
  17. Data Service URL: http://<HCP DB URL>/<PACKAGE>/<myservice>.xsodata

Import the data in SAP Analytics Cloud

  1. Connect to your SAP Analytics Cloud Tenant
  2. Select "Connection" from the "Main Menu"
  3. Click "+" to "Add Connection"
  4. Click ""Import Data Connection > OData"
  5. Connection Name: <Name of your choice>
  6. Description: <Description of your choice>
  7. Data Source Type: OData Services
  8. [Unchecked] Connect to an On-Premise OData Service
  9. [Checked] Connect to an SAP OData service
  10. Data Service URL: <See step 17. above>
  11. Authentication Type: Basic Authentication
  12. User Name: <Your HCP User Name>
  13. Password: <Your HCP Password>
  14. Click "Create"

If your issue is not resolved you can start an SAP Analytics Cloud Discussion in the SAP Community.

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 facility at the top right-hand corner of this article.
Thank you.

Keywords

acquire, SAP Cloud for Planning, sc4p, c4p, cforp, cloudforplanning, Hana Cloud for Planning, EPM-ODS, Cloud for Analytics, C4P, Cloud4Analytics, CloudforAnalytics, Cloud 4 Planning, HCP, C4A, BOC, SAPBusinessObjectsCloud, BusinessObjectsCloud, BOBJ, BOBJcloud, BOCloud., BICloud, BO Cloud, OData, import, connect , KBA , hcp , odata , LOD-ANA , SAP Analytics Cloud , LOD-ANA-BI , SAP Analytics Cloud - Business Intelligence (BOC) , LOD-ANA-PL , SAP Analytics Cloud – Planning (BOC) , LOD-ANA-BR , SAP Analytics Cloud - Digital Boardroom , LOD-ANA-PR , SAP Analytics Cloud – Predictive (BOC) , How To

Product

SAP Analytics Cloud 1.0