590 Integrating IBM Tivoli Workload Scheduler with Tivoli Products
12.3 Tivoli Data Warehouse
This section provides a basic overview of Tivoli Data Warehouse, its
components, and functions.
Tivoli Data Warehouse provides the infrastructure for:
򐂰 Extract, transform, and load (ETL) processes through the IBM DB2 Data
򐂰 Schema generation of the central data warehouse
򐂰 Historical reporting
Tivoli Data Warehouse consists of a centralized data store where historical data
from many management applications can be stored, aggregated, and correlated,
as shown in Figure 12-2.
Figure 12-2 Tivoli Data Warehouse overview
The central data warehouse uses a generic schema that is the same for all
applications. As new components or new applications are added, more data is
added to the database. However, no new tables or columns are added in the
schema. TWS has the schema code of AWS.
Chapter 12. Integrating Tivoli Data Warehouse and Tivoli Service Level Advisor 591
data mart is a subset of a data warehouse that contains data that is tailored
and optimized for the specific reporting needs of a department or team.
The extract, transform, and load (ETL) process extracts data from a data source
and transforms the data into a standard format. It then loads the data into
another repository. Figure 12-3 is a high-level diagram of the ETL process.
Figure 12-3 ETL process flow
The ETL generally consists of SQL scripts that read data from data sources (for
example, previous Symphony files, Central Data Warehouse) and transform and
write the data to another database (such as Central Data Warehouse, Data
Mart). The
central data warehouse ETL reads the data from the operational data
stores of the application that collects it, verifies the data, makes the data conform
to the schema, and places the data into the central data warehouse. The
mart ETL
extracts a subset of data from the central data warehouse, transforms
it, and loads it into one or more star schemas, which can be included in data
marts to answer specific business questions.
The ETLs are typically scheduled to run periodically, usually during non-peak
hours. If an ETL encounters data that it cannot correctly transform, it creates an
entry in an exception table.
12.3.1 Accomplishing service delivery with Tivoli Data Warehouse
In the context of delivering services in a complex IT environment, accomplishing
a high level of customer satisfaction requires the IT function of an organization to
have a full understanding of and insight into the different aspects of its operation
and performance in terms of efficiency and effectiveness. An IT organization
must improve service delivery while spending less money. Service Level
Management offers IT organizations the ability to deliver the level of service that
keeps their businesses competitive.
Running a customer-focused, cost-conscious IT organization is not an easy task.
Today, an increasing number of businesses are putting pressure on their IT
departments to think of themselves as competitive corporate allies, originating
primarily from reasons discussed in the following sections.
Central Data
Data Mart
TWS Source Data
Central Data
Data Mart
TWS Source Data

Get Integrating IBM Tivoli Workload Scheduler with Tivoli Products now with O’Reilly online learning.

O’Reilly members experience live online training, plus books, videos, and digital content from 200+ publishers.