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

Creating Custom Delete Triggers

The following procedure describes how to create a custom delete trigger. For more information about custom delete triggers, see About Creating Custom Delete Triggers.

CAUTION:  If you want to create custom delete triggers, you must contact your Oracle sales representative for Oracle Advanced Customer Services to request assistance from Oracle's Application Expert Services. If you do not, you might invalidate your support agreement.

To create a custom delete trigger

1. Determine which Siebel domain is associated with the record to be deleted, and use the following table to determine the corresponding SEBL_DOMAIN_IDEN value to use in a later step.

   Siebel Domain Name	SEBL_DOMAIN_IDEN Value
   Siebel Business Contact	PIMSI Intermediate Business Contact
   Siebel Calendar	PIMSI Intermediate Calendar
   Siebel Employee	PIMSI Intermediate Employee
   Siebel Personal Contact	PIMSI Intermediate PersonalContact NOTE:  There is no space between Personal and Contact in this value.
   Siebel Task	PIMSI Intermediate Task

2. Locate the script that creates the database triggers that are supplied along with SSSE for your database environment.

   The following table lists the script names for each database environment. These scripts are typically located in the siebsrvr/BIN directory on your Siebel Server.

   Database	Script Name
   DB2	ssse_triggers_db2.sql
   DB2 390	ssse_triggers_db2_390.sql
   Microsoft SQL Server	ssse_triggers_mssql.sql
   Oracle	ssse_triggers_ora9.sql

3. In the appropriate script file for your database environment, review existing delete triggers to see examples of the specific language required for each domain and operation.

   The following table lists some existing trigger names and the contexts in which they direct SSSE to delete specified PIM records.

   Delete Trigger Name	Trigger Requests Deletion of PIM Record if:
   SSSE_ACT_EMP_PIM3	A user changes the owner of an activity record (calendar or task)
   SSSE_CONT_INFO_T1	A user removes a business contact, employee, or personal contact record from his or her Sync List
   SSSE_CONTACT_PIM1	A user converts a personal contact record to a business contact record
   SSSE_CONTACT_PIM3	A user changes the owner of a personal contact record
   SSSE_EVT_ACT_PIM1	A user converts a calendar record to a task record, or a task record to a calendar record

4. Write the new delete trigger you require, using an appropriate existing trigger as a model.

   For an example of one existing trigger, see Sample Delete Trigger.

5. Use a tool such as SQL Query Analyzer to apply the new trigger to the database.
6. Test the trigger by completing the following substeps:
   1. Create a Siebel record of the type that your new trigger is designed to monitor, such as a business contact record.
   2. If necessary, add the record to your Sync List, and verify that SSSE creates a corresponding PIM record.
   3. Perform the operation that your new trigger is designed to detect, such as deleting or updating the business contact record, or removing it from your Sync List.
   4. Verify that the expected result occurs—one or more delete trigger records are added to the S_SD_SYNC_INFO table, and SSSE deletes or updates the corresponding PIM record, as specified in your trigger.