Siebel Enterprise Integration Manager Administration Guide

What's New in This Release

Back to top

Siebel Enterprise Integration Manager: An Overview

EIM Functions

Import New and Revised Data into Siebel Base Tables

Export Data from Siebel Base Tables

Delete Data from Siebel Base Tables

Merge Data in Siebel Base Tables

Process Flow Between EIM and Other Databases

Mobile Web Client Requirements

Back to top

Siebel EIM Tables

EIM Tables Overview

Preparing EIM Tables for Merge, Update, or Import Processes

EIM Table Naming Conventions

EIM Table Columns

Mandatory Columns for EIM Processing

File Attachment Columns

Organization Columns

EIM Table and Column Mappings

Database Extensibility and EIM

EIM Table Mappings Provided as Common Parents to Nontarget EIM Table Mappings

Creating New EIM Table Mappings to Existing Base Tables

About Explicit Primary Mappings

Setting Explicit Primary Mappings

Setting Explicit Primaries for Many-to-Many Relationships

About Viewing EIM Table Mappings

Verifying Your Object Explorer View Settings

Viewing EIM Table Mappings to Base Tables

Viewing Interface Column Mappings to Base Tables

Viewing Base Table Mappings to EIM Tables

Generating EIM Table Mapping Reports

About the Second Row Property on EIM Table Mapping Objects

EIM Table Mappings to Base Tables Without User Keys

Deleting EIM Table Rows

Finding Differences in EIM Tables Between Repositories

Back to top

EIM Configuration File

Using the EIM Configuration File to Define a Process

Defining EIM Configuration File Parameters

EIM Configuration File Parameters

Header Section Parameters Generic to All EIM Processes

Process Section Parameters Generic to All EIM Processes

Inheritance Rules for Configuration Parameters

Setting EIM Configuration Parameters

Setting Extended EIM Configuration Parameters

Sample SQL Scripts

DB2 Sample SQL Script

MS SQL Sample SQL Script

Back to top

Importing Data

EIM Import Process

Import Data Process Flow

Importing Legacy Data

Recommended Import Order for Importing Legacy Data

Importing an Initial Batch of Legacy Data

Using ACT! for Legacy Data Imports

Importing Large Databases

Updating the Siebel Database

Updating Siebel Database for Batches with Both an Insert and Update to the Same Record

Fields That Cannot Be Updated

Preparing the EIM Tables for Import Processing

Required Initial Values for Special Columns

Required Initial Values for File Attachment Columns

Adjusting the Case of Values

Editing the Configuration File for Import Processing

Header Section Parameters Used for Imports

Process Section Parameters Used for Imports

Parameters Used for Imports in Both the Header and Process Sections

Special Considerations for Imports

Suppressing Data When Updating Existing Databases

Importing Customizable Products

Importing Opportunities and Revenues

Maintaining Denormalized Columns

Importing Marketing Responses

Importing Contacts

Importing Private Contacts

Importing Contacts to Make Them Visible in the Contact List

Troubleshooting the Unique Constraint Error when Importing Accounts or Contacts

Importing Party Records

Importing Solutions

Importing Call Lists

Importing Positions and Employees

Importing Data with Parent and Child Relationships

Importing Industry Codes

Importing File Attachments

Updating File Attachments

Importing Organizations That Contain the BU_ID Column

Importing Accounts Containing Multiple Team Members

Importing Multiline Fields

Importing Exported Rows Into Target and Secondary Tables

Importing International Phone Numbers Using EIM

Importing URL Links Into the S_LIT Base Table

Importing LOV and MLOV Data

EIM and Audit Trail

Running an Import Process

Checking Import Results

Viewing a List of Imported Rows

Troubleshooting Import Processing Failures

Back to top

Exporting Data

Overview of EIM Export Processing

EIM Export Process

Preparing the EIM Tables for Export Processing

Checking Existing Rows Batch Numbers

Preserved Column Values

EIM Tables Not Supported for Export Processes

Editing the Configuration File for Export Processing

Header Section Parameters Used for Exports

Process Section Parameters Used for Exports

Parameters Used for Exports in Both the Header and Process Sections

Exporting All Data Rows

Exporting Selected Data Rows

Exporting Recursive Relationships

Exporting LOV and MLOV Data

Running an Export Process

Checking Export Results

Viewing a List of Exported Rows

Extracting Data from the EIM Tables

Back to top

Deleting Data

EIM Delete Process

Deletion Methods Supported

Delete Process Flow

Preparing the EIM Tables for Delete Processing

Editing the Configuration File for Delete Processing

Header Section Parameters Used for Deletes

Process Section Parameters Used for Deletes

Parameters Used for Deletes in Both the Header and Process Sections

Deleting All Data Rows

Deleting Data Rows Identified by User Key Values

Deleting from Base Tables Other Than the Target Base Table

Deleting Rows from Extension Tables

Deleting File Attachments

Handling Aborts of EIM Delete Processing

Running a Delete Process

Checking Delete Results

Back to top

Merging Data

Overview of EIM Merge Processing

EIM Merge Process

Preparing the EIM Tables for Merge Processing

Editing the Configuration File for Merge Processing

Header Section Parameters Used for Merges

Process Section Parameters Used for Merges

Parameters Used for Merges in Both the Header and Process Sections

Updating Affected Rows

Avoiding Aborts of EIM Merge Processing

Enabling Transaction Logging for Merge Processing

Specifying Survivor Records for Merge Processes

Running a Merge Process

Checking Merge Results

Back to top

Running EIM

Preparing to Run an EIM Process

Running an EIM Process

Running an EIM Process Using the Graphical User Interface (GUI)

Running an EIM Process Using the Command-Line Interface

Viewing the EIM Log File

Using Trace Flags, SQL Trace Flags, and Error Flags

Setting Event Logging from the Graphical User Interface (GUI)

Setting Event Logging from the Command-Line Interface

Trace Flag Settings

Optimizing EIM Performance

Table Optimization for EIM

Batch Processing Optimization for EIM

Run-Time Optimization for EIM

Parameter Settings Optimization for EIM

Database Server Optimization for EIM

Back to top

EIM: Examples of Common Usage

EIM Import Process Examples

Example of Importing from Multiple EIM Tables in a Single .IFB File

Example of Updating a Table in a One-to-One Relationship with Its Parent

Example of Updating Columns When There Are Two Records with the Same User Key in a Single Batch

Example of Updating Columns When There Are Two Non-Target Base Tables Mapped to One EIM Table

Example of Importing Primary Keys

Example of Setting a Primary

Visibility of Fields: Example of Importing Party Objects

Visibility of Fields: Example of Importing Accounts

Visibility of Fields: Example of Importing Contacts

Visibility of Fields: Example of Importing Employees

Visibility of Fields: Example of Importing Opportunities

Visibility of Fields: Example of Importing Assets

Example of Troubleshooting the Import of Extension Columns

Example of Troubleshooting the Unique Constraint Error when Importing Accounts or Contacts

Example of Importing and Exporting Hierarchical LOVs

EIM Merge Process Example

Example of Running a Merge with Custom Columns

EIM Delete Process Examples

Example: Using DELETE MATCHES to Delete Data from S_PARTY Extension Tables

Example: Using DELETE MATCHES to Delete Data from non-S_PARTY Extension Tables

Example of Using DELETE EXACT

Example of Deleting Specific Positions from Accounts

Examples of Resolving Foreign Keys

Example 1: Error Message "This is a foreign key value in the base table and the values in the interface table did not resolve to existing values."

Example 2: Resolving the Foreign Key for Position Division

Example 3: Resolving the Foreign Key Using a Special User Key

Other Examples

Example of Setting Explicit Primary Mappings

Example of Setting Explicit Primary Mappings for Many-to-Many Relationships

Example of Creating Mappings for Extension Columns

Example of Improving Performance by Dropping Indexes

Foreign Key Column Values: NO MATCH ROW ID versus NULL versus a Valid ROW_ID

Example of Using the NUM_IFTABLE_LOAD_CUTOFF Parameter

Example: Transaction Logging with Row-by-row Processing versus Set-based Processing

Example of Implementing a Multi-Organization Hierarchy

Example of Adding a Position to a Party Table

Example of Using the EIM_ASSET Interface Table

Back to top