Bookshelf Home | Contents | Index | Search | PDF

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

About Standard Database Extensibility

---

Standard Database Extensibility refers to capabilities in Siebel Tools allowing you to extend the Siebel eBusiness Applications Data Model. It has two major components:

• Static Database Extensions. The Siebel eBusiness Applications Data Model contains several columns and tables that you can customize for your own purposes. These columns and tables are already part of the Data Model and require no schema modifications.

  If you need to track information that is not captured in the base entities, your first option is to determine if the static extensions can be used to solve the problem.

  The following are the types of static database extensions:

  • Static Database Column Extensions. The Siebel Data Model includes over 30,000 columns in Base Tables that are specifically included for you to use for your own purposes.
  • Static 1:1 Database Table Extensions. The Siebel Data Model includes over 40 tables that provide 1:1 relationships with Base tables that are specifically included for you to use for your own purposes.
  • Static Many:1 Database Table Extensions. The Siebel Data Model includes over 20 tables that provide 1:Many relationships with Base Tables that are specifically included for you to use for your own purposes.
• Database Extension Designer (Dynamic Database Extensions). For developers who require extensions beyond built-in database extensions, Siebel 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). Siebel Database offers the following extension capabilities:
  • Dynamic Database Column Extensions. You may add your own columns to any existing Base Table in the Siebel Data Model.
  • Dynamic Database Table Extensions. You may add your own tables bearing 1:1 relationships with Base Tables in the Siebel Data Model.

    It allows you to do the following:

  • Capture additional attributes on entities. You can add columns to database tables. You can use these columns to store additional information for use by business object definitions. You can then modify the user interface object definitions to display and update the contents of added columns.
  • Create your own extension tables. You can also extend the Siebel Data Model by creating new 1:1 extension tables for Siebel base tables.
  • Carry custom attributes forward with new releases. As part of the implementation process, the Database Extension Designer generates the necessary database-specific DDL commands, and registers the columns in the Siebel application dictionary. Siebel applications recognize the columns, and carries them forward into subsequent releases of the application.
  • Integrate with Siebel Remote. After implementing a database extension, you can request that Siebel applications automatically generate a new structure for mobile client local databases. Siebel applications provide a standard methodology for propagating changes to mobile clients.

The Database Extension Designer uses a point-and-click interface for adding columns to tables. It works in conjunction with the Object Explorer and Object List Editor to allow you to view all tables in the database and all columns in each table, and add extension columns to a table as necessary. This approach simplifies the process of implementing necessary changes, allowing you to meet the needs of your users more quickly.

NOTE:  You need to have a thorough understanding of the Siebel Object Architecture and Siebel Data Model before you undertake database extension.

Bookshelf Home | Contents | Index | Search | PDF