tag:blogger.com,1999:blog-65786693411696044702024-02-08T21:23:18.022+05:30S I E B E L - E I MSIEBEL ENTERPRISE INTEGRATION MANAGERDONNIE VINCENThttp://www.blogger.com/profile/15991792185673583945noreply@blogger.comBlogger1125tag:blogger.com,1999:blog-6578669341169604470.post-73930415501764637492008-02-20T14:59:00.009+05:302008-02-20T17:01:34.748+05:30Siebel Enterprise Integration Manager<strong style="color: rgb(51, 102, 255);">EIM</strong><span style="color: rgb(51, 102, 255);"> stands for </span><strong style="color: rgb(51, 102, 255);">Enterprise Integration Manager</strong><span style="color: rgb(51, 102, 255);">. 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.</span><strong style="color: rgb(51, 102, 255);">Why EIM:</strong><span style="color: rgb(51, 102, 255);"> </span><span style="color: rgb(51, 102, 255);"> Siebel has very</span><strong style="color: rgb(51, 102, 255);"> unique and complicated</strong><span style="color: rgb(51, 102, 255);"> Database structure which already has relationship defined between </span><em style="color: rgb(51, 102, 255);">n number</em><span style="color: rgb(51, 102, 255);"> 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 </span><em style="color: rgb(51, 102, 255);">data integrity issues.</em><span style="color: rgb(51, 102, 255);"> To answer all those concerns Siebel has provided</span><strong style="color: rgb(51, 102, 255);"> EIM</strong><span style="color: rgb(51, 102, 255);">.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<br />a) Insert</span><span style="color: rgb(51, 102, 255);"><br /></span><span style="color: rgb(51, 102, 255);"> b) Update</span><span style="color: rgb(51, 102, 255);"><br /></span><span style="color: rgb(51, 102, 255);"> c) Merge</span><span style="color: rgb(51, 102, 255);"> </span><span style="color: rgb(51, 102, 255);"><br />d) Delete</span>DONNIE VINCENThttp://www.blogger.com/profile/15991792185673583945noreply@blogger.com0