Kimball University: Should You Use An ETL Tool?

You can still hand-code an extract, transform and load system, but in most cases the self-documentation, structured development path and extensibility of an ETL tool is well worth the cost. Here’s a close look at the pros and cons of buying rather than building.

By Joy Mundy

The Extract, Transformation, and Load (ETL) system is the most time-consuming and expensive part of building a data warehouse and delivering business intelligence to your user community. [Read more...]

The case for a data quality platform

We have recently been investigating why so many data migration projects (84%) run over time or budget. Over half of the respondents in our survey who had run over budget blamed inadequate scoping (that is, they had not properly or fully profiled their data) and more than two thirds of those that had gone over time put their emphasis in the same place. [Read more...]

Open Source ETL

Some 18 months ago I wrote an article called “the case for open source ETL“. At that time I had identified four products (one of which, Kettle, has since been acquired by Pentaho) in the open source data integration market. [Read more...]

Is Ab Initio Worth Evaluating?

Ab Initio has been around for long enough to make a name for themselves in the ETL space. Their marketing approach appears to be one of mystique: maintain secrecy around the product while allowing some information out about the high-end customers, creating interest because of the tantalizing tidbits they provide. [Read more...]

ETL poll produces unexpected results

For the last three months of 2010 Passionned have run a poll on their ETLtool.com site asking visitors what they thought were the most important requirements when choosing an ETL tool. The ETLtool.com site has been running since 2005 and advises visitors on the various ETL (data integration) tools available, what their strong and weak points are, how to choose an ETL tool and sells a 50 page report where popular products are analyzed and compared to facilitate choosing the right product for individual circumstances. [Read more...]