'How to get max data via sap table connector look up in azure data factory?

I need to implement an incremental load for sap tables via the sap table connector in azure data factory within a copy activity.

Currently, I am trying to set the watermark of the sap table (e.g. MAX(ERDAT)) through a lookup activity. Unfortunately, I cannot create a custom query, because the sap table connector is very limited and only supports basic filtering options (link).

Does someone know how to set a watermark via the sap table connector?

Thanks in advance!

azureazure-data-factorysap-dotnet-connector


Solution 1:[1]

https://docs.microsoft.com/en-us/azure/data-factory/load-sap-bw-data

This document providing the information regarding the watermark in SAP table connector. Check it out for the implementation.

Sources

This article follows the attribution requirements of Stack Overflow and is licensed under CC BY-SA 3.0.

Source: Stack Overflow

Solution Source
Solution 1 SairamTadepalli-MT

Related Questions