Siebel Enterprise Integration Manager Administration Guide
What's New in This Release
Back to top
Siebel Enterprise Integration Manager: an Overview
About Siebel Enterprise Integration Manager
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
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
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
|