Siebel Server Sync Guide > Customizing Siebel Server Sync > Process of Customizing SSSE >
About SSSE User Filtering
SSSE runs a user filtering algorithm periodically to determine which users have Siebel database records that have been changed and that need to be synchronized with Microsoft Exchange. For an implementation of SSSE that is not customized, the default user filtering configuration monitors changes in every table that is referenced by the domains and fields that are synchronized by default. The default user filtering configuration involves 15 Siebel Business Components. Table 28 lists these Business Components and the fields and Objects associated with them. Each business component has a set of fields that record the true database update time of each row in a table or joined table. In addition, each Business Component has a User Id field that specifies the owner of each record in the Business Component.
Table 28. Default SSSE User Filtering Configuration
|
|
Fields Mapped to Database Last Update Time |
PIMSI Sync Info |
PIMSI Sync Info |
DB_LAST_UPDATE |
PIMSI User Filter Action |
PIMSI User Filter Action |
Activity Last Upd, Act Employee Last Upd |
PIMSI User Filter Action |
PIMSI User Filter Action Account |
Account Last Upd |
PIMSI User Filter Action |
PIMSI User Filter Action Contact |
Action Contact Last Upd |
PIMSI User Filter Action |
PIMSI User Filter Action Contact 2 |
Contact Last Upd |
PIMSI User Filter Action |
PIMSI User Filter Action Contact 3 |
Contact Last Upd |
PIMSI User Filter Action |
PIMSI User Filter Action Oppty |
Oppty Last Upd |
PIMSI User Filter Action |
PIMSI User Filter Action Project |
Project Last Upd |
PIMSI User Filter Action |
PIMSI User Filter Action SR |
SR Last Upd |
PIMSI User Filter Contact |
PIMSI User Filter Contact |
Contact Info Last Upd, Contact Last Upd, Party Last Upd |
PIMSI User Filter Contact |
PIMSI User Filter Contact Account |
Account Last Upd |
PIMSI User Filter Contact |
PIMSI User Filter Contact Business Address |
Address Last Upd |
PIMSI User Filter Contact |
PIMSI User Filter Contact Oppty |
Oppty Last Upd |
PIMSI User Filter Contact |
PIMSI User Filter Contact Personal Address |
Address Last Upd |
PIMSI User Filter Contact |
PIMSI User Filter Contact Position |
Contact Position Last Upd |
Each time the user filtering algorithm runs, a set of queries is issued to identify the users whose records have changed since the last filtering. For example, for particular values of last_filtering_time and business_component_name, the query finds information that can be described as follows: All User Ids in business_component_name where DB_LAST_UPDATE >= last_filtering_time
Some Business Components have more than one database update time field. Separate queries are issued for each of these fields, sequentially. As a result, 18 queries are issued each time the user filtering algorithm runs. The union of query results is the set of users who have records that need to be synchronized with the Exchange Server.
|