Send data from SAP CPI to SAP Analytics cloud via HTTP/Odata Adapter/webservices

[former_member703923]

Hi Experts,

We are looking for a solution where we want to send the data from SAP CPI to SAP Analytics cloud(after mapping in CPI).

I tried to check many blogs but i could get much information for this scenario(SAP CPI -> SAC).

I referred the below blog but here from SAC system, pre-defined CPI OData API's has been consumed but in our scenario custom data needs to be sent to SAC.

blogs.sap.com/2020/08/26/sap-analytics-cloud-content-for-sap-cloud-platform-integration/#

Is there any way to expose API from SAC system ? so that same can be used in CPI adapter.

Kindly let us know how we can achieve this scenario. Any response is much appreciated.

BR,

MANI REDDY

[former_member6443]

Hi Mani,

Using CPI you can update a particular file in a folder on your on premise server from where SAC will be refresh the model.

If you do expose the DATA via an API , SAC will be able to pick the same out albeit there are a few complications but nothing too major 🙂

Cheers

Afshin

[daviddasilva]

Hi,

I am not familiar with SAC but I do know that it usually pulls data from several systems.

Is there another system that you could send this data into for SAC to then pick up on its own schedule?

For example is there a shared Database that you could use (HANA?) or perhaps a SFTP folder?

That way CPI can always update the relevant information and then SAC can pick up the data whenever suits it.

Kind regards,

David

[former_member703923]

Hi David,

Thank you for the response.

I managed to expose the ODATA service from SAP CPI and generated a URL. The same Odata service will be consumed in SAP SAC and they will put a query from their end. As soon as they schedule/ invoke the URL, CPI artifact will run and pull the data from Database and SAC will get the data.

This is just a POC and need to check if it really works in actual scenario.

Please feel free to raise any concerns in this approach.