Patterns : Information Aggregation and Data Integration with DB2 Information Integrator.

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.

Description based on publisher supplied metadata and other sources.

Electronic reproduction. Ann Arbor, Michigan : ProQuest Ebook Central, 2024. Available via World Wide Web. Access may be limited to ProQuest Ebook Central affiliated libraries.