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. That was nice Shalini and not only that every interface table can have more than one base table assigned to it or should I say supports group of base table, an interface table is an extended table for the base table where any changes should be made, siebel(ORACLE) would be very reluctant to allow any changes to be made to its properitery tables(base tables) hence the interface tables.
    Every interface table has a primary table assigned to it apart from other base tables.
    Two of the important functional enhancements of EIM, explicit primary mappings
    and full multiple-organization visibility support, were introduced with this version and are
    available only by way of these interface tables. The EIM_ tables are the only interface tables that
    new customers should use. Customers who are upgrading from prior versions should transition to
    this new family of interface tables as soon as possible.

    EIM is fun and exposes you to lot of table mapping between the Interface and base tables. In my 5 yrs of Siebel exp, I still am learining EIM.

    Goodluck to you all.

    cheers

    dpfromcanberra

  2. That was nice Shalini and not only that every interface table can have more than one base table assigned to it or should I say supports group of base table, an interface table is an extended table for the base table where any changes should be made, siebel(ORACLE) would be very reluctant to allow any changes to be made to its properitery tables(base tables) hence the interface tables.Every interface table has a primary table assigned to it apart from other base tables.Two of the important functional enhancements of EIM, explicit primary mappingsand full multiple-organization visibility support, were introduced with this version and areavailable only by way of these interface tables. The EIM_ tables are the only interface tables thatnew customers should use. Customers who are upgrading from prior versions should transition tothis new family of interface tables as soon as possible.EIM is fun and exposes you to lot of table mapping between the Interface and base tables. In my 5 yrs of Siebel exp, I still am learining EIM.Goodluck to you all.cheers dpfromcanberra

  3. That is intresting piece of information even for me but as I have not worked on EIM so everything is new related to that.

    Do you mind if I put your comment as a post with your credentials ofcourse.

  4. That is intresting piece of information even for me but as I have not worked on EIM so everything is new related to that. Do you mind if I put your comment as a post with your credentials ofcourse.

  5. Hi Neel,yeh you can, no worries, its knowledge and it has to be shared so go ahead and publish it,I will try to contribute as much as possible.
    cheers
    dpfromcanberra

  6. Hi Neel,yeh you can, no worries, its knowledge and it has to be shared so go ahead and publish it,I will try to contribute as much as possible.cheers dpfromcanberra

  7. Hi Neel
    I am impressed by ur site, hardly can find only few site dedicated to siebel. CHEERS!!!!
    I need contact email of any expert you know of EIM as i am new to it and want to know about it.

    It will be easy for me contacting him/her rather than endlessly reading the documentation.

    Awaiting your reply.

    Harish.

  8. Hi Neel
    I am impressed by ur site, hardly can find only few site dedicated to siebel. CHEERS!!!!
    I need contact email of any expert you know of EIM as i am new to it and want to know about it.

    It will be easy for me contacting him/her rather than endlessly reading the documentation.

    Awaiting your reply.

    Harish.

  9. How long would you expect to take to load 8 million contacts with 1 to 3 addresses (average 1.2 per contact) one position, organization. Siebel 8.0, Oracle. Exact hardware is unknown so far 🙂
    How would you organize(split) IFB tasks to be most efficient. Should I consider creating of some temporary indexes? Thank you for your opinions. Jirka

  10. How long would you expect to take to load 8 million contacts with 1 to 3 addresses (average 1.2 per contact) one position, organization. Siebel 8.0, Oracle. Exact hardware is unknown so far 🙂
    How would you organize(split) IFB tasks to be most efficient. Should I consider creating of some temporary indexes? Thank you for your opinions. Jirka

  11. Can we load products onto S_PROD_INT via EIM,without following a process of locking the product ? & along with that are we even suppose to mention the S_VOD table.As S_VOD to holds the ref to S_PROD_INT.
    PL clarify!!

  12. Can we load products onto S_PROD_INT via EIM,without following a process of locking the product ? & along with that are we even suppose to mention the S_VOD table.As S_VOD to holds the ref to S_PROD_INT.
    PL clarify!!

  13. No, I don’t think that is possible. Records might be created but you will still have to lock them and release them in order to make them funtion.

  14. No, I don’t think that is possible. Records might be created but you will still have to lock them and release them in order to make them funtion.

  15. This is my understanding of the process and my experience: I used the business service (ISS Authoring Import Export Service) to release products once they are loaded into s_prod_int from eim table(eim_prod_int). Once the Business service is run records are created in s_vod ,s_vod_ver and s_iss_obj_def by the method Post_Eim_Upgrade. I dont understand the locking mechanism is it mandatory?

  16. This is my understanding of the process and my experience: I used the business service (ISS Authoring Import Export Service) to release products once they are loaded into s_prod_int from eim table(eim_prod_int). Once the Business service is run records are created in s_vod ,s_vod_ver and s_iss_obj_def by the method Post_Eim_Upgrade. I dont understand the locking mechanism is it mandatory?

  17. Harish if i understood u clearly…u meant that via EIM load u loaded the prods in S_Prod_int table …& later on via the BS mentioned by you,it helped to release the products…n with the release it got its instnace captured in S-vod,S_vod_ver & S_iss_obj_def too…correct me if not…

    if suppose consider the same case n without using the BS,if i take up the lastversion of the product i.e’999999999′..& do a direct load via EIM…would the prods still become available ??

  18. Harish if i understood u clearly…u meant that via EIM load u loaded the prods in S_Prod_int table …& later on via the BS mentioned by you,it helped to release the products…n with the release it got its instnace captured in S-vod,S_vod_ver & S_iss_obj_def too…correct me if not…

    if suppose consider the same case n without using the BS,if i take up the lastversion of the product i.e’999999999′..& do a direct load via EIM…would the prods still become available ??

  19. Hi Shalini/Neel

    I’m new to EIM. I have 1 Query with EIM Import Process. while i’m loading Contacts, the import is failing at s_contact_bu.

    I have also checked the T_ columns in EIM_Contact table, except T_contact_bu_sta, every thing is fine.

    Could you please suggest how we can proceed our investigation.

    Thanks
    Vivek Varma

  20. Hi Shalini/Neel

    I’m new to EIM. I have 1 Query with EIM Import Process. while i’m loading Contacts, the import is failing at s_contact_bu.

    I have also checked the T_ columns in EIM_Contact table, except T_contact_bu_sta, every thing is fine.

    Could you please suggest how we can proceed our investigation.

    Thanks
    Vivek Varma

  21. hi Vivek,
    can u please post the exact error u r geeting by looking into the log file.
    that will be helpful in resolving ur issue.

    Thanks.

  22. hi Vivek,
    can u please post the exact error u r geeting by looking into the log file.
    that will be helpful in resolving ur issue.

    Thanks.

  23. Hi Manish,

    The Issue is due to multiple records with different conflict id’s in s_contact_bu table.
    I have tried with one record after detleting the record with row_id=Conflict_id in s_contact_bu table. it worked fine.

    But siebel support recommended to delete such records using vb script.

    Thanks
    Vivek

  24. Hi Manish,

    The Issue is due to multiple records with different conflict id’s in s_contact_bu table.
    I have tried with one record after detleting the record with row_id=Conflict_id in s_contact_bu table. it worked fine.

    But siebel support recommended to delete such records using vb script.

    Thanks
    Vivek

  25. Hi Vivek,

    I would like to throw some light on your problem. If there are more than one row in the base table that have same user key but different conflictIDs, EIM cannot distinguish such rows. To overcome it First you have to remove all duplicate rows from Base table, only then the EIM process can succeed.

    Please let us know if you further face any problem. 🙂

    Thanks
    Shells

  26. Hi Vivek,

    I would like to throw some light on your problem. If there are more than one row in the base table that have same user key but different conflictIDs, EIM cannot distinguish such rows. To overcome it First you have to remove all duplicate rows from Base table, only then the EIM process can succeed.

    Please let us know if you further face any problem. 🙂

    Thanks
    Shells

  27. Hi Jimit,

    Case 1: Yes we can run any EIM job except Application interface. For that, you must have server access credentials and then using dos prompt/command prompt, you can give command which can run the EIM job. You can also pass the several parameters(ifb file name, log file directory, flag values, etc.) in that command which we used to provide while doing through Application.

    Case 2: I have never tried running any EIM job through Business Service. But I think we can create a record for that BC and invoke the ‘Start’/’Submit Job’ button method. Which can possibly do the task.

    Note: the IFB file must be properly placed on to server directory before any of the above operations.

    hey do let me know your findings too 🙂

    Thanks
    Shells

  28. Hi Jimit,

    Case 1: Yes we can run any EIM job except Application interface. For that, you must have server access credentials and then using dos prompt/command prompt, you can give command which can run the EIM job. You can also pass the several parameters(ifb file name, log file directory, flag values, etc.) in that command which we used to provide while doing through Application.

    Case 2: I have never tried running any EIM job through Business Service. But I think we can create a record for that BC and invoke the ‘Start’/’Submit Job’ button method. Which can possibly do the task.

    Note: the IFB file must be properly placed on to server directory before any of the above operations.

    hey do let me know your findings too 🙂

    Thanks
    Shells

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

    Thanks in Advance, For speding ur valuable time. My mail id is tmr.net[at]gmail.com.

    Bye,
    Mohan.

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

    Thanks in Advance, For speding ur valuable time. My mail id is tmr.net[at]gmail.com.

    Bye,
    Mohan.

  31. Dear Friends,

    I am pavani Sripada, working as a talent manager in TMI network, Hyderabad. I am currently looking for people in Siebel pracitce. I have requirement for EIM,EI, Siebel analytics with Oracle and Siebel Configuration. Please refer your friends, Colleagues who are looking for better opportunities. This is with world class MNC and the locations are for Mumbai & Hyd

    Thanking you in advance.

    Regards
    Pavani Sripada
    Talent Manager
    TMI Network,
    Hyderabad
    Phone: 66385903

    We specialize in key IT talent practice areas – Telecom , Infra services, BFS , Travel and Retail, Hitech, Manufacturing and Embedded technologies.
    We focus on Niche and strategic hire.visit us at www[dot]tminetwork[dot]com
    “Relationships beyond careers”.

  32. Dear Friends,

    I am pavani Sripada, working as a talent manager in TMI network, Hyderabad. I am currently looking for people in Siebel pracitce. I have requirement for EIM,EI, Siebel analytics with Oracle and Siebel Configuration. Please refer your friends, Colleagues who are looking for better opportunities. This is with world class MNC and the locations are for Mumbai & Hyd

    Thanking you in advance.

    Regards
    Pavani Sripada
    Talent Manager
    TMI Network,
    Hyderabad
    Phone: 66385903

    We specialize in key IT talent practice areas – Telecom , Infra services, BFS , Travel and Retail, Hitech, Manufacturing and Embedded technologies.
    We focus on Niche and strategic hire.visit us at www[dot]tminetwork[dot]com
    “Relationships beyond careers”.

  33. Hi Shalini Chauhan,Neel

    ur article(overview about EIM) is nice. i am working on EIM module in my project. so, i would like to know more detals regarding EIM process. could u just tell me “how to import static picklist data into base tables.

    my mail id is mohan.sieb@gmail.com.

    Thanks in advance for spending ur time.

    Bye,
    Mohan

  34. Hi Shalini Chauhan,Neel

    ur article(overview about EIM) is nice. i am working on EIM module in my project. so, i would like to know more detals regarding EIM process. could u just tell me “how to import static picklist data into base tables.

    my mail id is mohan.sieb@gmail.com.

    Thanks in advance for spending ur time.

    Bye,
    Mohan

  35. Hi, I m looking for Siebel EIM techno-functional candidate for a 6+contract of in Columbia, MD.

    Send resume if any one is interested at amit.satincorp[at]gmail.com

  36. Hi, I m looking for Siebel EIM techno-functional candidate for a 6+contract of in Columbia, MD.

    Send resume if any one is interested at amit.satincorp[at]gmail.com

  37. Hi Guys,

    i am mahesh Goli.. I have 4+yrs of experince in siebel EIM it self.. If you ahve any queries please sahre with me.. i have knowledge in informatica, sql and plsql also..

    people who want to learn EIM please read EIMADMIN.pdf.
    it is the most relevant docuement u can find all the information related to EIm, once u have completed the docuemnt.. go and veruy the ITR.pdf it will be available in siebel book shelf.

  38. Hi Guys,

    i am mahesh Goli.. I have 4+yrs of experince in siebel EIM it self.. If you ahve any queries please sahre with me.. i have knowledge in informatica, sql and plsql also..

    people who want to learn EIM please read EIMADMIN.pdf.
    it is the most relevant docuement u can find all the information related to EIm, once u have completed the docuemnt.. go and veruy the ITR.pdf it will be available in siebel book shelf.

  39. Hi,

    Its very nice and descriptive blog.
    I just wanted to add a few things to your blog.
    Update – Is a part of Import process.
    Export – Its one of the processes of EIM.

    EIM Processes:
    1. Import/Update
    2. Export
    3. Delete
    4. Merge

  40. Hi,

    Its very nice and descriptive blog.
    I just wanted to add a few things to your blog.
    Update – Is a part of Import process.
    Export – Its one of the processes of EIM.

    EIM Processes:
    1. Import/Update
    2. Export
    3. Delete
    4. Merge

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

Leave a Reply

Contribute