How to send data to an SAP C4C tenant through their OData API using SSIS

Question

Hello,

I need to be able to send data from an SQL Server Table (OLE DB Source) to an SAP C4C tenant using their OData API in SSIS. In the toolbox there is an OData Source through which data can be retrieved from the tenant but can't be sent back. Is there something like an OData Destination tool that can be downloaded or a way to send data back to the API?

Answer 1

Hi,

Please go through below link you may get help:

https://community.sap.com/t5/technology-q-a/how-to-access-ms-sql-data-using-sap-abap-statement-in-sap/qaq-p/379420

Answer 2

Hi @Amogh Sharma,

I'm not familiar with SAP C4C, with my research it seems a little bit hard to set the SAP C4C as destination source.

You may consider using 3rd party component for a try.