O'Reilly logo

DATA WAREHOUSING FUNDAMENTALS: A Comprehensive Guide for IT Professionals by Paulraj Ponniah

Stay ahead with the world's most comprehensive technology and business learning platform.

With Safari, you learn the way you learn best. Get unlimited access to videos, live online training, learning paths, books, tutorials, and more.

Start Free Trial

No credit card required

Appendix C. GUIDELINES FOR EVALUATING VENDOR SOLUTIONS

Here are a few practical guidelines. These are general guidelines relating to all types of products that perform various functions from data extraction through information delivery. Adapt and apply these to your specific environment.

  • First and foremost, determine the functions in your data warehouse that absolutely need vendor tools and solutions.

  • For each type of product you need, carefully list the features that are expected. Divide the features into groups by importance—high, medium, and low. Use these groups of features to grade the products you are considering.

  • Allocate enough time to research available solutions and vendors thoroughly.

  • If you try to incorporate solutions from too many different vendors, you must be prepared to face serious challenges of incompatibilities and restrictions for integration. Stay with two or three vendors whose products are most appropriate for your needs.

  • Metadata is a key component of a data warehouse. Ensure that the vendor products you choose can handle metadata satisfactorily.

  • The standing and stability of the vendor is equally important as the effectiveness of the products themselves. Even when the products are suitable for your environment, if you are concerned about the staying power of the vendor, have second thoughts on selecting these products.

  • Never rely solely on vendor demonstrations as the basis for your selection, nor should you check only the references furnished by the vendors ...

With Safari, you learn the way you learn best. Get unlimited access to videos, live online training, learning paths, books, interactive tutorials, and more.

Start Free Trial

No credit card required