FREE DM Review Site Registration!
Sign-up today and access DM Review on the Web!

Your FREE registration entitles you to:
FREE email newsletters

FREE access to all DM Review content

FREE access to web seminars, resource portals, our white paper library and more!

   

What parameters should be considered to compare the top five ETL tools?

Question:

  • I want to compare the top five ETL tools. What parameters should be considered?

Sid Adelman's Answer:

  • You should consider the following:

    1. Ease of use - some ETL tools are far more difficult than others, consider the learning curve.
    2. Support - How well the vendor responds when you have problems.
    3. Cost - Some of these products are expensive.
    4. Performance - This is especially important if you have large databases.
    5. Vendor stability - Will the vendor be around in 2007?
    6. Availability of training.
    7. Availability of experienced ETL jockeys to hire.
    8. Availability of experienced ETL consultants.
    9. Metadata capability of the ETL tool (if you are planning to use the ETL metadata repository).
    10. Metadata interfaces with your other tools (BI and modeling) that produce and use metadata.

Sid Adelman is a principal in Sid Adelman & Associates, an organization specializing in planning and implementing data warehouses, in data warehouse and BI assessments, and in establishing effective data architectures and strategies. He is a regular speaker at DW conferences. Adelman chairs the "Ask the Experts" column on www.dmreview.com. He is a frequent contributor to journals that focus on data warehousing. He co-authored Data Warehouse Project Management and is the principal author on Impossible Data Warehouse Situations with Solutions from the Experts and Data Strategy. He can be reached at (818) 783-9634 or visit his Web site at www.sidadelman.com.

For more information on related topics, visit the following channels:



Industry Vendors