Task Based UI @ Siebel 7.8 | Next Tip »Home

Siebel Enterprise Integration Manager (EIM) – An Overview.

OkAvarageGoodVery GoodExcellent (27 votes, average: 3.93 out of 5)
Loading ... Loading ...

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.

  • Share/Bookmark

Related Posts


Article by neel

Authors bio is coming up shortly. neel tagged this post with: Read 387 articles by neel
  • Hariom
    Can anyone of you tell me that how to run EIM job in nightly(recuriing) basis?


    Hariom
  • acgupta
    Extremely Premitive and Non-Technical.
  • Manoj
    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
  • Deepesh Shrivastava
    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
  • Hamy
    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?
  • Someone who works for Siebel
    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.
  • Ashok Kumar
    Hi,

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

    Thanks,
    Ashok
  • Dear Colleagues

    Perhaps you would also be interested to read this white paper regarding how to efficiently debug EIM tasks.

    http://www.ixanos.com/docs/Debugging Siebel EIM results.pdf


    cheers
    ioannis
  • Nice Info

    it would be better .if u give an example of doing this.
    step step step
  • Nic
    Hi

    Can somebody please explain the steps involved in doing EIM import?
  • Dev
    Quick & Good one ..
  • Kavitha Devarajan
    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.
  • Anand
    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
  • Hi shalini and neel..

    I am planning to apply H1 visa.. could you please let me know whether we have any openings in SIEBL EIM in US.. what is the position for siebel EIM?
  • 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.
  • pradeep_siebel
    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
  • Amit Singh
    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
  • Mohan
    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
  • Pavani Sripada
    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".
  • Mohan
    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.
  • Shells
    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
  • JIMIT
    hI,

    Is there any way to run EIM job from external system(java)? or can we run EIM using Business Service?
  • Shells
    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
  • Vivek Varma
    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
  • Manish Bang
    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.
  • Vivek Varma
    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
  • soj
    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 ??
  • harish
    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?
  • neel
    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.
  • Soj
    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!!
  • Doug T.
    I am curious, is EIM included in Siebel Public Base?
  • 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
  • Shalini
    Hi Harish,

    Can you share your queries, we will try to respond soon.

    Thanks
    Shalini Chauhan
  • harish
    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.
  • dpfromcanberra
    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
  • Neel
    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.
  • dpfromcanberra
    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
blog comments powered by Disqus

Polls

Do you like the new Comment System and new look to Site?

View Results

Loading ... Loading ...