Configuring Siebel eBusiness Applications > Configuring Tables and Columns >

About Database Extension Options

When you need to store data that is not part of the standard Siebel data model, you have several options, including using static (preconfigured) extension tables and columns, adding columns to existing base tables, and creating new extension tables. Options for extending the data model are grouped into Standard and Advanced Database Extensibility.

Standard Database Extensibility

Standard database extensibility provides the following options:

• Using Static Extension Tables and Columns. These are predefined tables and columns that are available for you to use for your own purposes. They are the easiest option for storing additional entities because they are already part of the data model, so using them does not require you to modify the logical schema. Static extensions include: extension Columns, 1:1 Extension Tables, and 1:M Extension Tables. For more information, see Using Static 1:1 Extension Tables and Using Static 1:M Extension Tables.
• Adding extension columns to base tables. You can use the Database Designer, available in the Object List Editor, to add columns to base tables. For more information, see Adding Extension Columns to Base Tables.
• Creating New 1:1 Extension Tables. You can use the Database Designer, available in the Object List Editor, to create new 1:1 extension tables. For more information, see Creating 1:1 Extension Tables Using the Object List Editor.

Advanced Database Extensibility

Advanced database extensibility provides the following options:

• Creating New Tables Using the New Table Wizard. You can extend the data model by creating the following types of tables:
  • Stand-alone tables.
  • 1:1 Extension Tables.
  • 1:M Extension Tables.
  • Intersection tables.

    For more information, see Creating New Tables Using the New Table Wizard.

• Mapping Extensions to interface tables. The 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. For more information, see Configuring EIM Interfaces.
• Mapping Extensions to Dock 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. For more information, see Configuring Docking Rules.