How to evaluate data warehouse software in five steps

    Requires Free Membership to View

    Login

    When you register, you'll begin receiving targeted emails from my team of award-winning writers. Our goal is to keep you informed on the hottest data and information management trends today.

    Hannah Smalltree, Editorial Director

    By submitting your registration information to SearchDataManagement.com you agree to receive email communications from TechTarget and TechTarget partners. We encourage you to read our Privacy Policy which contains important disclosures about how we collect and use your registration and other information. If you reside outside of the United States, by submitting this registration information you consent to having your personal data transferred to and processed in the United States. Your use of SearchDataManagement.com is governed by our Terms of Use. You may contact us at webmaster@TechTarget.com.

In this section of the Data Warehouse Buyer's Guide, you'll find five steps for evaluating data warehouse software from industry expert Rick Sherman, including advice on how to determine what data warehouse software capabilities you need and how to create a set of software criteria to aid with the evaluation process.

Data Warehouse Buyer's Guide Table of Contents:
 Selecting the right data warehouse platform for your organization
How to evaluate data warehouse software in five steps
 Commodity hardware aiding data warehouse appliance performance, costs
Why you should build a data warehouse
Workload management tools key to running busy data warehouses

What's the process for evaluating data warehouse software?

1. Establish what data warehouse software you need. The core set of tools: database; extract, transform and load (ETL); and business intelligence (BI). I also strongly suggest a data modeling tool. Some companies may also need to examine data cleansing software -- but note that most of data quality is performed in the ETL code that you write.

2. Determine what you already have, or what you have standardized on database software. Also, are you using other tools, such as BI tools, with other applications? A word of caution, though: Make sure you have the expertise to use the software you already have in-house AND that people are happy with that software.

3. Develop a shortlist. There are a few ways to get this list: look at industry analyst research reports, i.e. Forrester or Gartner; see what is bundled with software you already have such as ETL capabilities bundled with your database or BI tool; ask peers; and read articles by "independent" columnists.

4. Create your evaluation criteria. If you're a TWDI member, you will be able to find checklists that you could use as a start for your criteria. Try to avoid lengthy feature packed checklists, though, as you can easily lose sight of the forest for the trees. The criteria should be Does the tool work for what you plan to do? -- not Is it the most feature-packed tool in the universe? Much of what these tools offer is mature technology that would satisfy most people's evaluation criteria, so you should have more than one choice in each software category.

5. Perform the data warehouse software evaluation. Two words of advice: keep it short and if you can structure it as a Proof-of-Concept (POC) that can be used in your project, all the better.

More data warehouse and data warehouse software information

Data Warehouse Buyer's Guide Table of Contents:
Selecting the right data warehouse platform for your organization
How to evaluate data warehouse software in five steps
 Commodity hardware aiding data warehouse appliance performance, costs
Why you should build a data warehouse
Workload management tools key to running busy data warehouse

This was first published in June 2008

Back to top