Siebel Enterprise Integration Manager Administration Guide > Siebel Enterprise Integration Manager: An Overview >

Process Flow Between EIM and Other Databases

For each EIM process, you need to complete the following sequence of steps.

  1. Prepare the EIM tables. For delete, merge, or import operations, the EIM tables require loading with representative data that allows EIM to identify the specific Siebel base table on which to operate. You can use either an SQL ancillary program utility or native SQL to perform this function. The structure of the EIM tables has the required mappings for the primary (or target) base table and other base tables that are serviced by the EIM table. The EIM export processes require minimal preparation of the EIM tables. When an export operation takes place, the EIM tables are populated with data from the Siebel base tables. Therefore, you can use either an SQL ancillary program or native SQL to transfer data from the Siebel application to a non-Siebel application. For more information, see Siebel EIM Tables.
  2. Edit the EIM configuration file. An ASCII or Unicode (binary) text file of extension type .IFB that resides in the Siebel Server/admin directory allows you to define the type of EIM processes to be performed: export, delete, merge, or import. For more information, see EIM Configuration File.
  3. Run EIM. EIM is submitted as a Siebel Server batch component task either from the Server Administration screens or from the Server Manager command line interface. For more information, see Running EIM.
  4. Check results. The EIM component task produces a log file, which provides tracing information about the process. The tracing information produced is variable dependent upon the EIM component task parameters used and the Siebel Server event logging deployed for the EIM component. As always, during testing operations it is advisable to prove the EIM processes with increased tracing information, which is reduced when the process is deployed to production.
Figure 1.  Process Flows Between Siebel Database and Other Databases
Click for full size image

Figure 1 illustrates the following processes:

 Siebel Enterprise Integration Manager Administration Guide 
 Published: 05 January 2004