Designing EIM Interfaces
from a Performance
Perspective
DRAFT 1 –
Published by BT Retail T&T
IN CONFIDENCE
Siebel EIM Best Practice
IN CONFIDENCE
Siebel EIM Best Practice
IN CONFIDENCE
About this document...
Author
The author of this document may be contacted at:
Paul Duncan (MEH4)
Alexander Bain House
2
nd
Floor (pp 2DAQ)
15 York Street
GLASGOW
G2 8LA
Tel:
Mobile:
Email:
0141 220 8704
07939 215 541
Paul.3.Duncan@bt.com
Distribution List
• BT Siebel EIM Interface Development Teams:
High Level Designers
Low Level Designers
Development Teams
• BT Siebel Performance Testing and Management
Intended Audience
This document contains detailed technical information relating to Siebel Enterprise Integration
Manager (EIM) and Oracle. A level of understanding of these technologies is assumed.
Filing
The filing reference for this document is: TBD
Page 2 of 36
IN CONFIDENCE
Siebel EIM Best Practice
IN CONFIDENCE
History
Issue Date Author Reason
0.1 08-AUG-2004 Paul Duncan Initial Creation
Page 3 of 36
IN CONFIDENCE
Siebel EIM Best Practice
IN CONFIDENCE
Contents
1 OVERVIEW ....................................................................................................................................................................... 5
1.1 PURPOSE .......................................................................................................................................................................... 5
1.2 WHAT’S NOT INCLUDED ...................................................................................................................................................... 5
1.3 DOCUMENT CONVENTIONS .................................................................................................................................................. 6
2 EIM BEST PRACTICE .................................................................................................................................................... 7
2.1 INTRODUCTION .................................................................................................................................................................. 7
2.2 EIM CONFIGURATION ........................................................................................................................................................ 7
2.2.1 Overview ................................................................................................................................................................ 7
2.2.2 IFB Generic Parameters ....................................................................................................................................... 9
2.2.2.1 Only Base Tables .............................................................................................................................................. ............... 9
2.2.2.2 Ignore Base Tables ..................................................................................................................................................... ...... 9
2.2.2.3 Ignore Base Columns ............................................................................................................................................... ...... 10
2.2.2.4 Default Columns ..................................................................................................................................................... ....... 10
2.2.2.5 Fixed Columns ............................................................................................................................................................ ... 10
2.2.2.6 Use Index Hints, Use Essential Index Hints .......................................................................................................... ......... 11
2.2.2.7 Session SQL ............................................................................................................................................... ................... 12
2.2.2.8 Using Synonyms ..................................................................................................................................................... ....... 12
2.2.2.9 Rollback On Error, Commit Each Pass, Commit Each Table ............................................................................ ............. 13
2.2.2.10 Update After Failed Insert ...................................................................................................................................... ...... 14
2.2.3 IFB Import Process Specific Parameters ............................................................................................................ 15
2.2.3.1 Only Base Columns ........................................................................................................................................ ............... 15
2.2.3.2 Insert Rows, Update Rows ........................................................................................................................................ ..... 15
2.2.3.3 Net Change ....................................................................................................................................................... ............. 16
2.2.3.4 Oracle Insert Append Mode ............................................................................................................................. .............. 17
2.2.3.5 Trim Spaces ................................................................................................................................................... ................ 18
2.2.4 EIM Delete Process Configuration .................................................................................................................... 19
2.2.4.1 Delete All Rows ...................................................................................................................................................... ....... 19
2.2.4.2 Delete Exact ................................................................................................................................................................. .. 19
2.2.4.3 Delete Matches ............................................................................................................................................. ................. 20
2.2.5 EIM Merge Process Configuration ..................................................................................................................... 22
2.2.6 Other Parameters ................................................................................................................................................ 24
3 RUNNING EIM ............................................................................................................................................................... 26
3.1 DATA ............................................................................................................................................................................. 26
3.2 IFB FILE AND EIM PROCESSES ........................................................................................................................................ 27
3.3 SCHEDULING ................................................................................................................................................................... 28
3.3.1 Degree of Parallelism/Layout ............................................................................................................................. 28
3.3.2 Batchsize .............................................................................................................................................................. 28
3.3.3 EIM Streaming Configurations ........................................................................................................................... 28
3.3.4 Control-M Scheduling ......................................................................................................................................... 29
3.4 EIM TABLE MAINTENANCE ............................................................................................................................................. 31
4 VOLUME 4 LESSONS LEARNED ............................................................................................................................... 32
4.1 ENHANCEMENTS TO EIM PROCESSES ................................................................................................................................. 32
4.1.1 Redundant Updates ............................................................................................................................................. 32
4.1.2 Splitting Updates ................................................................................................................................................. 33
4.1.3 Hints and Optimiser Mode .................................................................................................................................. 35
4.2 DATABASE CONFIGURATION ............................................................................................................................................... 35
4.2.1 Indexes ................................................................................................................................................................. 35
4.3 ODM ADAPTER FUNCTIONALITY ...................................................................................................................................... 36
Page 4 of 36
IN CONFIDENCE
Siebel EIM Best Practice
IN CONFIDENCE
1 Overview
1.1 Purpose
This document is intended to be used as a guide for the design and deployment of EIM
interfaces to support the delivery of Siebel based projects at BT. It will be of particular relevance
to the delivery of OneSiebel (aka Account Managed Platform, AMP) and OneView (aka Volume
Siebel Release 6).
This document is split into two main sections as follows:
1. Siebel EIM Best Practice
• This section details techniques to be adopted to ensure that EIM interfaces and their
configurations adhere to Siebel and BT Best Practices.
2. OneView Release 4 data load Lessons Learned
• This section details the key lessons learned from the OneView (aka Volume Siebel, Big
Data, CCC) bulk data load of Billing Accounts, Assets and Consumer Updates into the
OneView Siebel instance.
This document has been assembled from experience from BT’s eVolve and Volume platforms.
These applications are fed data via ODM controlled data loads. Where processes other than
ODM will drive EIM interfaces (e.g. Converge to OneSiebel migration jobs) then some ODM
related content will still be relevant and so all sections should be read.
1.2 What’s not included
• This document is intended to share Best Practice and Lessons Learned and is neither a
High Level nor a Low Level Design. This document should be used to feed into the above
mentioned designs.
• Details of Oracle-Level tuning is not included although some techniques may be
mentioned in the context of other EIM specific parameters or configurations.
• This is not a ‘One Stop Shop’ from which to learn EIM. Instead, this document is
intended to communicate EIM Best Practice.
Page 5 of 36
IN CONFIDENCE