Skip to main content

Schema Map Properties- Data Compare Column Options

In the Schema Map properties, you can change the Data Compare Settings on a column-by-column basis to control the comparison of data in Data Sync.

caution

Generally you do not need to change the Schema Properties. Please only change them if you fully understand how this will affect your results and synchronisation.

If you are unsure if you need to change the default settings, please contact us at support@simego.com and we cna hep you further.

Ignore​

The Ignore setting prevents Data Sync from comparing the value and generating an UPDATE action for this column. However, if any other column causes an UPDATE action, the value of this column will be added to the change set. This is useful when you want to force a column's value to always be sent to the target.

Mode​

The Mode controls how the source and target values are compared for UPDATE actions. By default, Data Sync compares if the values from each side are equal. However, there are different modes available to suit different scenarios:

  • TargetNotEqual: This is the default mode where a change is detected when the values are not equal.
  • TargetEqual: A change is detected when the values are equal.
  • TargetLessThan: A change is detected when the target value is less than the source. This is typically used in 2-way sync scenarios to prevent updates to a row when the modified date is greater on the target.
  • TargetGreaterThan: A change is detected when the target value is greater than the source.
  • TargetIsNullOrEmpty: A change is detected when the target value is null or empty and the source has a value.
  • SourceIsNotNullOrEmpty: A change is detected when the source has a value and the target is not equal to the source.

You can find the Data Compare Mode options in the image below:

Data Compare Mode options

Trigger Update​

The Data Compare Mode is typically used in conjunction with the Trigger Update setting, which controls what change(s) will cause an UPDATE action to be created.

For example, in a 2-way sync scenario where you have a modified DateTime value on each side which is updated when the row is changed, you would create two projects running in different directions.

In the first project, you would set TriggerUpdate=False on all columns in the Schema Map except for the Modified column, and then set the Mode=TargetLessThan for the Modified Column. This ensures that Data Sync only compares the values on this row when the target Modified value is less than the source, i.e., the source is more recent.

In the second project, you can set up the project as normal but in reverse. You then set the projects to run after each other in Ouvvi or the Run Tool.