WebSphere Portal Server and DB2 Information Integrator: A Synergistic Solution

Book description

Portals provide users with a single point of access to multiple types of information and applications through a Web interface. IBM WebSphere Portal for Multiplatforms is one of the industries’ most comprehensive portal offerings. It contains a wide range of portal technologies that help you develop and maintain B2C, B2B, and B2E portals. WebSphere Portal provides considerable flexibility in addressing dynamic changes in marketplace conditions through advanced integration, Web services, and collaboration technology.
DB2 Information Integrator provides federated data access to a diverse range of heterogeneous data sources including relational data sources such as the DB2 family, Oracle, SQL Server, and Teradata, and semi-structured data from WebSphere MQ messages, XML documents, Web services, Microsoft Excel, flat files, ODBC or OLE DB sources, plus a variety of formats unique to the life sciences industry. It also provides integrated support for Lotus Extended Search, which enables broad content access to a variety of content repositories including DB2 Content Manager, as well as e-mail databases, document repositories, third-party Internet search engines, and LDAP directories.
This IBM Redbooks publication provides examples of the synergy between WebSphere Portal Server and DB2 Information Integrator in delivering portal solutions, and will include sample portlets exploiting SQL, UDFs, JDBC, and Web Services.

Please note that the additional material referenced in the text is not available from IBM.

Table of contents

  1. Figures (1/2)
  2. Figures (2/2)
  3. Tables
  4. Examples
  5. Notices
    1. Trademarks
  6. Preface
    1. The team that wrote this redbook
    2. Become a published author
    3. Comments welcome
  7. Chapter 1: Introduction to portals
    1. What are portals
    2. Type of portals
    3. Evolution of portals
    4. Portal framework
      1. Portlets
      2. Portlet container
      3. Portal services
      4. Portal server
  8. Chapter 2: WebSphere Portal architecture overview
    1. WebSphere Portal overview
    2. WebSphere Portal architecture
    3. WebSphere Portal Family
      1. IBM WebSphere Portal Enable for Multiplatforms
      2. IBM WebSphere Portal Extend for Multiplatforms
  9. Chapter 3: DB2 Information Integration architecture overview
    1. Introduction
    2. Current business trends
      1. From on demand to grid computing
      2. From grid computing to data federation
      3. From data federation to information integration
    3. IBM’s DB2 Information Integration overview
      1. Data consolidation or placement
      2. Distributed access (federation)
      3. DB2 Information Integration products
    4. DB2 Information Integrator V8.1
      1. DB2 II V8.1 overview (1/2)
      2. DB2 II V8.1 overview (2/2)
      3. DB2 II components
      4. Configuring the federated system (1/2)
      5. Configuring the federated system (2/2)
      6. Performance considerations (1/3)
      7. Performance considerations (2/3)
      8. Performance considerations (3/3)
  10. Chapter 4: WebSphere Portal and DB2 Information Integrator
    1. WebSphere Portal and DB2 II synergy
    2. WebSphere Portal topologies and DB2 II
      1. WebSphere Portal in a Windows environment
      2. WebSphere Portal clones in a Windows environment
      3. WebSphere Portal in an AIX environment
      4. WebSphere Portal clones in an AIX environment
      5. Summary
    3. Tips for successful deployment
  11. Chapter 5: WebSphere Portal & DB2 Information Integrator scenarios
    1. Introduction
    2. Insurance agent profile
    3. The CFS portal
      1. Cotton-Wood Financial tab
      2. Collaboration Center tab
    4. CFS portal custom portlets
      1. Custom portlets development environment
      2. My Alerts Portlet
      3. Consolidated Calendar Portlet
      4. My Search Portlet (1/2)
      5. My Search Portlet (2/2)
      6. Claim Entry Portlet
      7. Demographics Portlet
      8. Claim Notify Portlet
      9. Competitive Rates Portlet
      10. Cotton-Wood Reports Portlet
      11. Cotton-Wood Search Portlet
      12. Cotton-Wood Details Portlet
    5. DB2 II versus no DB2 II: A sample portlet
      1. Portlet code using native APIs
      2. Portlet code using DB2 II
    6. Configuring the JDBC Business Object Builder
      1. Generate the Cotton-Wood Search Portlet (1/2)
      2. Generate the Cotton-Wood Search Portlet (2/2)
  12. Appendix A: DB2 Information Integrator installation
    1. Introduction
    2. General prerequisites
    3. Installing DB2 Information Integrator Version 8.1
      1. Installing on AIX
      2. Installing on Windows (1/6)
      3. Installing on Windows (2/6)
      4. Installing on Windows (3/6)
      5. Installing on Windows (4/6)
      6. Installing on Windows (5/6)
      7. Installing on Windows (6/6)
    4. Post-installation steps
      1. Verify relevant data source environment variables are set
      2. Verify dbm FEDERATED configuration parameter is set to YES
      3. Create the federated database
  13. Appendix B: Configuring data sources in DB2 Information Integrator
    1. Introduction
    2. Oracle 9i data source
      1. Install and test the Oracle Client connection
      2. Create the Oracle wrapper
      3. Create the Oracle server definition (1/2)
      4. Create the Oracle server definition (2/2)
      5. Create the Oracle user mappings
      6. Create the Oracle nickname
      7. Test the Oracle nickname
    3. XML data source
      1. Create the XML wrapper
      2. Create the XML server definition
      3. Create the XML nickname (1/2)
      4. Create the XML nickname (2/2)
      5. Test the XML nickname
    4. Table-structured files data source
      1. Create the table-structured file wrapper
      2. Create the table-structured file server definition
      3. Create the table-structured file nickname (1/2)
      4. Create the table-structured file nickname (2/2)
      5. Test the table-structured file nickname
    5. Microsoft Excel data source
      1. Microsoft Excel data source considerations
      2. Set up Excel ODBC data source name on Windows
      3. Create the ODBC wrapper
      4. Create the ODBC server definition
      5. Create the ODBC nickname
      6. Test the ODBC nickname
    6. WebSphere MQ data source
      1. Install WebSphere MQ AMI
      2. Enable the federated database for WebSphere MQ UDFs
      3. Setup access to your WebSphere MQ queues
    7. DB2 UDB for z/OS data source
      1. Catalog DB2 UDB for z/OS
      2. Create the DB2 UDB for z/OS wrapper
      3. Create the DB2 UDB for z/OS server definition
      4. Create the DB2 UDB for z/OS user mappings
      5. Create the DB2 UDB for z/OS nickname
      6. Test the DB2 UDB for z/OS nickname
    8. Lotus Extended Search data source
      1. Create the LES wrapper
      2. Create the LES server definition
      3. Create the LES user mappings
      4. Create the LES nickname
      5. Test the LES nickname
      6. Register the Extended Search custom function
  14. Related publications
    1. IBM Redbooks
    2. Other publications
    3. Online resources
    4. How to get IBM Redbooks
    5. Help from IBM
  15. Index (1/2)
  16. Index (2/2)
  17. Back cover

Product information

  • Title: WebSphere Portal Server and DB2 Information Integrator: A Synergistic Solution
  • Author(s): Nagraj Alur, Isaac Allotey-Pappoe, Chris Delgado, Jayanthi Krishnamurthy, Walter Alvey
  • Release date: March 2004
  • Publisher(s): IBM Redbooks
  • ISBN: None