ETL Tools Comparison

ETL tools comparisonThe ETL tools comparison is a 100% vendor independent and reveals all the product details of nineteen ETL tools compared on 90 business and technical criteria like architecture, scalability, maintainability, functionality, usability and so forth.

ETL Tools comparison criteria

The criteria that were used for the ETL tools comparison were divided into seven categories:

  • Architecture
  • ETL functionality
  • Ease-of-use
  • Reusability
  • Debugging
  • Real-time
  • Connectivity

The criteria underlying the categories are the business and technical requirements for selecting ETL tools. It is all put together in the ETL matrix in the ETL Tools & Data Integration Survey 2013, showing how each ETL tool scores against the criteria.

ETL Tools comparison

The comparison matrix shows the results of the following ETL & Data Integration tools.

No. List of ETL Tools Version ETL Vendors
1.Oracle Warehouse Builder (OWB)11gR1Oracle
2.Data ServicesXI 4.0SAP Business Objects Newest version examined
3.IBM Information Server (Datastage)8.1IBM
4.SAS Data Integration Studio4.4SAS Institute Newest version examined
5.PowerCenter Informatica9.5Informatica Newest version examined
6.Elixir Repertoire7.2.2Elixir
7.Data Migrator7.7Information Builders Newest version examined
8.SQL Server Integration Services10Microsoft
9.Talend Studio for Data Integration5.2Talend
10.DataFlow Manager6.5Pitney Bowes Business Insight
11.Pervasive Data Integrator10.0Pervasive Software
12.Open Text Integration Center7.1Open Text
13.Oracle Data Integrator (ODI)11.1.1.5Oracle Newest version examined
14.Data Manager/Decision Stream8.2IBM (Cognos)
15.Clover ETL3.1.2Javlin
16.Centerprise5.0Astera  Newest version examined
17.DB2 Infosphere Warehouse Edition9.1IBM
18.Pentaho Data Integration4.1Pentaho
19Adeptia Integration Suite5.1Adeptia
20.DMExpress5.5Syncsort Newest version examined
21.Expressor Data Integration3.7QlikTech Newest version examined

Commercial ETL Tools comparison

There are sixteen ETL & Data Integration tools which don’t fall into the category open source and which are commercially available. The best known commercial ETL tools are PowerCenter from Informatica and IBM’s Information Server.

Open source ETL tools comparison

There are three ETL & Data Integration tools which have an open source license structure. This doesn’t mean that you don’t have to pay for the software and/or service. All the vendors of the three open source ETL tools have a paid product offering. The open source ETL tools are: CloverETL, Pentaho Data Integration and Talend Open Studio.

The ETL Tools & Data Integration Survey Report

All the information is packaged as a report and is available for purchase: the ETL Tools & Data Integration Survey 2013.

Buy and download the ETL Survey Report

Since 2003, the consultancy and analyst company Passionned Group has been closely monitoring the ETL & Data Integration market and we put our professional experience, vision and research findings in a comprehensive ETL tools comparison available for purchase.