Chapter 17. Historical reporting with TEDW 533
17.2 Installation and configuration for data warehouse
In this section, we describe the necessary steps to configure the data-gathering
process in your environment. The basic steps are:
1. Have the environment with the IBM Tivoli Business Systems Manager
installed and working properly. Set up the Business System View objects as
discussed in Chapter 12, “Automatic Business System View creation” on
2. Have the Tivoli Enterprise Data Warehouse server or servers installed
properly with the necessary patches as specified in 17.2.1, “Warehouse
integration pre-installation steps” on page 533.
3. Install and configure the IBM Tivoli Business Systems Manager Warehouse
component as in 17.2.2, “Setting up the source ETL” on page 534.
4. Define the ODBC data source for the Microsoft SQL Server used by IBM
Tivoli Business Systems Manager, and run the ETL process. This step is
discussed in 17.3, “Activating collection” on page 538.
5. Evaluate the result.
Before going into the details of each step, we present the environment used in
our lab. This can be used as a starting point for setting up the data-gathering
process. We assume that no preexisting components will be used and describe
the steps of a brand new installation. We install most of the data warehouse
components in a single machine; however, for a production environment, you
may want to have the following separate machines:
Tivoli Enterprise Data Warehouse Server machine hosting the Central
Warehouse and the Warehouse data mart databases; this should have the
largest disk capacity and the fastest processor.
Tivoli Enterprise Data Warehouse Control Center machine hosting the
Warehouse metadata database and handling all ETL scheduling.
Tivoli Enterprise Data Warehouse Reporting Interface machine allowing end
users to obtain reports from data stored in the IBM Tivoli Monitoring data
17.2.1 Warehouse integration pre-installation steps
It is assumed that your Tivoli Enterprise Data Warehouse Environment Version
1.1 is already installed and up and running. Details for that can be found in
Introduction to Tivoli Enterprise Data Warehouse