SAP Table Connector - How to call RFC Function module in SAP from Azure data Factory

vivekAzure 1 Reputation point
2021-12-08T05:25:34.793+00:00

Hello Experts,

We are using SAP Table Connector under Azure Data Factory to extract SAP Tables successfully. However we would like to explore "Custom function module" option under copy activity. How can we call RFC function module in SAP from Azure data factory?

We keyed in some SAP function modules under "Custom function Module" property but it doesn't work? We can only create dataset for SAP tables not for SAP Function modules. How can we overcome this issue?155759-adf-table-connector-custom-function-module.jpg

Regards,
Vivek

SAP HANA on Azure Large Instances
SAP HANA on Azure Large Instances
Microsoft branding terminology for an Azure offer to run HANA instances on SAP HANA hardware deployed in Large Instance stamps in different Azure regions.
120 questions
Azure Data Factory
Azure Data Factory
An Azure service for ingesting, preparing, and transforming data at scale.
10,024 questions

1 answer

Sort by: Most helpful
Most helpful Newest Oldest
  1. ShaikMaheer-MSFT 38,321 Reputation points Microsoft Employee
    2021-12-08T16:10:09.147+00:00

    Hi @vivekAzure ,

    Thank you for posting query in Microsoft Q&A Platform.

    customRfcReadTableFunctionModule option inside copy activity helps to define a custom RFC function module that can be used to read data from an SAP table. Click here to know more about it.

    You can use a custom RFC function module to define how the data is retrieved from your SAP system and returned to the service. The custom function module must have an interface implemented (import, export, tables) that's similar to /SAPDS/RFC_READ_TABLE2, which is the default interface used by the service.

    In your case, I see you are using directly default interface that is /SAPDS/RFC_READ_TABLE2 in customRfcReadTableFunctionModule field. This interface will used by service by default.

    You can consider defining some customer interface implemented under customRfcReadTableFunctionModule field.

    Hope this will help. Please let us know how it goes or if any further queries. Thank you.