1. Performance Tuning Guide
  2. Mapping Data into Siebel CRM

Mapping Data into Siebel CRM

This topic is part of Siebel EIM Usage Planning.

Siebel EIM uses EIM table mappings to map columns from EIM tables to Siebel base tables. Predefined Siebel EIM mappings are fixed and cannot be remapped.

Note: Siebel EIM uses only EIM table mappings to determine table relationships. Siebel EIM does not use configuration logic in the Siebel repository to determine table relationships.

Using Siebel Tools, you can view:

  • Mappings of EIM tables to Siebel base tables

  • Mappings of EIM table columns to Siebel base table columns

  • Mappings of Siebel base tables to EIM tables

  • Mappings of Siebel base table columns to EIM table columns

Some base tables might not be mapped to a corresponding EIM table. In such cases, use Siebel Visual Basic (VB) to load data into these base tables and inform Global Customer Support regarding the missing mapping. For information about using Siebel VB, see Siebel VB Language Reference.

If you have licensed Database Extensibility and created extensions, you can use the Column Mapping screen to specify mappings to the new fields. Database Extensibility and Siebel EIM support mappings between columns in extension tables and in EIM tables only if these columns share the same base table. To map EIM table extensions to base table extensions, you must specify which column the extended field will point to in the base table. For more information about Database Extensibility, see Configuring Siebel Business Applications.

Caution: Manually mapping new extension columns to columns in EIM tables presents risks of errors during Siebel EIM execution. Whether or not you have licensed Database Extensibility, it is strongly recommended for you to request an EIM Data Mapping and Design review or other assistance from Oracle Advanced Customer Services to help you perform the necessary tasks. This review can be used to make sure that the EIM mappings are correct and will accomplish intended goals. Contact your Oracle sales representative to request assistance from Oracle Advanced Customer Services.

To map data into a Siebel application

  1. Determine which Siebel base table columns need to be populated for the Siebel implementation, along with the external data that will be loaded into these base tables.

  2. Determine which EIM table and columns will be used to import from the source to the destination.

  3. Analyze this external data to determine which attributes need to be stored and the relationship this data has to other entities.