This exchange of information is accomplished through intermediary tables called EIM tables. In earlier releases, EIM tables were known as interface tables. The EIM tables act as a staging area between the Siebel application database and other data sources. EIM is your primary method of loading mass quantities of data into the Siebel database. You should use EIM to perform bulk imports, updates, merges, and deletes of data. In the Siebel application database, there are application tables known as base tables , which Siebel applications use.
|Published (Last):||20 August 2018|
|PDF File Size:||20.36 Mb|
|ePub File Size:||1.91 Mb|
|Price:||Free* [*Free Regsitration Required]|
Oracle says that we should not update database tables directly. For large data changes EIM is the preferred way. Each of these tables are mapped to a data table s called base tables. These base tables have the actual data which you can see in the GUI. Sometimes one EIM table can be mapped to many base tables or vice versa.
So lets do an easy EIM job. If the results are zero, we will move to the next step. If the results are not zero, select another number and try again. The next two sqls are. The commit sql is important if you are using Oracle. Oracle does not autocommit inserts by default and the EIM job will end in error if you do not commit.
After this we will need to create an IFB file. This is a text file and the contents will be like this. Ask your administrator which folder in which computer is accessible for siebel. Create with these parameters. Ask your team which server is preferred.
After this scroll down the screen and go to the bottom applet and fill in these values. Now go back up and wait. In the top right corner of the screen, you should see a magnifying glass icon. Click that , it will refresh the screen. The status field in the top applet should show status 'Success'. Now go to opportunities screen and search for the currency. It should show EUR. This is how we check results of an EIM job.
After this scroll down the screen and go to the bottom applet and fill in these values Now go back up and wait.
Siebel Enterprise Integration Manager (EIM) Refresher
Connect to Siebel-EIM. It sets all temporary columns to NULL and counts the rows to be processed. If there are rows where required columns contain only blanks, the complete EIM process will fail at this step. Rows will not be imported or updated. EIM applies any filter queries defined for this import process. If a row fails the filter query, EIM eliminates the row from further processing.
Siebel EIM Mapping - Step By Step Guide - Part 1
Connect to Siebel-EIM. EIM tables are designed to be simple and straightforward so they can be loaded or read by way of external programs. Before EIM can be used in a merge, update, or import process, EIM tables must be populated with data, using any method supported by the database. Each EIM table usually supports a group of base tables that can be imported or exported in a single batch. The maximum value is Use this column as the first key of any new indexes created on an EIM table.
There are many steps involved and I became confused very quickly. Through these experiences I formulated an efficient process to take in order to map data to Siebel base tables through Siebel EIM. Determine the base tables that the data will be mapped to and you must understand the data models that the data will be converted into. I am assuming that you have already worked out the mapping and data conversion rules so you know what fields from excel file will be mapped to what base tables etc. For each of the Siebel base tables to be populated, make a note of all the columns in the base tables that you will be mapping to with your source data. Also make a note of the columns that make up the user key for the table. If you are using Siebel EIM to update existing data in base tables then all that is required for EIM mapping is the mapping to user key and the columns being updated from source data.
Life Sciences. First, make sure you understand the source data and what Siebel Entities you will be importing. After that, you should document the EIM table mapping for the source columns to the target columns. I use Excel for this. I test the SQL insert statements with minimal data rows to verify the insert statement. This allows you to preview the data to be inserted as you write the SQL for each column.