Packaged Data Warehouses
Date:
By: Philip Howard
Classification: Research Report
This report is one of four that Bloor Research has published on data warehousing, which consist of a domain report and three sub-domain reports as follows:
- Generic data warehouses – for environments where a single database is supposed to do everything.
- Analytic data warehouses – for environments (complex and unpredictable analytic queries) where a generic approach may not be suitable and it may be appropriate to employ two separate databases or, at least, a different generic database.
- Packaged data warehouses – packages for automating the creation of your data warehouse and data marts.
A ‘packaged’ data warehouse product is one that automatically extracts appropriate data from relevant source systems (SAP, PeopleSoft [Oracle], Oracle Financials, Siebel, J D Edwards [Oracle] and so forth) and uses that data to populate the data warehouse, usually based on a pre-defined (but extensible) database schema that has been developed for a particular industry sector (whether horizontal or vertical). In addition, the product may also automate the creation of key performance indicators and metrics to support the common criteria applied in that sector and, in some cases, the software may also automate the creation of relevant data marts as well as the data warehouse per se, together with ongoing loading processes to keep those marts up-to-date.
Vendors included in this report are: DecisionPoint, IBM, Kalido, SAP, SAS, SPSS (Showcase) and Teradata.