Share via

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.

0 comments No comments

1 answer

Sort by: Most helpful
  1. Richard Swinbank 527 Reputation points
    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).

    Was this answer helpful?


Your answer

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