Bookshelf Home | Contents | Index | PDF |
Configuring Siebel Business Applications > Mapping a Custom Table to an Interface Table for Siebel EIM > Overview of Using Siebel EIM for Bulk Import and Export of Data > Object Types That Enterprise Integration Manager UsesFigure 55 describes the objects and relationships that EIM uses. EIM Interface Table Object TypeAn EIM interface table is an object that provides an alternative representation of a table. It includes some of the same properties as a table plus other properties of an interface table. EIM Interface Table Column Object TypeAn EIM interface table column is an object that provides an alternative representation of a column. It contains all the properties of a column in addition to some properties that are specific to EIM. Figure 56 describes how the child columns of an interface table are the same as the child columns of a table. The EIM_PRI_LST price list interface table is an example. EIM Table Mapping Object TypeAn EIM table mapping is an object that references a data table that the parent EIM interface table object definition updates. One EIM interface table can update one or more data tables. Figure 57 describes how the Destination Table property of each EIM table mapping object identifies the name of the data table to update. Interface Table User Key Usage Object TypeAn interface table user key usage is an object that provides support for alternative user keys for base tables. It defines the use of a nontraditional user key for a base table that are specific to an interface table. CAUTION: Do not modify the object definition of an interface table user key usage. Any modification can adversely affect performance and operation. Attribute Mapping Object TypeAn attribute mapping is an object that identifies a column in a data table that EIM updates. This column resides in the destination table that is defined in the parent EIM table mapping. An attribute mapping includes the following properties:
If you add an extension column to a table, and if an interface table must provide data to the extension table, then you must add a corresponding attribute mapping. Figure 58 includes an example of how an EIM table mapping references a data table. Foreign Key Mapping Object TypeA foreign key mapping is an object that identifies a foreign key column in the destination table. EIM pulls data from an interface table and enters it into this foreign key column. EIM stores a foreign key as a numeric row ID value in a data table. To use data from an interface table in a foreign key, you must map the interface column to a combination of user key columns in the destination table rather than directly to the foreign key column. Figure 59 includes an example of how a foreign key map references a data table. To access the row, Siebel CRM uses a combination of attribute columns in the destination table of the foreign key. EIM gets the foreign key value from that row. A foreign key mapping is not a one-to-one column mapping from an interface table to a destination table. The numeric foreign key does not exist in the interface table, so you cannot map it. Foreign Key Mapping Column Object TypeA foreign key mapping column is an object that does the following:
User Key Object TypeA user key is an object that provides a set of attribute columns and related information that specifies how EIM can access the table rows. For more information, see How a User Key Creates a Unique Set of Values. User Key Column Object TypeA user key column is an object can be an attribute or a foreign key. In most situations user key columns constitute the columns in the user key index with the exception of the CONFLICT_ID column. A user key index typically includes a _U1 suffix. User Key Attribute Object TypeA user key attribute is an object that the parent user key specifies in the set of attribute columns that collectively identifies rows in the grandparent table. The column name is defined in the Name property of the user key attribute. User Key Attribute Join Object TypeA user key attribute join is an object that specifies a join operation that EIM can use to convert a user key attribute that is a foreign key to another table into attribute column values in that table. For example, the S_PROD_INT products table includes the S_PROD_INT_U1 user key. This user key references the following columns: EIM gets the PROD_NAME column from the S_PROD_INT table. No join is required. EIM must use a join to get the PROD_VENDOR and PROD_VEN_LOC columns from the S_ORG_EXT accounts table. EIM uses a join on VENDR_OU_ID, which is a foreign key from the S_PROD_INT table to the S_ORG_EXT table. |
Configuring Siebel Business Applications | Copyright © 2016, Oracle and/or its affiliates. All rights reserved. Legal Notices. | |