Bookshelf Home | Contents | Index | Search | PDF |
Siebel Enterprise Integration Manager Administration Guide
Siebel Enterprise Integration Manager: An Overview
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
Preparing EIM Tables for Merge, Update, or Import Processes
Mandatory Columns for EIM Processing
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
Finding Differences in EIM Tables between Repositories
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
Recommended Import Order for Importing Legacy Data
Importing an Initial Batch of Legacy Data
Using ACT! for Legacy Data Imports
Updating Siebel Database for Batches with Both an Insert and Update to the Same Record
Preparing the EIM Tables for Import Processing
Required Initial Values for Special Columns
Required Initial Values for File Attachment Columns
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 Contacts to Make Them Visible in the Contact List
Importing Positions and Employees
Importing Data With Parent and Child Relationships
Importing Organizations That Contain the BU_ID Column
Importing Accounts Containing Multiple Team Members
Importing Exported Rows Into Target and Secondary Tables
Importing International Phone Numbers Using EIM
Importing URL Links Into the S_LIT Base Table
Checking Import Results and Troubleshooting Failures
Viewing a List of Imported Rows
Evaluating Import Processing Failures
Unable to Edit Quotes After Import
Overview of EIM Export Processing
Preparing the EIM Tables for Export Processing
Check Existing Rows Batch Numbers
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 Recursive Relationships
Viewing a List of Exported Rows
Extracting Data from the EIM Tables
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 Data Rows Identified by User Key Values
Deleting from Base Tables Other Than the Target Base Table
Deleting Rows from Extension Tables
Handling Aborts of EIM Delete Processing
Overview of EIM Merge Processing
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
Avoiding Aborts of EIM Merge Processing
Enabling Transaction Logging for Merge Processing
Specifying Survivor Records for Merge Processes
Preparing to Run an EIM Process
Running an EIM Process Using the Graphical User Interface (GUI)
Running an EIM Process Using the Command-Line Interface
Table Optimization for EIM Processing
Batch Processing Optimization for EIM
Parameter Settings Optimization for EIM
Database Server Optimization for EIM
Architecture Planning Requirements
Database Layout (Logical and Physical)
Mapping Data into Siebel Applications
General Guidelines for Optimizing EIM
Recommended Sequence for Implementing EIM Processes
Troubleshooting EIM Performance
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
Database Optimization Tips for EIM
IBM DB2 Loading Process for EIM
General Recommendations for EIM Performance Tuning
Data Management Recommendations
Run Parameters Recommendations
Configuration and File Load Error Codes
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
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 Running a Merge with Custom Columns
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 Deleting Specific Positions from Accounts
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
Bookshelf Home | Contents | Index | Search | PDF |
Siebel Enterprise Integration Manager Administration Guide Published: 05 January 2004 |