Configuring Siebel eBusiness Applications > Configuring EIM Interfaces >

EIM Table Mapping Wizard

You use the EIM Table Mapping Wizard to map custom columns and tables to EIM interface tables. Before adding and modifying attribute mappings consider the following:

• You can map a single column in an interface table to multiple base tables or extension tables. However, do not map multiple interface table columns to a single column in a target table because it can create ambiguity for EIM.
• The EIM Table Mapping Wizard is only available to tables of type Data (Public), Data (Intersection), Extension, and Extension (Siebel).
• You cannot use the EIM Table Mapping Wizard with non-standalone customer tables or foreign keys to custom tables. This is because you cannot add user key attributes and the EIM Table Mapping Wizard does not map foreign key columns if they point to a parent table column that does not have user key attributes.
• To invoke the EIM Table Mapping Wizard for Siebel base tables that do not have the foreign key as part of the user key, you need to create a temporary column with the following properties:

  Field	Value
  Inactive	Y
  User Key Sequence	<> NULL (for example, set it to 0)
  FK (Foreign Key)	Set (FK) Foreign Key table as itself

  By creating this temporary column, when you launch the EIM Mapping Wizard, it will list standard EIM interface tables that are already mapped to this table as the target or destination tables. The wizard will also list EIM tables that are mapped to tables to which this table has a foreign key. However, the foreign key must be part of the "Traditional U1 Index" user key of this table. After the EIM Mapping Wizard finishes, you should delete this temporary column.

• Review the restrictions listed in Table 17.

  Table 17.  Restrictions on Adding and Modifying Mappings

  From	To	Conditions
  Interface table column	Base column	Supported if there are existing mappings from this interface table into this data table.
  Interface table extension column	Base column	Supported if there are no other mappings to this base column. Use with caution.
  Interface table column	Extension table column	Supported if there are existing mappings from this interface table into the extension table's base table.
  Interface table extension column	Extension table column	Supported if there are existing mappings from this interface table into the extension table's base table.

• You can deactivate mappings if they are no longer necessary. To deactivate a mapping, navigate to the Attribute Mapping Object definition in the Object List Editor and place a check mark in the Inactive property. You should not delete any mappings.
• No validation is performed against interface table or column definitions. LOV validation is performed against the LOVs defined for the base columns to which they are mapped.

To map a new table to an EIM interface table using the EIM Table Mapping Wizard

1. Lock the project.
2. Select Table object type in the Object Explorer.
3. In the Object List Editor, select a table that you want to map to an EIM Table.

   This table will be the primary table into which data from the existing Interface table will be imported.

4. Right-click and choose EIM Mapping Table from the menu.

   The Interface Mapping dialog box is displayed with the Base Table name field populated with the selection you made in the Object List Editor.
5. In the Edit the Column name prefix field, enter a distinguishing prefix.

   If a prefix does not already exist for the selected EIM table, the new prefix will be added to specified EIM Interface Table Columns related to the target table. If a prefix already exists, the existing prefix will be used.

6. In the Select an interface table field, click the drop-down arrow and then choose a value from the list.

   The list for selecting the EIM Interface Table is constrained to show interface tables that are mapped to tables to which your new custom table has a foreign key relationship.

   The list of candidate interface tables is sorted by EIM table name. Interface tables with EXIST=Y means that these EIM tables already have the base table mapped. If you extend existing Siebel tables, consider these tables the ideal candidates for EIM mapping.

7. Click Next on the Interface Table Mapping dialog box.

   The Summary dialog box appears with a summary of the choices you have made.

8. Click Finish on the Summary dialog box to accept the choices you made and generate the EIM Interface Table object.

   Based on this information, the wizard creates new EIM table mapping objects and adds several child objects to an existing EIM interface table object, as shown in Figure 24.

Figure 24.  EIM Mapping 

For detailed specifications about EIM objects created, see EIM Object Specifications.