Siebel Server Sync Guide > Customizing Siebel Server Sync for Microsoft Exchange Server >

About Customizing Delta Queries

The SSSE PIMSI Engine component uses delta queries to find out which Siebel records and fields have changed since the last time an SSSE user's data was synchronized. The delta queries that are supplied with SSSE check certain standard fields for changes to be synchronized—fields that record the date and time that certain database tables were last updated. When SSSE detects a value in a monitored date-time field that is later than the most recent successful synchronization, all of the mapped fields in the changed record are synchronized, including any custom fields that you have set up for synchronization.

However, unmonitored date-time fields cannot trigger synchronization. If your Siebel implementation has added tables to business components that SSSE synchronizes, then you must customize the appropriate delta queries to monitor the date-time fields that track changes in those tables.

You must also modify a delta query if you add a new multi-value group (MVG) field that you want monitored for changes because changes in custom MVGs are tracked in different date-time update fields than changes in single-value fields or in existing MVGs. For a new MVG, you must also take certain prerequisite actions in Siebel Tools.

You can also modify delta queries to direct SSSE to ignore changed update date-time values in tables that would ordinarily trigger synchronization. For more information on customizing delta queries, see Changing Delta Query Profile Configuration Parameters.

NOTE:  If you have to modify a delta query, you might also have to modify a user filter. For more information, see About SSSE User Filtering and Changing User Filtering Configurations.