IBM Licensed Programs: Database Accessories
542 iSeries Handbook
DB2 Warehouse Manager for AS/400 (5697-G23)
Data warehousing is the foundation for business intelligence and customer relationship
management. To provide the best benefit for your business, data warehousing needs to:
• Accurately translate business users' needs into workable data models
• Build a readily accessible data warehouse to continually draw on diverse application
and data sources
• Maintain a warehouse that is responsive to changing user needs in an ad hoc query
environment.
DB2 Warehouse Manager for AS/400 provides access to IBM and non-IBM data sources. It
empowers the data center to govern queries, analyze costs, manage resources, and track
usage. It provides a rich graphical environment to create and manage high performance,
scalable DB2 data warehouses from your workstation.
Once the warehouse is in place, DB2 Warehouse Manager provides flexible, easy-to-use
tools to access the data warehouse, and to govern and track its usage. Features for these
functions follow:
• Data Warehouse Center: Within the DB2 Control Center of DB2 Universal Database
is the Data Warehouse Center, which serves as the command console for warehouse
management. Use the Control Center to access multiple sources of data, extract and
build processes, analyze, test and monitor processes with a unique graphical
environment. Standard transformations within the product provide powerful functions,
saving valuable time, resource, and development testing.
The Data Warehouse Center provides access to DB2, Oracle, Sybase, Informix,
Microsoft, flat file, ODBC, and OLE database sources. As your data warehousing needs
diversify, DB2 Warehouse Manager makes it easy to provide access to disparate data
sources and populate dependent datamarts across distributed platforms from a
centralized control point.
DB2 Warehouse Manager for AS/400 5697-G23
Product number 5697-G23
Replaces product 5697-VW5 Visual Warehouse 5.2
Minimum OS/400 level V4R4
Installation prerequisites Warehouse server and administrative client components of DB2 UDB Enterprise
Edition V7.1
Related products None