Our goal: Synchronize a delta of SAP tables to an external SQL Server database without complex ABAP reports. We are using a non S4/HANA system.
In our current landscape, we are running RFC-function modules, which are called by an external program to synchronize daily data from SAP to a SQL Server database. Since this landscape keeps growing and growing, I need to find a more professional way to solve this task.
We are synchronizing SAP standard tables and custom tables.
How is this task solved properly? Is there a way to log every transaction on a table and synchronize the changed data periodically?
Currently, we are looking for a way to activate a trigger on the SAP database, but I am not sure if this is a good way to solve this problem.
NIRR is a new contributor to this site. Take care in asking for clarification, commenting, and answering.
Check out our Code of Conduct.