Siebel Tools Reference > Data Objects Layer >

EIM Interface Tables

Interface tables are intermediate database tables between the Siebel application database and other databases. A database administrator populates these tables with information to be processed by Siebel applications. You then invoke Siebel Enterprise Integration Manager (EIM) to process this information. EIM manages the exchange of data between Siebel database tables and other corporate databases. You can use EIM to perform bulk imports, exports, merges or deletes.

Interface tables have names that take the form EIM_.

All interface tables have a value of Interface in the Type property of their object definitions.

For more information about interface tables and EIM, see Siebel Enterprise Integration Manager Administration Guide.

When tables or columns are added to the database, including extension tables and extension columns, it is generally necessary to configure the corresponding EIM and docking or routing interfaces. Siebel Experts typically perform the configuration of EIM and docking interfaces. Or you can use the EIM/Docking Wizard to extend Siebel EIM/Docking model. However, you can create and configure Attribute Mapping object definitions and view the other object types for the purpose of studying your existing interfaces. After you create an extension column, you must add one or more Attribute Mapping object definitions in interface tables that will supply data to it.

Two terms will be useful in the discussion that follows: foreign key column and attribute column. A foreign key column contains a reference to the primary key of another table, providing the means to perform a join from one table to the other. In contrast, an attribute column holds data, and does not point anywhere else.

NOTE:  Do not modify the EIM attribute mappings shipped as part of the standard Siebel repository. Doing so may cause EIM to behave incorrectly.


 Siebel Tools Reference
 Published: 20 October 2003