IBM Licensed Programs: Database Accessories542 iSeries HandbookDB2 Warehouse Manager for AS/400 (5697-G23)Data warehousing is the foundation for business intelligence and customer relationshipmanagement. 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 applicationand data sources• Maintain a warehouse that is responsive to changing user needs in an ad hoc queryenvironment.DB2 Warehouse Manager for AS/400 provides access to IBM and non-IBM data sources. Itempowers the data center to govern queries, analyze costs, manage resources, and trackusage. 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-usetools to access the data warehouse, and to govern and track its usage. Features for thesefunctions follow:• Data Warehouse Center: Within the DB2 Control Center of DB2 Universal Databaseis the Data Warehouse Center, which serves as the command console for warehousemanagement. Use the Control Center to access multiple sources of data, extract andbuild processes, analyze, test and monitor processes with a unique graphicalenvironment. 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 needsdiversify, DB2 Warehouse Manager makes it easy to provide access to disparate datasources and populate dependent datamarts across distributed platforms from acentralized control point.DB2 Warehouse Manager for AS/400 5697-G23Product number 5697-G23Replaces product 5697-VW5 Visual Warehouse 5.2Minimum OS/400 level V4R4Installation prerequisites Warehouse server and administrative client components of DB2 UDB EnterpriseEdition V7.1Related products None
