Configuring a CDC Provider Replication Server Component

Add and configure a CDC Provider Replication Server component.

1. Drag the CDC Replication Server Provider component onto the Design window.
2. Specify the name of the Replication Server to use to capture data changes, along with its user name, and password.
3. Set the replication definition options in the Source Table Options field.
4. To filter qualified data changes, select one of these capture modes:

   • Full – receives all changes and sends them one by one. The output changes are same as the input changes from Replication Server.

   • Last – sends only the last received data changes of each row. All changes with the same key values are merged into a single change.

     For example, if there are two changes:

     1.update test_table set col_1='x' where key_col='A'

     2.update test_table set col_1='y' where key_col='A'

     and if you selected Last as the capture mode, the output is:

     update test_table set col_1='y' where key_col='A'

   Sybase recommends that you set this property to Last, which is appropriate for most incremental loading. If set to Last, the Insert and Update changes are regarded as Upsert changes.

   Note:

   If you select Full, and if there are several changes on the same row, you must ensure the sequence while loading to the target database.

5. If capture mode is set to Last, enter the Stage Mode property to specify whether you want the component to stage all received data changes in memory, or in IQ.
   Note:

   For a 32-bit grid engine, Sybase recommends that you set the stage mode to IQ.

6. Specify the staged IQ configurations in the IQ for Stage Mode Options field, if the Capture Mode is set to Last, and the Stage Mode is set to IQ.
7. In the Ports Options field, specify the output ports details.
8. Specify any other optional properties.