How Siebel Remote Resolves Conflicts in Data It Synchronizes

Data divergence is a situation that occurs when the local databases on different remote clients become less synchronized. Data divergence can occur if Siebel Remote does not detect or resolve these complex modifications. Siebel Remote uses conflict detection and resolution logic to prevent data divergence.

To support team selling and field service, Siebel Remote allows different users to access the same data. This situation creates the possibility that two users might make conflicting modifications to the same data when they are disconnected from the Siebel Server. To automatically detect update conflicts, Siebel Remote compares transactions at the field level. It uses rules to resolve conflicts for the following modifications:

• Modifications that update values in an existing row

• Modifications that delete an existing row

• Modifications that add a new row

More complex conflicts involve deleting and adding database rows. For example:

• One user might modify a value in a database row and another user might delete the entire row.

• One user might add a database row to a local database, but the primary key for this row is in use by an existing row in the server database or in the local database of another remote client.