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


    IBM DB2/390


    IBM DB2 - Using Code Page


    Microsoft SQL Server


    Oracle 8i


    Oracle 9i or Oracle 10g


  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.
Siebel Server Sync Guide Copyright © 2007, Oracle. All rights reserved.