We have moved to a Please visit there for updated posts

Monday, October 15, 2007

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.


dpfromcanberra said...

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.



Neel said...

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

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.

You Might want to read following articles also.