Drag the CDC Replication Server Provider component onto the Design window.
Specify the name of the Replication Server you want to use to capture data changes, along with its user name, and password.
Set the replication definition options in the Source Table Options field. See “Setting replication definition options”.
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'
If you select Last as the capture mode, the output is:
update test_table set col_1='y' where key_col='A'
Sybase recommends to 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.
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.
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.
For a 32-bit grid engine, it is recommended to set the
stage mode to IQ.
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.
In the Ports Options field, specify the OUT-ports details. See “Configuring the OUT-ports”.
Specify any other optional properties. See “CDC Provider Replication Server properties list”.
Create replication. See “Creating and dropping replication”.
