Sap ByDesign Data Ingestion

Franklin John 25 Reputation points
2023-06-02T04:40:16.0933333+00:00

​We need to fetch data from Sap ByDesign using Azure Data Factory, Also we need to fetch the full set and incremental data. Please suggest the best solution for this. 

Azure Data Factory
Azure Data Factory
An Azure service for ingesting, preparing, and transforming data at scale.
9,642 questions

1 answer

Sort by: Most helpful
Most helpful Newest Oldest
  1. KranthiPakala-MSFT 46,422 Reputation points Microsoft Employee
    2023-06-02T22:23:06.19+00:00

    @Franklin John Welcome to Microsoft Q&A forum and thanks for reaching out here.

    Currently, only the below out of box SAP connectors are available in ADF for SAP data extraction.
    Ref doc: SAP connectors overview
    User's image

    Hence there is no native ADF connector for SAP ByDesign at this point.

    Workaround 1: To move data to/from a data store that the service does not support, or to transform/process data in a way that isn't supported by the service, you can create a Custom activity with your own data movement or transformation logic and use the activity in a pipeline.

    Workaround 2: By looking at the document, my understanding is that it has API support. If that's the case, then you may explore REST/HTTP/OData connectors to extract the data.

    If you have a feature request for a new connector to extract data from SAP ByDesign, highly recommend you submit feedback in IDEAS forum here: https://feedback.azure.com/d365community/forum/1219ec2d-6c26-ec11-b6e6-000d3a4f032c

    All the feedback shared in this forum are actively monitored and reviewed by respective product owners.

    Hope this helps.

    Please don’t forget to Accept Answer and Yes for "was this answer helpful" wherever the information provided helps you, this can be beneficial to other community members.