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 data types. 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 check boxes under the Include column of the grid, select the table columns to be included in the job flow.
  5. The check boxes under the CDC Enabled column of the grid reflect the table columns on which the CDC feature is enabled.
    The read-only CDC Enabled check boxes 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 back end.
  6. Click OK.
The data of the table columns, which have been selected for Change Data Capture, is captured and saved.