That's correct. You need the database(s) to put the data and the means to get the data there as well as tools to facilitate getting the data out and using it.The best way to classify the vendor offerings is:
- ETL -- Data movement (Extraction, Transformation and Loading)
- Data Management -- The database management systems
- Data Access tools and applications -- what to do with the data
- Data Modeling Tools -- Tools to facilitate the development of the data model(s) in the data warehouse environment
- Data Repository -- The RDBMS where the "metadata" is stored (I note you used repository to refer to the data warehouse. This is common but repository actually has this other meaning).
> Customer Data Issues
> Data Management
> Intro to BI
> Enterprise Information Portals
> Knowledge Management
> Decision Support Systems
> CRM Analytics
> Clickstream analytics
> Data quality
> Data mining
There's also a strong trend towards packaging two or more of these components into one offering. You can see some of my comments on this in my last few articles at: www.mcknight-associates.com/articles.
For more information, check out SearchCRM's Best Web Links on Data Warehousing.
This was first published in July 2002