Siebel Enterprise Integration Manager (EIM) – An Overview.

This article has been provided by Shalini Chauhan having Siebel experince of over 1.5 years and Leading an EIM team.

Not everybody today uses Siebel but when they decide to use Siebel they just cannot leave data in their legacy system as such. They would like to retain that in their new improved Siebel CRM system. But how do you import that terabytes of data probably existing in CSV or a DAT file. This is where EIM comes into picture.

EIM stands for Enterprise Integration Manager. It is a SIEBEL Component which is used for Data Migration from legacy as well as other Siebel systems.When I heard about EIM, it appeared to be a very dull, complicated and difficult subject. But when I really started working, I found it as much fascinating and challenging as I wished to work upon.Why EIM:
Siebel has very unique and complicated Database structure which already has relationship defined between n number of tables hence it is not recommended to insert, delete or update data stored in what is known as Base Tables in Siebel. During migration lot of things can happen which can lead to data integrity issues. To answer all those concerns Siebel has provided EIM.For most of base tables in Siebel an EIM table is also in existence which allows you to play with data and perform thing that you normally wouldn’t want to perform on base tables. So, you can import-export data to and from EIM tables and we can perform following operations on the data that resides in EIM tables

a) Insert
b) Update
c) Merge
d) Delete

Once the data is manipulation and scrubbing is complete we can import that data in base tables and Siebel EIM component takes care of things like Foreign Key, Composite Keys, User Keys and also issues related with data integrity.

The source of data can be dat files, CSV files or any other kind of legacy database. So as the process, we need to push data to these interface tables using third party tool like SQL Loader, DTS etc and then migrate data to Siebel base tables using EIM component.

Main Responsibilities of person responsible for EIM are:

  • Identifying and creating mapping between EIM and Base Tables.
  • Cleansing of data to be imported.
  • Loading of data in EIM tables.
  • Running EIM batch job.

To be successful in EIM, one must be aware of basic understanding of RDBMS, SQL, cursors, etc and should have interest in database and also should have an adaptive learning approach. It is really a challenging job but only when you are ready to exhibit your dedication and hard work.

79 Responses to Siebel Enterprise Integration Manager (EIM) – An Overview.

  1. I am beginner in Siebel EIM. Introductory for Siebel EIM is really good. Can you tell me the whole process (with eg. scenario) how to run a job with SQL Data Loader, and test the same.

  2. Hi,

    Please explain me about the MISC SQL parameter in context of using Explicit and Implicit Primary Mapping.

    Thanks,
    Ashok

  3. Hi,

    Please explain me about the MISC SQL parameter in context of using Explicit and Implicit Primary Mapping.

    Thanks,
    Ashok

  4. siebel(ORACLE) would be very reluctant to allow any changes to be made to its properitery tables(base tables) hence the interface tables.

    No it’s not a matter of proprietary anything, it’s knowing what’s there. NEVER, EVER, EVER play with a base table. Add as many extension columns as you deem necessary. The data structure and schema can change at any time. Siebel guarantees what Siebel changes will still work, but if you are dependent on a column type or value or existence thereof, you’re hosed if it changes and calling in expert services to clean up the mess is expensive.

  5. siebel(ORACLE) would be very reluctant to allow any changes to be made to its properitery tables(base tables) hence the interface tables.

    No it’s not a matter of proprietary anything, it’s knowing what’s there. NEVER, EVER, EVER play with a base table. Add as many extension columns as you deem necessary. The data structure and schema can change at any time. Siebel guarantees what Siebel changes will still work, but if you are dependent on a column type or value or existence thereof, you’re hosed if it changes and calling in expert services to clean up the mess is expensive.

  6. Hello,

    I’m trying to learn how does the mapping occur between the EIM and the base table. Could anyone help me with this issue?

  7. Hello,

    I’m trying to learn how does the mapping occur between the EIM and the base table. Could anyone help me with this issue?

  8. Hi All,

    I have an issue with SR attachments loading.
    I have some SR with attachments. I need to update those attachments. The update will take place in Base column as well as constomized columns. I’m using Oracle Siebel 8.0 version.

    Please suggest any best method to update SR attachments.

    Thanks in advance.
    Deepesh Shrivastava

  9. Hi All,

    I have an issue with SR attachments loading.
    I have some SR with attachments. I need to update those attachments. The update will take place in Base column as well as constomized columns. I’m using Oracle Siebel 8.0 version.

    Please suggest any best method to update SR attachments.

    Thanks in advance.
    Deepesh Shrivastava

  10. Hi..can anyone tell me how the System columns in EIM table having default values gets populated. e.g created_by having default value ‘%EMP%’. We have seen that the system columns in EIM table gets populated from some machine and not from others. Thanks..Manoj

  11. Hi..can anyone tell me how the System columns in EIM table having default values gets populated. e.g created_by having default value ‘%EMP%’. We have seen that the system columns in EIM table gets populated from some machine and not from others. Thanks..Manoj

  12. Hi, iam interested to work on EIM. I am New to EIM process. Can you tell me the detail steps with data mapping sheet and sample data,
    ” How to load the Legacy Account data
    into the Siebel Base table.”

    Pls send to pradeep.sadula@gmail.com

    Thanks

  13. Hello guys;
    im very new to SIEBEL and ive been given the task of mapping (RIM Level) the fields on Phoenix backend with the Siebel CRM. This is where the EIM comes into the picture. Can anyone pelase send me a descriptive (educative-approach) powerpoint on EIM? i already have access to the EIMAdmin guide but i am finding it advanced. Also any introductory Siebel Overview powerpoint is highly appreciated. Here is my email: rawad_assaf[@]hotmail[.]com

  14. Hello guys;
    im very new to SIEBEL and ive been given the task of mapping (RIM Level) the fields on Phoenix backend with the Siebel CRM. This is where the EIM comes into the picture. Can anyone pelase send me a descriptive (educative-approach) powerpoint on EIM? i already have access to the EIMAdmin guide but i am finding it advanced. Also any introductory Siebel Overview powerpoint is highly appreciated. Here is my email: rawad_assaf[@]hotmail[.]com

  15. Please don’t waste this site value by writing such kind of overview. Everyone knows about this. Write some challenge which you have faced so other can get benfited

  16. Hi Shalini,

    I am new to Siebel EIM.
    I was just curious as to why do we have multiple EIM tables for one base table?
    Typically EIM table have to be denormalised tables and I dont see any need for one base table mapped to multile interface table. however I understand in case of denormalisation we can have a situation that “multiple base tables map to single interface table”.
    Could you explain why does situation occur?

Leave a Reply

Contribute