Based on the IBM e-BI architectural framework, this IBM Redbooks publication explains the building blocks required to connect front-end e-BI user tools to the OS/390 data warehouse or data mart. It also shows the Web integration in the architecture and the accessibility of the data warehouse from browser-based clients in an e-business environment. The book provides:

An overview of e-BI user connectivity and architectural framework on OS/390, as well as guidance on choosing the appropriate e-BI front-end user tool or e-BI user application, based on end-user profiles.

Connectivity methodologies, contrasting Web-based middleware with traditional client/server middleware in 2-tier or N-tier solutions connecting users to the OS/390 data warehouse or data mart.

The steps needed to implement front-end e-BI user tools accessing the OS/390 data warehouse and OLAP data mart. We highlight the stumbling blocks and show the implementation steps for:

QMF for Windows

Brio

DB2 OLAP Server Analyzer

Ch. 1 e-BI front-end tool connectivity overview

Ch. 2 Methodology for e-BI front-end tool implementation

Ch.3 Configuring database connections

Ch. 4 QMF for Windows

Ch. 5 Brio Enterprise

Ch. 6 IBM DB2 OLAP Server Analyzer

App. A. BI tools interoperating with OS/390 DW

App. B Setting up DB2 DDF

App. C QMF for Windows database connection configuration