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

Amogh Sharma 45 Reputation points
2024-07-22T15:51:14.8166667+00:00

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?

SQL Server
SQL Server
A family of Microsoft relational database management and analysis systems for e-commerce, line-of-business, and data warehousing solutions.
13,974 questions
SQL Server Integration Services
SQL Server Integration Services
A Microsoft platform for building enterprise-level data integration and data transformations solutions.
2,590 questions
0 comments No comments
{count} votes

2 answers

Sort by: Most helpful
  1. Zahid Butt 956 Reputation points
    2024-07-22T16:44:27.72+00:00
    0 comments No comments

  2. ZoeHui-MSFT 37,441 Reputation points
    2024-07-23T05:34:38.1+00:00

    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.


Your answer

Answers can be marked as Accepted Answers by the question author, which helps users to know the answer solved the author's problem.