How do I copy data from ADF to SAP ECC via pipeline

Harshita Vishwakarma 50 Reputation points
2024-02-14T07:11:07.7866667+00:00

There is one API developed for Team Centre through which I am able to fetch the response in my data factory pipeline, now I need to transfer this data to SAP ECC end, the problem here is SAP ECC as a sink is not supported in Azure Data factory dataset(check the screenshot). So how can I copy data from ADF to SAP ECC. https://learn.microsoft.com/en-us/azure/data-factory/connector-overview

Azure Data Factory
Azure Data Factory
An Azure service for ingesting, preparing, and transforming data at scale.
10,677 questions
0 comments No comments
{count} vote

1 answer

Sort by: Most helpful
  1. Richard Swinbank 522 Reputation points MVP
    2024-02-14T10:59:38.3166667+00:00

    You are correct that the SAP ECC connector is only supported for source capabilities (Copy activity source or Lookup activity).

    Writing to a sink not supported by ADF will required additional work outside ADF. You can use ADF to write your API data to an on premise file store or database, but you will need to implement a second step to get the data from the file store/database and into SAP ECC. The second step will need to be implemented in a technology which includes a capability to update SAP ECC directly.

    Alternatively, you might choose to link Teamcenter and SAP ECC directly, using some other technology and avoiding ADF completely.

    (I don't know much about SAP ECC; I can't comment on what technologies you might use to interact directly with the product).


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.