siebel

Hey Everybody, Hope you all are doing Great! It's been a long time since my last post, apologies for that! Anyway, I have decided to make up for that time and give you some great stuff! Recently, I had a LOT of people asking for a way to Automatically generate EIM Mappings. I have written a post previously called Generate EIM mapping using SQL Script . However I made some new changes that will give you more information than before. So here are the updated versions for Oracle and MS SQL Output Preview Document Links : Do what the document tells you are you're good! Automate Siebel EIM Mapping using SQL_MSSQL Automate Siebel EIM Mapping using SQL_Oracle Watch out for more interesting Stuff! Cheers! Ryan

Disclaimer: This post may not appeal EIM war horses but might be of some interest to newbies in EIM. There are two types of Data, the one you look up and the one you make up. EIM is the technique which is used for the later type. As per siebel Bookshelf "Siebel EIM manages the exchange of data between Siebel database tables and other corporate databases". The EIM process constitue of two major steps: 1 - The data is first copied from external source(external table, csv , excel) into the interface tables. 2 - This data from the interface tables is then loaded into predefined destination columns in the base tables using the configuration file. This configuration file, popularly known as ifb file, hosts the magical words which can be used to import, update, delete, extract, merge data. A more detailed list of paramters is available in bookshelf. One of the interesting parameters in the list is "SESSION SQL" which can perform operations after the EIM execution. This can...