Selecting Change Data Reader Options

The DB Change Data Reader Options reflects the table columns of the selected CDC Resource for which the CDC feature is enabled.

You can select which columns to include or exclude in the current jobflow.

  1. In a job, add the DB Change Data Reader stage.
  2. Open the DB Change Data Reader Options by double-clicking the stage icon.
  3. Select the desired CDC Resource from the Select a resource.. dropdown.
    You can add or modify a CDC Resource by clicking Manage.
    The grid below displays all the table columns with their datatypes. It also displays whether a particular column is included in the job flow, and whether the column is selected for the Change Data Capture feature.
  4. Using the checkboxes under the Include column of the grid, select the table columns to be included in the job flow.
  5. The checkboxes under the CDC Enabled column of the grid reflect the table columns on which the CDC feature is enabled.
    The read-only CDC Enabled checkboxes are checked for columns on which the CDC feature is enabled.
    Note: For MS SQL data sources, refer here for the steps to enable or disable the Change Data Capture feature on particular table columns from the backend.
  6. Click OK.
The data of the table columns, which have been selected for Change Data Capture, is captured and saved.