Siebel EIM

How are index hints used in an EIM process

Enterprise Integration Manager (EIM) interacts with data objects (tables and columns) via SQL statements. How those queries are executed by the database in use is directly related to the EIM performance.

Running the Siebel EIM Process

The EIM Process consists of executing the following sequence of steps:

Creating Siebel ROW_ID through EIM

The unique identifier associated with every record in Siebel Enterprise databases is known as a Row ID. The column in which this value is found is ROW_ID and it is present on every table. The ROW_ID is unique for an entity.

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.

How can users generate an Enterprise Integration Manager Log file in Siebel

In Siebel application, follow the steps below to generate an Enterprise Integration Manager (EIM) detailed log file:

1. From User Interface, navigate to View > Site Map > Server Administration > Components

Why is the Primary ID not populated during an EIM task even though the corresponding EIM mapping columns are appropriately populated in the Interface table

When encountering  the Primary ID not populated during an EIM task even though the corresponding EIM mapping columns are appropriately populated in the Interface table issue modify the IFB file to include the PRIMARY KEYS ONLY = TRUE paramete

How can users find differences in all interface tables between two repositories

1. Before using the utility, the user needs to create the view S_EIM_MAP_V in the database. The database platform independent script for creating the view is create_EIM_MAP_V.sql and can be found in <dbsrvr>\common directory.

EIM Tuning - Reference

What is EIM

EIM is a data loading tool that reads data from EIM tables (staging table) and Inserts/Updates/Deletes data in/from Siebel base tables.
 

Why EIM tuning is important

  • Data

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')

Pages

Subscribe to Siebel EIM