![Close [x]](http://dw1.s81c.com/i/c.gif){kind=small}
Before you start
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
This tutorial demonstrates how to integrate BIRT into the DWE Design Studio and uses the DWE sample data to create a reporting application. The tutorial will guide you in using BIRT, but it will also utilize some of the best practices.
This tutorial explains the following tasks:
-
Setting up the DWE sample data:
- Creating the OlapAndMining data
- Creating the PRODUCT_GROUP table
- Creating additional views on the tables
-
Downloading and installing BIRT into the DWE Design
Studio:
- Downloading BIRT
- Adding the BIRT plug-in to DWE Design Studio
-
Deploying the BIRT runtime to a WebSphere server:
- Downloading and repackaging the BIRT runtime
- Adding JDBC Driver files
- Deploying the BIRT Runtime 2.1.1 to a WebSphere server
- Verifying the application installation
- Validating the BIRT application deployment
-
Modifying and deploying reports:
- Creating a BIRT project
- Modifying the data source
- Running a deployed report
This tutorial also provides an overview of subsequent tutorial modules:
- Part 2: Basic reports and charts
- Part 3: Summary and grouped reports
- Part 4: Drill-through and other advanced topics
In this tutorial, learn how to:
- 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
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 Resources.
- 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.
Table of contents
Local resources
Tags
Use the slider bar to see more or fewer tags.
Popular tags shows the top tags for this particular content zone (for example, Java technology, Linux, WebSphere).
My tags shows your tags for this particular content zone (for example, Java technology, Linux, WebSphere).
Popular tutorial tags |
My tutorial tagsSkip to tags list
Popular tutorial tags |
My tutorial tags
