Configuring Siebel Business Applications > Transferring Data Between Databases >
Mapping a Custom Table to an Interface Table
This topic describes how to map a custom table to an interface table. It includes the following topics:
To map custom columns and tables to a predefined EIM interface table, you use the EIM Table Mapping Wizard.
To map a custom table to an interface table
- Make sure the table you must map is the appropriate type, includes a user key attribute, and that Siebel CRM supports the mapping.
For more information, see Guidelines for Using the EIM Table Mapping Wizard.
- In Siebel Tools, display all child object types of the EIM interface table object type.
For more information, see Displaying Object Types You Use to Configure Siebel CRM.
- in the Object Explorer, click Table.
- In the Tables list, locate the table that must reference an EIM Table.
This table is the primary table into which EIM imports data from the predefined interface table.
- Right-click the record, and then choose EIM Table Mapping.
Siebel Tools displays the Interface Table Mapping dialog box. It enters data into the Base Table name window of this dialog box. It derives this data from the table you located in Step 4.
- In the Enter Column Name Prefix window, enter a prefix.
Siebel Tools does the following:
- If a prefix does not already exist for the EIM table, then Siebel Tools adds the new prefix you enter to the EIM interface table columns that are related to the table.
- If a prefix already exists for the EIM table, then Siebel Tools uses the existing prefix.
- In the Select the Interface Table window, choose a value from the list, and then click Next.
Siebel Tools constrains the list you use to choose the EIM interface table to display only those interface tables to which your new custom table includes a foreign key relationship. Siebel Tools sorts this list by EIM table name. If the Exist field of the interface table is Y, then the EIM table is already mapped to the base table. If you extend a predefined Siebel table, then a table with a Y in the Exist field is an ideal candidate for EIM mapping.
- Click Finish to accept the configuration and generate the EIM Interface Table object.
Siebel Tools begins the mapping, which might take several minutes. For more information, see Relations That the EIM Table Mapping Wizard Creates.
- To verify the mappings, do the following:
- In the Object Explorer, click EIM Interface Table.
- In the EIM Tables list, run a query for all changed records.
When you run the query, make sure the Changed property contains a check mark. Leave all other properties empty.
- To verify the mapping, examine child objects.
- Identify any new mappings that are not necessary.
- If any new mappings are not necessary, then do the following:
- Deactivate the unnecessary mappings.
- Rename or delete the ORACLE_HOME
\bin\diccache.dat file on the Siebel Server.
- Run the following query to review any more columns that Siebel Tools generated:
Relations That the EIM Table Mapping Wizard Creates
Figure 86 illustrates relations between objects that the EIM Table Mapping Wizard creates. The wizard maps objects and adds child objects to the predefined EIM interface table object. For more information about EIM objects that the wizard creates, see Objects You Use with Enterprise Integration Manager.
Figure 86. Relations That the EIM Table Mapping Wizard Generates