< Day Day Up > |
Figure 45.6. DB2 Data Warehouse Control Center.The DB2 Data Warehouse Manager makes it easier to use DB2 for data warehousing and business intelligence applications. Some of the predominant capabilities provided by DB2 Data Warehouse Manager include
Data extraction from DB2, ODBC, and OLE DB data sources can be controlled using the Data Warehouse Center. ODBC drivers for Informix, Oracle, Microsoft SQL Server, and Sybase are included with the Data Warehouse Center. Of course, when used in combination with IBM's DataJoiner data can be extracted from many additional data sources (such as NCR Teradata, IMS, and VSAM). In short, it can be significantly easier for technicians to deploy useful data warehouses on DB2 using the Data Warehouse Manager tool. Other IBM Data Warehousing SolutionsIBM offers many other data warehousing products that work with DB2 for z/OS and facilitate the creation, management, and use of DB2 as a platform for data warehouses, data marts, and data mining. One of IBM's main add-on products for DB2 data warehouse development is the DB2 Warehouse Manager, which extends the capabilities of Data Warehouse Center. Of course, products other than the basic Data Warehouse Center are not provided free-of-charge; they must be purchased at an additional cost from IBM. Other IBM data warehousing products include
IBM also partners with providers of query and reporting tools for business intelligence, as well as offering its own QMF for developing data warehouse queries. For a comprehensive overview of the data warehousing facilities offered by IBM, I recommend that you read Ralph Michael L. Gonzales' book, IBM Data Warehousing (2003, John Wiley & Sons, ISBN 0-471-13305-1). |
< Day Day Up > |