Siebel Server Sync Guide > Configuring Siebel Server Sync >

Configuring the Database for SSSE

The next stage in configuring SSSE is to configure database triggers for SSSE, as described in the following paragraphs.

This task is a step in Process of Configuring SSSE.

Activating SSSE Database Triggers

SSSE relies on database triggers to guarantee correct operation. These triggers are not related to Siebel workflows, but are native to and supported by the database. The following procedure briefly describes how to install the triggers.

NOTE:  After each use of the Generate Triggers server component, you must reinstall the database triggers for SSSE, as described in this topic. (The GenTrig component removes all Siebel triggers on the database.)

CAUTION:  SSSE also includes triggers for position change, synchronization level change, and visibility change. Do not change triggers in these areas without consulting with Siebel Expert Services or Siebel Professional Services.

To install database triggers

1. On either your PIMSI Dispatcher machine or your PIMSI Engine machine, use the Windows Explorer to navigate to install_directory\siebsrvr\bin, where install_directory is the installation directory for your Siebel implementation.
2. Locate the SSSE_trigger_database_platform.sql script that is appropriate for your database, as shown in the following table.

   Database Platform	Script File Name
   IBM DB2 - Using Unicode	ssse_triggers_db2.sql
   IBM DB2/390	ssse_triggers_db2_390.sql
   IBM DB2 - Using Code Page	ssse_triggers_db2_cp.sql
   Microsoft SQL Server	ssse_triggers_mssql.sql
   Oracle 8i	ssse_triggers_ora8.sql
   Oracle 9i or Oracle 10g	ssse_triggers_ora9.sql

3. Use any text editor to modify the SQL script to replace the <change me> tags with the correct name space for your database.
4. To enable the SSSE triggers in your environment, use the appropriate database utility for your database platform to execute the script against your database.