Create the replication request - Connect_CDC - connect_cdc_mimix_share - Latest

Connect CDC Advanced User Guide

Product type
Software
Portfolio
Integrate
Product family
Connect
Product
Connect > Connect CDC (MIMIX Share)
Version
Latest
Language
English
Product name
Connect CDC
Title
Connect CDC Advanced User Guide
Copyright
2024
First publish date
2003
Last edition
2024-07-19
Last publish date
2024-07-19T23:30:25.334335

To define the replication request:

  1. From the context menu of the Requests subbranch of the distribution you just defined, select New Request>Replication.

  2. Connect CDC now has an option where a load utility, Teradata Parallel Transporter (TPT), can now be used as an alternative to the standard apply method. This option will replicate captured data to csv files and then launch TPT jobs to load the data directly to a Teradata target. For additional usage details refer to Usage restrictions for TPT.

    1. Select the Load Utility tab. This tab only appears if you have selected Use “Load Utility” where possible.

    2. The Load Utility dialog displays.

    3. In the Apply error mode section, select the appropriate error mode you wish to apply for a specific request to the target database.

    Skip file, continue with next—For a specific request, skip the file that had the error while applying data, and proceed to apply data from the next file.

    Skip and Delete file, continue with next—For a specific request, skip the and delete file that that had the error while applying data, and proceed to apply data from the next file.

    Shut down apply component—For a specific request, stop applying data to the target database. This is the default.

  3. Use the Common tab of the Replication Request Properties dialog box to name the request.

  4. Review the collision resolution settings on the Distribution Request Properties dialog box.

On the Replication tab, the Protected collision resolution setting defaults to Automatic. This resolution method uses shadow table timestamps to resolve collisions, choosing whichever of the conflicting record updates is the latest. If you select Manual, you are responsible for evaluating each collision on a case by case basis to determine how to resolve the conflict. For more information about these collision options, see Detect collisions.