Siebel EIM

EIM Tuning to improve performance

Through EIM process we load bulk amount of data from an external system to Siebel base tables. The performance of these EIM jobs has to be maintained at optimum levels in order to reduce the load on the Siebel application and database servers.

How can file attachments be imported via EIM?

1. Put the file to be attached in the Siebel_Server\input directory (i.e. ABC.doc)

 

2. In the EIM_SR_DTL table, populate:

SR_SR_NUM

SR_BU

ATT_FILE_NAME ('ABC')

ATT_FILE_EXT ('DOC')

Handling Siebel Base Tables with no user keys during EIM

Some base tables like Note tables do not have user keys. Since user keys play a vital role in migration of data using EIM, the EIM behavior is significantly different in case of Base Tables without user keys.

Table Fragmentation and Siebel EIM

Prior to running EIM it is important to clean up fragmented objects, especially those that will be used during the EIM processing. The following SQL statement can be used to identify objects with greater than 10 extents:

How to import data to a LOV Type column?

When importing data from _XMIF or some other Interface table users might encounter the following error message in the trace file:

Why are imported accounts not visible in Siebel 7 after the successful import using Enterprise Integration Manager

The account data need to be imported into S_PARTY, S_ORG_EXT, S_ACCNT_POSTN, and S_ORG_BU among other relevant tables. S_ORG_BU is a new table in Siebel 7 and must be populated for visibility in the "All Accounts" view.

 

Update user key Column for Product Entity, through EIM

Normally, User key updationare not possible through EIM except for few entities, of which Product is one. Here is a useful information to update one of the user key columns for Product (Product NAME for instance) through EIM.

EIM Column Extension in Siebel 8.x

When extending a custom column in Siebel 8.X which have case and accent insensitive (CIAI) enabled, running EIM mapping wizard creates corresponding mapping in EIM  table.

What is IFB file?

An IFB file is nothing but a EIM configuration file which is an ASCII or Unicode (Binary) text file of extension type .ifb. IFB stands for Interface Batch.

Pages

Subscribe to Siebel EIM