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 Administration - Server Management views 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 you should check the EIM processes using increased tracing information, and then reduce tracing when the process is deployed to production.
Figure 1.  Process Flows Between Siebel Database and Other Databases

Figure 1 illustrates the following processes:

  • How a non-Siebel database uses an SQL ancillary program utility to receive or send data to Siebel EIM tables.
  • How Siebel EIM is used to move data between Siebel EIM tables and Siebel base tables.
Siebel Enterprise Integration Manager Administration Guide