Siebel Tools Reference > Adding Custom Extensions to the Data Model >

Applying the Physical Schema Extensions to the Local Database

Once your changes are complete, you are ready to update your local environment.

NOTE:  Siebel eBusiness Applications version 7 do not support customized database triggers. If you have created customized triggers on your Siebel base tables, you must disable them before updating the logical database schema. You will then need to recreate the triggers after the update is finished.

To update your local environment

  1. In the Object Explorer, select the table from which you want to apply changes to the database.
  2. Click Apply in the Object List Editor.

    A dialog box appears, alerting you that you are about to connect to a local database and asking if you want to continue.

  3. Click OK.

    The Apply Schema dialog box appears.

  4. Fill in the fields as shown in the following table, and then click Apply.

    NOTE:  When applying changes to an Oracle database, the privileged user id and password must be the tableowner name.

    Field
    Description
    Tables
    Select one of the following options from the drop-down menu:
    • All. Update the database to reflect all changes made to the dictionary. This option forces each database object to be compared with the data dictionary, and updated if required.
    • Current Query. Update the database to reflect modifications made to the tables in the current query only.
    • Current Row. Update the database to reflect modifications made to the table in the current row only.
    Table space
    Leave blank.
    16K table space
    Leave blank.
    32K table space
    Leave blank.
    Index space
    Leave blank.
    Table groupings file
    Optional.
    This file is provided by the DBA and is specific to your database.
    Privileged user id
    Enter your database user ID, for example SADMIN.
    The table owner is read from tools.cfg.
    Privileged user password
    Enter your database user password, for example SADMIN.
    Note: When the database initialization for a mobile client is performed, the table owner changes from SIEBEL to the mobile user's password. In this case, use the mobile user's password in the password field.
    ODBC data source
    Verify that the ODBC connection specified in the ODBC Data Source text box is correct for your environment.
    You cannot apply schema changes to any database other than the one you are currently connected to (for example, by specifying the ODBC name of a different database).
  5. To activate extensions to EIM tables, select the appropriate tables, and then click Activate.

    Your extension tables and columns are now available to use in your configuration.

To make your new database extensions available to other developers

  1. Have the developers check out the relevant projects from the server. This gives them the schema change logically, that is, in Siebel Tools object definitions.
  2. Have them apply these changes to their local databases to obtain the changes physically.

 Siebel Tools Reference
 Published: 20 October 2003