Wednesday, February 20, 2008

Siebel Enterprise Integration Manager

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