Patterns information aggregation and data integration with DB2 information integrator

This IBM Redbooks publication documents and prototypes the role of DB2 Information Integrator technologies and architecture in IBM's Patterns for e-business using a typical customer insight e-business scenario. It is aimed at an audience of IT architects and data integration professionals respo...

Descripción completa

Detalles Bibliográficos
Autor Corporativo: International Business Machines Corporation. International Technical Support Organization (-)
Otros Autores: Alur, Nagraj (-)
Formato: Libro electrónico
Idioma:Inglés
Publicado: San Jose, CA : IBM, International Technical Support Organization 2004.
Edición:1st ed
Colección:IBM redbooks.
Materias:
Ver en Biblioteca Universitat Ramon Llull:https://discovery.url.edu/permalink/34CSUC_URL/1im36ta/alma991009626883606719
Tabla de Contenidos:
  • Front cover
  • Contents
  • Figures
  • Tables
  • Examples
  • Notices
  • Trademarks
  • Preface
  • The team that wrote this redbook
  • Become a published author
  • Comments welcome
  • Chapter 1. Introduction to Patterns for e-business
  • 1.1 Role of the IT architect
  • 1.2 The Patterns for e-business layered asset model
  • 1.3 How to use the Patterns for e-business
  • 1.3.1 Select a Business, Integration, or Composite pattern, or a Custom design
  • 1.3.2 Selecting Application patterns
  • 1.3.3 Review Runtime patterns
  • 1.3.4 Review Product mappings
  • 1.3.5 Review guidelines and related links
  • 1.4 Summary
  • Chapter 2. DB2 Information Integration architecture overview
  • 2.1 Introduction
  • 2.2 Current business trends
  • 2.2.1 Grid computing
  • 2.2.2 Data federation
  • 2.2.3 Information integration
  • 2.3 IBM's DB2 Information Integration overview
  • 2.3.1 Data consolidation or placement
  • 2.3.2 Distributed access (federation)
  • 2.3.3 DB2 Information Integrator portfolio
  • 2.4 DB2 Information Integrator V8.1
  • 2.4.1 DB2 II V8.1 overview
  • 2.4.2 DB2 II components
  • 2.4.3 Configuring the federated system
  • 2.4.4 Performance considerations
  • Chapter 3. Data Integration and Information Aggregation patterns
  • 3.1 Introduction
  • 3.2 Business and Integration patterns overview
  • 3.2.1 Data Integration application patterns
  • 3.2.2 Information Aggregation application patterns
  • 3.2.3 Business and IT drivers
  • 3.3 Data Integration:: Federation
  • 3.3.1 Business and IT drivers
  • 3.3.2 Federation pattern
  • 3.3.3 Federation: Cache variation pattern
  • 3.3.4 Guidelines for usage and scenario
  • 3.4 Data Integration:: Population
  • 3.4.1 Business and IT drivers
  • 3.4.2 Population pattern
  • 3.4.3 Population: Multi Step variation pattern
  • 3.4.4 Population: Multi Step Gather variation pattern.
  • 3.4.5 Population: Multi Step Process variation pattern
  • 3.4.6 Population: Multi Step Federated Gather variation pattern
  • 3.4.7 Guidelines for usage and scenario
  • 3.5 Data Integration:: Two-way Synchronization
  • 3.5.1 Business and IT drives
  • 3.5.2 Two-way Synchronization pattern
  • 3.5.3 Two-way Synchronization: Multi Step variation pattern
  • 3.5.4 Guidelines for usage and scenario
  • 3.6 Information Aggregation:: User Information Access
  • 3.6.1 Business and IT drivers
  • 3.6.2 User Information Access pattern
  • 3.6.3 User Information Access: Federation variation pattern
  • 3.6.4 User Information Access: Write-back variation pattern
  • 3.6.5 Guidelines for usage and scenario
  • 3.7 Self Service:: Agent pattern overview
  • 3.7.1 Business and IT drivers
  • 3.7.2 Agent: Federation variation pattern
  • 3.7.3 Guidelines for usage and scenario
  • Chapter 4. The Druid Financial Corporation (DFC) Customer Insight solution
  • 4.1 Solution definition process
  • 4.2 Develop a high-level business description
  • 4.3 Develop a Solution Overview Diagram
  • 4.4 Select the Business patterns
  • 4.5 Select the Integration patterns
  • 4.5.1 Application Integration patterns
  • 4.5.2 Access Integration pattern
  • 4.5.3 IT drivers
  • 4.6 Select the Composite patterns
  • 4.7 Select the Application patterns
  • 4.7.1 Select Application pattern for Self Service
  • 4.7.2 Select Application patterns for Information Aggregation
  • 4.7.3 Select Application pattern for Access Integration
  • 4.7.4 Select Application patterns for Application Integration
  • 4.7.5 Summarize Application patterns in DFC solution
  • 4.8 Select the Runtime patterns
  • 4.8.1 Agent: Federation variation application pattern
  • 4.8.2 User Information Access (UIA) application pattern
  • 4.8.3 Federation application pattern
  • 4.8.4 Population application pattern.
  • 4.8.5 Population: Multi Step variation application pattern
  • 4.8.6 Population: Multi Step Gather variation application pattern
  • 4.8.7 Integrated Runtime environment
  • 4.9 Select the Product Mappings
  • 4.10 Review guidelines
  • 4.11 Typical CSR scenario
  • Appendix A. IBM Client Information Integration Solution (CIIS)
  • CIIS overview
  • Business issue addressed by CIIS
  • Target audience for CIIS
  • Main features of CIIS
  • Kinds of information managed by CIIS
  • CIIS technical components
  • CIIS Data Server
  • CIIS Customization Workbench
  • CIIS XML Adapter
  • CIIS benefits
  • Business benefits
  • Technical benefits
  • Deployment and contact details
  • Appendix B. Configuring data sources in DB2 Information Integrator
  • Introduction
  • Oracle 8i data source
  • Install and test the Oracle Client connection
  • Create the Oracle wrapper
  • Create the Oracle server definition
  • Create the Oracle user mappings
  • Create the Oracle nickname
  • Test the Oracle nickname
  • XML data source
  • Create the XML wrapper
  • Create the XML server definition
  • Create the XML nickname
  • Test the XML nickname
  • ODBC data source (VSAM using IICF)
  • Set up the VSAM ODBC data source name on Windows
  • Create the ODBC wrapper
  • Create the ODBC server definition
  • Create the ODBC user mappings
  • Create the ODBC nickname
  • Test the ODBC nickname
  • DB2 UDB for z/OS data source
  • Catalog DB2 UDB for z/OS
  • Create the DB2 UDB for z/OS wrapper
  • Create the DB2 UDB for z/OS server definition
  • Create the DB2 UDB for z/OS user mappings
  • Create the DB2 UDB for z/OS nickname
  • Test the DB2 UDB for z/OS nickname
  • DB2 UDB for Multiplatforms data source
  • Catalog DB2 UDB for Multiplatforms
  • Create the DB2 UDB for Multiplatforms wrapper
  • Create the DB2 UDB for Multiplatforms server definition
  • Create the DB2 UDB for Multiplatforms user mappings.
  • Create the DB2 UDB for Multiplatforms nickname
  • Test the DB2 UDB for Multiplatforms nickname
  • Appendix C. Data models, table/file definitions, et al used in the DFC Customer Insight business solution
  • Introduction
  • Operational systems' details
  • Checkings/Savings
  • Credit Card
  • Rewards
  • Brokerage
  • Loans
  • Data warehouse details
  • Initial load of the data warehouse
  • Incremental update of the data warehouse
  • Data mart details
  • CIIS details
  • Initial load of the CIIS
  • Incremental update of CIIS objects
  • Related publications
  • IBM Redbooks
  • Other publications
  • Online resources
  • How to get IBM Redbooks
  • Help from IBM
  • Index
  • Back cover.