Posted by: Ashish Kumar | July 2, 2009

Siebel EIM – An Overview


Enterprise Integration Manager 

Siebel Enterprise Integration Manager (EIM) is a server component that transfers data between the Siebel database and other corporate data sources. This data transfer is obtained through intermediary tables called EIM Tables. EIM tables act as a staging area between the Siebel application database and other data sources.

EIM should be used to perform bulk imports, updates, merges, and deletes of data.

Below figure depicts how the data can be transferred from some other Database to Siebel Database using EIM

 EIMThe ETL in the above figure specifies: Extract, transform, Load. There are various tools available for ETL for eg.Datastage.

The data exchanges between the Siebel database and external databases occur in two parts:

  1. Load data into EIM tables.
  2. Run Siebel EIM to import the data from the EIM tables into the Siebel base tables.

The step 1 involves only the use of EIM tables as to load the data into them while in step 2 the actual functionality of EIM comes into picture. 

Process Flow for the load of data between Non Siebel/Siebel Database to Siebel Database

 EIM PROCESS

 

The above flow chart depicts the complete process flow of how EIM works when the data is required in Siebel database is lying in some other DB and needs to be transferred to the Siebel DB. 

Major Functions of EIM

1. import

2. export

3. delete

4. merge

 Import Function

1. While initially implementing a Siebel application, load the Siebel database tables with data which can be either legacy data or Siebel data which is required to be moved as a part of Data Migration during a Siebel Upgrade Process. For example Import of Contacts and related Account information from an existing DB to the Siebel database

2. Adding the attributes to the existing data available in Siebel. For example when a few new LOV’s have been created in the application and they are to be used/applied for certain existing Accounts or Contacts.

3. If maintaining a non-Siebel database, we can update it with information from the Siebel database. For example adding the new contacts from Siebel DB to an Accounting DB.

 Export Function

Data contained within a Siebel application is available for transfer to non-Siebel/Siebel application (during upgrade process) by using EIM. When implementing a non-Siebel application, we can export data from the Siebel database tables for use by that application. For example, you can export employee information to a corporate sales commission application.

 Delete Function

 For the purpose of maintaining the Siebel database, we can identify rows to be deleted from a table and its associated child and intersection tables. For example we might delete an obsolete product line and its associated products.

 Merge Function 

In response to such external events as territory merger, account merge we can merge two or more database rows into a single row. For example you might merge the IFFCO. account information into the TOKIO. Account. A merge process deletes one or more existing rows from the base table and makes sure that intersecting table rows are adjusted to refer to the remaining rows. Data from the record we select as the surviving record is preserved. Data from the other records is lost. If there are other records associated with the records you merge, those records—with the exception of duplicates—are associated with the surviving record.

 Duplicate child records of the deleted rows will have CONFLICT_ID updated during the merge process. For example, when merging two Accounts (parent), the user keys of the Contacts (child) will be compared, and if the same Contact belongs to both Accounts, the Contact of the deleted Account will have its CONFLICT_ID updated.

Advertisements

Leave a Reply

Fill in your details below or click an icon to log in:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out / Change )

Twitter picture

You are commenting using your Twitter account. Log Out / Change )

Facebook photo

You are commenting using your Facebook account. Log Out / Change )

Google+ photo

You are commenting using your Google+ account. Log Out / Change )

Connecting to %s

Categories

%d bloggers like this: