Integrating IBM Tivoli Workload Scheduler with Tivoli Products

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

Warehouse

򐂰 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

A

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

data

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

Warehouse

Data Mart

ETL1

ETL2

TWS Source Data

Central Data

Warehouse

Data Mart

ETL1

ETL2

TWS Source Data