Mapping a Table to an EIM Interface Table in Siebel Web Tools

In this example of mapping an EIM Interface Table to a Siebel Table, we use the S_CONTACT Table as the Siebel base Table and the EIM_CONTACT Table as the EIM Interface Table. The idea here is to map the columns from EIM_CONTACT to Columns in S_CONTACT so that EIM jobs can move data from EIM_CONTACT to S_CONTACT properly.

To Map a Table to an EIM Interface Table in Siebel Web Tools

1. 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

2. Lock the Project for the EIM Interface Table involved. Once you have decided which table you are going to use for the EIM Interface Table, you must lock the Project for that Table.

   Note: In later updates when Tables have been Workspace-enabled, Projects will be removed from the Repository as configuration work will be logically grouped by Workspaces. Once that happens, locking the Projects for Tables will not be possible or necessary.

3. In the Object Explorer click the Table object type.

4. Query for your EIM Interface Table.

   • Example: If you want to update the mappings between the EIM_CONTACT and S_CONTACT tables, you will query for the EIM_CONTACT Table.

5. Record the Project for the Table. In this case it is EIM Person.

6. In the Object Explorer click on the Projects object type.

7. Query for the Project associated to the EIM Interface Table. In this case, EIM Person.

8. Click the Locked checkbox on the row and step off the row to save the change.

9. Start the EIM Table Mapping Wizard by clicking on the magic wand icon.

10. Click the EIM Table Mapping icon to select it. You can tell it has been selected as it will now have a selection rectangle around it.

11. Click the Start button.

    Note: This is a wizard like other wizards in Web Tools and contains a Navigation Toolbar at the top to navigate to the next and previous screens.

12. The first screen of the wizard contains three fields.

    Field Name	Description
    Select the base Table	This is the Table to which you want to move EIM data. In the example above the base Table is S_CONTACT because we will be moving data from EIM_CONTACT to S_CONTACT.
    Enter Column name prefix	This is the prefix that will be used for the mappings so that you can identify the mapped columns. If a prefix has been used before for this mapping, it will be used again here and the field will both read only and populated with that previous prefix. If none has been used, you are free to enter up to ten (10) characters in the field.
    Select the interface Table	This is the Table from which the data should be drawn. In this case it is EIM_CONTACT

    Note: If you did not lock the Project for EIM Interface Table, when you select an EIM Interface Table, you will receive the error: The selected EIM table is not locked (SBL-DEV-62536)

13. The Next button for the wizard will only become enabled once both Tables have been chosen.

14. Once you have chosen both Tables and, optionally, add a column prefix, Click Next.

15. This will take you to the confirmation screen where you can verify your choices. If you have chosen the wrong table or entered a column prefix that needs adjusting, click the Previous button, make those changes and click Next. If you are satisfied click the Submit button to create the mappings in the Repository.

16. After the mappings are created the application navigates to the Summary screen and you can see all the mappings created in the Repository.

17. You can view the mappings under EIM Interface Table > EIM Table Mapping > Attribute Mappings by searching for the base Table you supplied to the Wizard. For more information, see Relations That the EIM Table Mapping Wizard Creates.