Adding a CDC Resource

Note: To use the Change Data Capture feature, ensure the SQL Server Agent is running on the MS SQL server.
  1. Open the Change Data Capture Management popup, through either of the below two ways:
    • Navigate to Tools > Change Data Capture Management.
    • Add the DB Change Data Reader stage to a job, open the stage settings, and click Manage.
  2. Click Add.
  3. Enter a Name for the CDC Resource.
  4. In the Connection field, select the SQL database connection you want to use. To make a new database connection, click Manage. For more information on creating database connections, see Database Connection Manager.
  5. In the Table/View field, specify the table whose columns are to be included in the jobflow. Click the browse button ([...]) to navigate to the table or view that you want to use.
    The grid below displays all the columns of the selected table, along with the datatypes of each column.
  6. If you select an Oracle connection in the Connection field, the Start date field becomes available.
    The field is filled with the default value of the current date with the time 12:00 AM. You can enter a start date and time of your choice.

    The end date and time is taken as the current date and time.

    Attention: You should have execution rights on the Oracle LogMiner utility to be able to use the CDC feature on an Oracle connection. For more information, see Oracle LogMiner Configurations.
    Note: The Start date field is not available on selecting an MS SQL connection in the Connection field.
  7. Click OK.
The created CDC Resource table is now ready for use in the DB Change Data Reader stage, whose columns can be included or excluded from the jobflow.

The stage displays the table columns on which the CDC feature has been enabled.