Error Handling
DataSync settings are accessed by clicking Gear Icon -> Settings.
The Error Handling page controls how DataSync handles certain types of errors. Here is a description of the available items:
Compare COUNT(*) of source and target after syncSelect this option to compare source and target table counts. This option can only be selected if the sync is performed during a "batch window" and the source database remains static during that time.
Retry failed syncs If you want to retry failed synchronizations, select this option and enter the number of amount of times you wish to retry a failed synchronization.
Create non-unique index if duplicate data detected Selecting this option instructs CONNX to create a non-unique primary key instead of a unique primary key during a full update if duplicate data is detected.