Siebel Enterprise Integration Manager Administration Guide


Introduction

How This Guide Is Organized

Additional Documentation

What's New

Revision History


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

Viewing EIM Table Mappings to Base Tables

Viewing Interface Column Mappings to Base Tables

Viewing Base Table Mappings to EIM Tables

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

Oracle 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

Updating System Fields

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

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 and Troubleshooting Failures

Viewing a List of Imported Rows

Evaluating Import Processing Failures

Data Not Visible After Import

Unable to Edit Quotes After Import


Back to top


Exporting Data

Overview of EIM Export Processing

EIM Export Process

Preparing the EIM Tables for Export Processing

Check 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 All Columns

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 Task Info Log

Error Flags

SQL Trace Flags

Trace Flags

Optimizing EIM Performance

Table Optimization for EIM Processing

Batch Processing Optimization for EIM

Run-Time Optimization for EIM

Parameter Settings Optimization for EIM

Database Server Optimization for EIM


Back to top


EIM Performance Tuning

Architecture Planning Requirements

Database Sizing Guidelines

Database Layout (Logical and Physical)

EIM Usage Planning

Team Definition

Mapping Data into Siebel Applications

Testing EIM Processes

General Guidelines for Optimizing EIM

Recommended Sequence for Implementing EIM Processes

Troubleshooting EIM Performance

Resolving Process Errors

Optimizing SQL for EIM

Using the USE INDEX HINTS and USE ESSENTIAL INDEX HINTS Parameters

Using the SQLPROFILE Parameter

Additional Indexes on EIM Tables

Creating Proper Statistics on EIM Tables

Dropping Indexes in Initial Runs

Controlling the Size of Batches

Controlling the Number of Records in EIM Tables

Using the USING SYNONYMS Parameter

Using the NUM_IFTABLE_LOAD_CUTOFF Extended Parameter

Disabling the Docking: Transaction Logging Parameter

Disabling Triggers

Running EIM Tasks in Parallel

Database Optimization Tips for EIM

IBM DB2 UDB

MS SQL Server

Oracle Databases

IBM DB2/390

IBM DB2 Loading Process for EIM

General Recommendations for EIM Performance Tuning

Recommended Import Order

Data Management Recommendations

Run Parameters Recommendations

Monitoring the Siebel Server


Back to top


EIM Error Messages

EIM Error Codes

Internal Error Codes

Exit Status Error Codes

Configuration and File Load Error Codes

Load and Run Error Codes

Report Error Codes

Error Message Solutions

Process Failures

Mapping Errors


Back to top


Common EIM Usage Examples

EIM Import Process Examples

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 Keys in a Single Batch

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

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

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


 Siebel Enterprise Integration Manager Administration Guide 
 Published: 05 January 2004