Retrieve data changes from the target table

Prerequisites: You must have access to the Oracle database and a valid Oracle 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.


Oracle CDC pipeline overview
Download this pipeline
  1. Configure the Oracle CDC as shown below to execute the Insert, Update, and Delete statements against the CDCDEMODB.EMPLOYEE table within the period 2024-12-20 11:00:00 to 2024-12-20 12:00:00.

    Oracle 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.