Bookshelf v7.5.2: About Extending the Siebel Data Model

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

About Extending the Siebel Data Model

Options for extending the Siebel data model include the following:

Standard (Static) Extensibility. The standard extensibility includes the Siebel Database Extension Designer that allows you to add columns to Siebel tables or create 1:1 extension tables. For developers who require extensions beyond built-in database extensions, the Database Extension Designer provides a point-and-click interface for extending Siebel application tables. Customers can use these database extensions to capture data from new fields in application screens or from external sources using Siebel Enterprise Integration Manager (EIM).

Advanced Database Extensibility. Advanced Database Extensibility includes the following wizards:

Table Wizard automates the generation of new table objects and standard system and foreign key columns. It allows you to create the following types of tables:

Stand-alone tables that are not related to any other type of table in the Siebel Data Model.

Tables that have a Many: One or One: One relationship with a table in the Siebel Data Model.

Tables intersecting between two existing tables in the Siebel Data Model.

EIM Table Mapping Wizard allows you to create or associate the new table to the appropriate interface tables for using EIM. You can generate EIM Table Mapping objects for importing data into tables you have created, and you can automate the creation of EIM Attribute maps on extension columns added to base tables, which speeds up the development of complex EIM table mapping objects.

The Dock Object Mapping Wizard allows you to associate the new table with an existing or new customer Dock object to support the synchronization of its data to remote users.

Benefits include:

Ability to import data into custom tables using EIM

Ability to synchronize the contents of custom tables to remote users

Automatically generate basic index and User Key objects for new 1:1, M:1, and intersection tables.

NOTE: Advanced Database Extensibility should be used only after having exhausted other mechanisms including the use of prebuilt extensions and the Database Extension Designer. Changes made using Advanced Database Extensibility are upgradable from release to release and will not conflict with modifications made by Siebel.

External Schema Import Wizard allows you to create a new Table object in the siebel repository based upon the contents of a DDL. See Advanced Database Extensibility for further information.