Written on October 15, 2007 at 9:59 am by neel

Siebel Enterprise Integration Manager (EIM) – An Overview.

Filed under I Wish I Knew View Comments

(27 votes, average: 3.93 out of 5)

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.

Visitors to this post, also read:

Article by neel

Authors bio is coming up shortly. neel tagged this post with: I Wish I Knew 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

Ioannis

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

Manish

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

mahesh goli

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?

mahesh goli

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?

JirkaV

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

Siebel Enterprise Integration Manager (EIM) – An Overview.

Related Posts

Visitors to this post, also read:

Article by neel

Search

Archives

Categories

Polls

Most Voted

Most Viewed

Siebel Interview

Oracle BI

Siebel Enterprise Integration Manager (EIM) – An Overview.

Related Posts

Visitors to this post, also read:

Article by neel

Search

Subscribe

Archives

Categories

Polls

Most Voted

Most Viewed

Siebel Interview

Oracle BI