(Glue-2405) Data Replication with Delta Type Trigger

Owned by SNP
May 21, 2024
1 min read

In addition to the standard SAP table data replication, you can replicate data with delta type trigger.

Below, you can find a step-by-step manual on how to set up and execute the extraction of data using the trigger delta type.

  1. Create a target SNP Glue™ Table.

  2. Create SAP Table Fetcher with Delta Type Trigger.
    You do not need to activate the trigger at this point.

  3. Create SNP Glue™ Table Consumer using target Glue table.

  4. Create Extraction Process.

  5. Execute extraction with load type Delta Init Without Data to activate the trigger (start capturing the changes).

  6. Execute extraction with load type Full Load (Repair) Without Delta Update to replicate historical records present in the table already.

  7. Schedule Extraction Process using Batch or Streaming replication method in Glue Scheduler with Load type Delta Load to replicate changed records only.