Extract data from SAP to ADF

Palav Kothari 1 Reputation point
2022-08-03T07:04:21.417+00:00

Hi Team,

We are creating new pipline for extracting SAP table into Azure. We are able to pass table name but we are not pass other parameters like ROWSKIP & ROWCOUNT.
So can you please suggest on that . I attached screen for the same.

227480-sap-fun.png

Regards
Palav kothari

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

1 answer

Sort by: Most helpful
  1. Bhargava-MSFT 31,356 Reputation points Microsoft Employee Moderator
    2022-08-03T21:58:49.657+00:00

    Hello @Palav Kothari ,

    Thanks for the question and using MS Q&A platform.

    As per your requirement, you can use a custom function module to take a query as Options and apply your own logic to retrieve the data.

    Please see the below documentation to implement this custom function module.

    https://learn.microsoft.com/en-us/azure/data-factory/connector-sap-table?tabs=data-factory#create-custom-function-module

    Please let us know if you have any further questions.


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.