 | Level: Intermediate Vaibhav Srivastava (vaibhav.srivastava@in.ibm.com), Associate Software Engineer, IBM
19 Apr 2007 BIRT (Business Intelligence Reporting Tool) is an open source
relational reporting solution. It provides an Eclipse-based plug-in for report
development and testing, and it provides J2EE deployment and API that can be used in
custom Java applications. With IBM® DB2® Data Warehouse Edition (DWE), use
DWE Design Studio to seamlessly integrate the BIRT development environment and then
deploy those reports to an IBM WebSphere® server.
Objectives - Install the DWE sample data, if it is not already installed, and
make minor additions to it
- Download and install the BIRT environment into the DWE Design Studio
- Download and install the BIRT runtime environment into a WebSphere
server
- Modify a simple report that connects to a DB2 database and then run the report on a WebSphere server
Prerequisites
This tutorial assumes familiarity with some basic concepts of the Eclipse
IDE, including views, editors, panels, and so on. For an introduction to
Eclipse, see the Resources section of this tutorial.
System requirements
- You must have IBM Data Warehouse Enterprise Edition 9.1.1 installed with Design Studio
9.1.1, and you must have administrator access to WebSphere Application Server v6.0.
- You must have access to the DWE sample data and have administrator rights for
installing it and creating additional views and tables in the database. (This tutorial uses the Olapandmining database that is provided with Data Warehouse Enterprise Edition.)
- You must be able to access the BIRT open source product and install it into your
DWE Design Studio environment. (This tutorial uses BIRT V2.1.1.)
- To run the examples in this series, you need a Windows® system with at least 512MB of free memory space.
Formats html, pdf
Tutorial overview
This tutorial is part 1 of the
Business Intelligence Reporting Tool with
DB2 Data Warehouse Edition series. This part describes the process of integrating BIRT
in the DWE Design Studio and deploying the BIRT runtime in WebSphere Application Server. The later parts of this series will progressively explain more details about how you can use BIRT to make reports for DB2 relational data.
Because the DWE Design Studio is based on Eclipse, you can incorporate useful plug-ins into it. This
tutorial
series
is intended for anyone who:
- Wants to know how to create reports on relational data in Design Studio
- Feels that the other reporting tools are too complex for creating reports on relational data
- Wants to find out how the BIRT plug-in works
| | | |
