Character Sort Order in HEI

HCL Enterprise Integrator (HEI) cannot control the sort order specified in the databases that it accesses. If the sort orders used in two databases are not the same, mismatches can arise during Replication activities, causing excessive insert/delete operations and thereby affecting performance. The use of the Order MetaConnector for databases which sort differently is designed to solve sort order differences. Replication also provides an option for case-insensitive string comparison when excessive insert/delete pairs occur during replication between databases that use case-insensitive sorting.

See the Replication activity chapter of the HCL Enterprise Integrator® Activities and User Guide for more information about this feature. Also see the Connectors and Connectivity Guide for information about the Connectors and Metaconnectors.