Getting started on integrating your information / [Corinne Baragoin ... et al.].

Format:

Book

Contributor:

Baragoin, Corinne.

Series:

IBM redbooks.

Redbooks

Language:

English

Subjects (All):

Database management.

Information resources management.

IBM Database 2.

Physical Description:

xxiv, 368 p. : ill.

Edition:

1st ed.

Place of Publication:

[San Jose, Calif.] : IBM International Technical Support Organization, 2003.

Language Note:

English

Contents:

Front cover

Contents

Figures

Tables

Examples

Notices

Trademarks

Preface

The team that wrote this redbook

Become a published author

Comments welcome

Chapter 1. Introduction

1.1 The business climate

1.2 Business challenges and information integration

1.3 Overview of information integration

1.3.1 What is information integration?

1.4 WebSphere business and information integration

1.4.1 WebSphere business integration overview

1.4.2 Traditional business integration

1.4.3 How information integration fits with business integration

Chapter 2. Information integration infrastructure

2.1 Information integration design objectives and features

2.2 Information integration layers

2.2.1 Why DB2 UDB?

2.2.2 Why message queueing?

2.2.3 Why XML?

2.2.4 Why Web Services?

2.2.5 Why data warehousing?

2.3 Information integration at HLED Investments

2.4 Target environment

2.4.1 Technical infrastructure: Business Case I

2.4.2 Technical infrastructure: Business Case II

2.4.3 Technical infrastructure: Business Case III

2.4.4 Technical Infrastructure: Business Case IV

Chapter 3. Business case I: Federating data access using SQL

3.1 Business problem statement

3.2 Solution overview

3.3 Infrastructure and technology solution

3.4 Step-by-step implementation

3.4.1 Implement the DB2 federated server

3.4.2 Create federated database

3.4.3 Set up DB2 UDB data source

3.4.4 Set up Informix data source

3.4.5 Create the federated view

3.4.6 Install and configure WebSphere MQ

3.4.7 Install and configure MQSeries AMI

3.4.8 Add MQSeries Integration to the database

3.4.9 Test MQSeries Integration

3.4.10 Install and configure z/OS WebSphere MQ and CICS resources

3.4.11 Develop SQL statements to access the information.

3.4.12 Develop the GETPORTFOLIO stored procedure

3.4.13 Verify the test results

3.4.14 Alternatives

3.5 Further steps

3.5.1 DB2 Information Integrator

3.5.2 Federated access to Oracle

3.5.3 Set up Oracle data source

3.6 Integration considerations

3.6.1 Staffing requirements

3.6.2 Availability

3.6.3 Maintenance

3.6.4 Performance and capacity planning

3.6.5 Security

3.7 Conclusion

Chapter 4. Business case II: Accessing your information through Web Services

4.1 Business problem statement

4.2 Assumptions

4.3 Solution overview

4.4 Infrastructure and technology solution

4.5 Step-by-step: Building DB2 Web Services

4.5.1 Build Web Services using WORF

4.5.2 Build Web Services with WebSphere Studio Application Developer

4.6 Further steps

4.7 Integration considerations

4.7.1 Does Web Services mean interoperability?

4.7.2 Revenue and contracts

4.7.3 Web Services security

4.7.4 Quality of Service

4.7.5 Web Services management

4.8 Conclusion

Chapter 5. Business case III: Incorporating XML data

5.1 Business problem statement

5.2 Assumptions

5.3 Solution overview

5.4 Step-by-step implementation

5.4.1 Alternative one

5.4.2 Alternative two

5.4.3 Alternative three

5.5 Integration considerations

5.6 Conclusion

Chapter 6. Business Case IV: Populating a Common Data Store

6.1 Business problem statement

6.2 Assumptions

6.3 Solution

6.4 Infrastructure and technology solution

6.4.1 Architecture overview

6.4.2 Information integration

6.4.3 Data population subsystem

6.5 Step-by-step implementation

6.5.1 Step 1: CDS server initialization

6.5.2 Step 2: install MQSeries Integration

6.5.3 Step 3: Set up federated access to remote sources

6.5.4 Step 4: WebSphere MQ implementation

6.5.5 Step 5: MQSeries AMI Implementation.

6.5.6 Step 6: DB2 Data Warehouse Center implementation

6.5.7 Step 7: Define Common Data Store sources

6.5.8 Step 8: Defining Common Data Store targets

6.5.9 Step 9: Defining data transformation and movement

6.5.10 Step 10: Process deployment and scheduling

6.6 Further steps

6.7 Integration consideration

Appendix A. Test MQSeries integration

A.1 Step 1: Connect to database

A.2 Step 2: Test MQSEND function

A.3 Step 3: Verify MQSEND results

A.3.1 Verify that the message was sent

A.3.2 Verify the message contents

A.4 Step 4: Test the MQRECEIVE function

A.5 Step 5: Verify the MQRECEIVE function

Appendix B. WebSphere MQ implementation and object definitions

B.1 Create the queue manager QM_copper

B.1.1 Step 1: Start WebSphere MQExplorer

B.1.2 Step 2: Create queue manager

B.2 Define WebSphere MQ objects on QM_copper

B.2.1 Step 1: Opening and tailoring the queues folder

B.2.2 Step 2: Using MQExplorer panels to define the first local queue

B.2.3 Step 3: Define remaining local queues

B.2.4 Step 4: Using MQExplorer to define remote queues

B.2.5 Step 5: MQExplorer panels to define channels

B.3 Alternative to MQExplorer: WebSphere MQ commands

B.4 Define WebSphere MQ objects on MQV1

B.5 Test the communication channels

B.5.1 Step 1: Start COPPER.TO.MQV1

B.5.2 Step 2: Start MQV1.TO.COPPER

B.5.3 Step 3: Put a test message

B.5.4 Step 4: Verify the message

Appendix C. z/OS VSAM and CICS definitions and samples

C.1 VSAM File definitions

C.2 VSAM File sample data

C.3 COBOL copybooks

C.4 COBOL source code

C.4.1 Compiling and linking

C.5 CICS definitions

C.5.1 CUSTINFO Definition

C.5.2 READCINF Definition

C.5.3 GCIN Definition

C.5.4 IIREDBOK group installation

C.6 WebSphere MQ/CICS definitions

Appendix D. DADX syntax.

Appendix E. Web Services XML and DADX files

E.1 Additional XML files

E.2 The complete stockInfo.dadx file

Appendix F. Additional material

Locating the Web material

Using the Web material

System requirements for downloading the Web material

How to use the Web material

Abbreviations and acronyms

Related publications

IBM Redbooks

Other resources

Referenced Web sites

How to get IBM Redbooks

IBM Redbooks collections

Index

Back cover.

Notes:

"February 2003."

"SG24-6892-00."

Includes bibliographical references (p. 357-359) and index.

OCLC:

560315721