The 7 biggest benefits of ETL tools

The 7 biggest benefits of ETL tools
A decade ago the vast majority of data warehouse systems were hand crafted, but the market for ETL software has steadily grown and the majority of practitioners now use ETL tools in place of hand-coded systems. Does it make sense to hand-code (SQL) a data warehouse today, or is an ETL tool a better choice?

Read more…

Cloud Spring 2014 release named a game-changer by Informatica

Now available is Informatica’s Cloud Spring 2014. Ash Kulkarni, senior vice president and general manager, Data Integration at Informatica calls it a game-changer. Read more…

Future prospects of ETL tools

Contrary to many studies that evaluate ETL tools based only on their current market share and functionality, our study (the ETL Tools & Data Integration Survey) also attempts to evaluate ETL tools based on their expected future performance. Read more…

How to measure usability of ETL tools?

The maximum number of points awarded in our ETL tools & Data Integration Survey to an ETL tool for its ease-of-use was eleven. A maximum of two points was awarded for each of the four attributes, indicated by one or more plus (+) signs and points were allocated depending on the number of days of training suggested by the vendors (less training required – more points for Ease of Use). Read more…

ETL evaluation based on characteristics

The ETL tools were in our ETL Tools & Data Integration Survey evaluated based on the following characteristics: Read more…

Introduction and structure of the ETL study

Since 2003, we have been closely monitoring the market for ETL and data integration tools. In the past, the focus was on the market leaders who were often seen as visionaries and leaders. Read more…

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 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…

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…

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…

Customers Analytics & ETL