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

Database Extension Implementation

After planning and designing your database extensions, complete the following steps to implement your extension tables and columns on the Siebel test database server. If you are performing this work after your Siebel applications are in production, you should establish a separate test environment and database. This approach assures the safety and integrity of your production system as you develop and test your database extensions.

NOTE:  During the process of implementing extension columns and tables, Siebel Tools generates and executes the SQL data definition language (DDL) that is used to modify the database and update other Siebel system components.

As with configuration work, database extensibility must first be performed against the local database. This allows you to recover the data in the event of mistakes, and allows you to test thoroughly the changes before making them available to all developers.

CAUTION:  Creating tables using SQL is not supported; use only Siebel Tools to create tables and perform other logical database schema extensions.

To implement database extensions

  1. Check out and lock the project to which the table being extended belongs.
  2. Update the logical schema definition in the local environment.
  3. Apply the physical schema extensions to the local database.
  4. Update and test configuration changes that apply to the extension.
  5. Prepare the server database prior to applying schema extensions.
  6. Apply the changes to the server database and click Activate.

    7. The Activate button makes the changes effective for server tasks like EIM and Generate New Database.

  7. Apply the server database changes to other local databases.

The following sections discuss each step in detail. Once you have implemented your extensions in your test environment, refer to the section entitled Migrating Repositories and Schemas Between Databases in Repositories for instructions on implementing these extensions in your production database.


 Siebel Tools Reference, Version 7.5, Rev. A 
 Published: 18 April 2003