The following article illustrates the process of delta table extractions using the TableCDC component.

Table CDC Process #

The depicted graphic illustrates the processes in both the Xtract product and in SAP. Open the graphic in a new tab to zoom in.

Report-Workflow

The delta mechanism of TableCDC includes the following processes:

  • Lookup process to read SAP metadata for the definition of the TableCDC extraction.
  • CDC watch process to create a database trigger on the source table and to create the corresponding log table in SAP.
  • Synchronize data process to run the TableCDC extractions regularly.

Tip: Use the SAP transaction DB02 to view all triggers of TableCDC log tables in SAP.