Retrieve DML statements from the target table

Prerequisites: You must have access to the SQL Server database and a valid SQL Server CDC Account.

The following example pipeline demonstrates how to capture the data changes from the Insert, Update, and Delete statements executed on the EMPLOYEE table within the specified time period.


SQL Server CDC pipeline overview
Download this pipeline
  1. Configure the SQL Server CDC Snap as shown below to execute the Insert, Update, and Delete statements against the EMPLOYEE table within the specified time period.

    SQL Server CDC Snap configuration

  2. Vaidate the pipeline. On validation, the Snap queries the data and displays the retrieved results in the output preview.

To successfully reuse pipelines:
  1. Download and import the pipeline into SnapLogic.
  2. Configure Snap accounts as applicable.
  3. Provide pipeline parameters as applicable.