3745411 - [Best Practice] How to capture the OData query when trying to acquire data from CAP OData Service exposed in SAP HANA Cloud into SAP Analytics Cloud (SAC)

• You may have used SAP Cloud Application Programming Model (CAP) to expose SAP HANA Cloud tables as OData Services:
  • Maintaining OData Services in SAP HANA Cloud 
  • Use CAP to expose HANA Cloud tables as OData services 
  • Create Calculation views and OData services in a single project with HANA Cloud
• You want to import data from such OData Services into SAC by using Import Data connection with Data Service URL in format: https://<...>.cfapps.sap.hana.ondemand.com:443/odata/v2/<OData Service>
• What trace can be used to capture the OData query (call) in SAP HANA Cloud?

• SAP Analytics Cloud (Enterprise) 
• SAP HANA Cloud

1. Try to  reproduce the issue by either creating a new model or refreshing import job in existing model based on import connection to OData exposed from SAP HANA Cloud.
2. Log on to BTP Cockpit using your BTP Global Account.
3. Go to <Subaccount>/<Space>/<OData Application>, where the OData Service is deployed as one application.
4. Click Logs menu.
   • You could find OData call in Message column (you can also download it where same information could be observed).
     • Format: <Time with time zone> ... OUT <OData Service Host> ... "GET <OData call>  HTTP/1.1" <HTTP Status Code> ... "SAP-DA-Client" ...
     • 'SAP-DA-Client' means the OData request from SAC.
   • Then, you can test the OData call on the browsers or other OData clients, like PostMan, Bruno.

If same issue could be observed when testing the OData call directly out side of SAC, please submit one support case to BC-XS-CDX-NJS / BC-XS-CDX-JAV.

• 3226911 - [Best Practice] How to capture the OData call when using import data connection to acquire data from SAP SuccessFactors in SAP Analytics Cloud (SAC)
• 3438044 - [Best Practice] How to capture the OData call when using import data connection to acquire data from SAP Cloud for Customer in SAP Analytics Cloud (SAC)
• 2325562 - Frequently Asked Questions on C4C OData Services
• 2569847 - Where can you find SAC user assistance (help) to use, configure, and operate it more effectively?
• Have a question? Ask it here and let our amazing SAP community help! Or reply and share your knowledge!
• 2487011 - What information do I need to provide when opening an case for SAP Analytics Cloud?
• Search for SAP Analytics Cloud content using Google or Bing:
  • https://www.google.ca/search?q=site%3Ahttps%3A%2F%2Fapps.support.sap.com+SAP+Analytics+Cloud
  • https://www.bing.com/search?q=site%3Ahttps%3A%2F%2Fapps.support.sap.com+SAP+Analytics+Cloud
  • Note: Add relevant text or warning/error messages to the text search field to filter results.
• Need More Help? Contact Support or visit the solution finder today!

AP Cloud for Planning, sc4p, c4p, cforp, cloudforplanning, Cloud for Analytics, Cloud4Analytics, CloudforAnalytics, Cloud 4 Planning, BOC, SAPBusinessObjectsCloud, BusinessObjectsCloud, BOBJcloud, BOCloud., SAC, SAP AC, Cloud-Analytics, CloudAnalytics, SAPCloudAnalytics, OData, HANA Cloud, HANA, BTP, Cockpit, subaccount, import, acquire, model, job, trace, api,CAP , KBA , LOD-ANA-AQU-ODATA , Acquiring Data into SAC using an ODATA connection , LOD-ANA-AQU , Import Data Connections (Acquiring Data) , How To