ETL Tool Research

I apologize in advance because I'm sure this has been asked numerous times, but wanted more up-to-date responses.

I'm researching DI tools and wanted some opinions on what others have used and their thoughts on the tools. I've researched IBM, Informatica, SSIS, Pervasive, SAP Data Integrator, Talend, CloverETL & Pentaho (think that list is complete).

My usage would be to batch load a DW with various sources (IBM DB2, SQL Server, mySQL, flat files) and Teradata target - design is all the usual dims, facts, scd types 1-2-3, surrogate keys, etc

Just wondering what thoughts on any of these or (or one not listed), what do you like/dislike about them?

Thanks!

Hi wonka,

Unless this is a purely academic exercise, I think it's important to also consider the resources available for each tool, including people (staff, consultants), documentation, training, community (forums, blogs, events), infrastructure required to support (i.e. how efficient are they), software licensing costs.

Mike

Hi there,

The attached link will bring you to a free solutions directory and guide that outlines 24 of the top providers in the space. Pentaho, Talend and CloverETL are covered as well as 21 other providers. The guide simply breaks down feature capabilities and resources to discover more about each provider included. No marketing slant in the guide, just facts on each of the 24 providers included. It is designed to present the facts and to inform those looking for solutions of the option out here. I hope it might help in your research. Best of luck. Also the site itself is pack with industry updates, best practices and presentations from across the Data Integration and ETL space..

http://solutions-review.com/data-integration/free-2013-data-integration-tools-software-buyers-guide/