Data Warehouse Center Application Integration Guide

Integration scenarios

Table 1 lists some common types of warehousing applications and describes how you can integrate them with the Data Warehouse Center.

Table 1. Integration scenarios

Type of application Integration process
Data warehousing design To use data from data warehousing design applications in the Data Warehouse Center:

Import metadata into the Data Warehouse Center.
Use metadata synchronization to propagate metadata into the Information Catalog Manager.

Operational data descriptions
Import metadata into the Data Warehouse Center and business metadata into the Information Catalog Manager.
If the metadata is for source data that is included for lineage only and not to define source tables or files, import the metadata into the Information Catalog Manager directly.
Data cleansing To clean operational data:

Determine which application will manage the movement of the source data and target data: the Data Warehouse Center or the partner application.
Different applications can manage the source data and the target data.
Import source and target definitions, or export source and target definitions, or both. Do so to avoid typing the definitions again.
Define the partner application as a Data Warehouse Center program, or write a Data Warehouse Center program that starts the partner application.
Develop a user interface that sets the partner application parameters.
Import the metadata into the Data Warehouse Center so that the Data Warehouse Center can run the data cleansing application.
You can schedule programs by sequence as well as date and time.
Import business metadata into the Information Catalog Manager for use by users.

Alternate data storage (such as DB2 OLAP Server^(TM)) To load operational data into alternate data storage:

From the Data Warehouse Center, export the data definitions that are needed to build the partner storage.
Define the load programs as a Data Warehouse Center program, or write a Data Warehouse Center program that starts the load programs.
Develop a user interface that sets the partner application parameters.
Import definitions of the load programs into the Data Warehouse Center.
Use the load programs to synchronize the values in the operational data store and in the partner data store.
Import business metadata for the partner data store into the Information Catalog Manager.

Reporting (such as Brio or Cognos) To integrate reporting applications with the Data Warehouse Center:

Export business metadata from the Information Catalog Manager into the report application.
Import descriptions of the reports into the Information Catalog Manager.
Enable starting of the report application from an information catalog.

Type of application	Integration process
Data warehousing design	To use data from data warehousing design applications in the Data Warehouse Center: Import metadata into the Data Warehouse Center. Use metadata synchronization to propagate metadata into the Information Catalog Manager.
Operational data descriptions	Import metadata into the Data Warehouse Center and business metadata into the Information Catalog Manager. If the metadata is for source data that is included for lineage only and not to define source tables or files, import the metadata into the Information Catalog Manager directly.
Data cleansing	To clean operational data: Determine which application will manage the movement of the source data and target data: the Data Warehouse Center or the partner application. Different applications can manage the source data and the target data. Import source and target definitions, or export source and target definitions, or both. Do so to avoid typing the definitions again. Define the partner application as a Data Warehouse Center program, or write a Data Warehouse Center program that starts the partner application. Develop a user interface that sets the partner application parameters. Import the metadata into the Data Warehouse Center so that the Data Warehouse Center can run the data cleansing application. You can schedule programs by sequence as well as date and time. Import business metadata into the Information Catalog Manager for use by users.
Alternate data storage (such as DB2 OLAP Server^(TM))	To load operational data into alternate data storage: From the Data Warehouse Center, export the data definitions that are needed to build the partner storage. Define the load programs as a Data Warehouse Center program, or write a Data Warehouse Center program that starts the load programs. Develop a user interface that sets the partner application parameters. Import definitions of the load programs into the Data Warehouse Center. Use the load programs to synchronize the values in the operational data store and in the partner data store. Import business metadata for the partner data store into the Information Catalog Manager.
Reporting (such as Brio or Cognos)	To integrate reporting applications with the Data Warehouse Center: Export business metadata from the Information Catalog Manager into the report application. Import descriptions of the reports into the Information Catalog Manager. Enable starting of the report application from an information catalog.

[ Top of Page | Previous Page | Next Page ]