ETL Tools - general information

ETL tools are designed to save time and money by eliminating the need of 'hand-coding' when a new data warehouse is developed. They are also used to facilitate the work of the database administrators who connect different branches of databases as well as integrate or change the existing databases.

There are several requirements that must be had by ETL tools in order to deliver an optimal value to users, supporting a full range of possible scenarios.

Those are:
- data delivery and transformation capabilities
- data and metadata modelling capabilities
- data source and target support
- data governance capability
- runtime platform capabilities
- operations and administration capabilities
- service-enablements capability.

ETL tools comparison criteria

The research presented in this article is based on Gartner’s data integration magic quadrant, forrester researches and our professional experience. The portal is not affiliated with any of the companies listed below in the comparison.

The research inclusion and exclusion criteria are as follows:
- range and mode of connectivity/adapter support
- data transformation and delivery modes support
- metadata and data modelling support
- design, development and data governance support
- runtime platform support
- enablement of service and three additional requirements for vendors:
- $20 milion or more of software revenue from data integration tools every year or not less than 300 production customers
- support of customers in not less than two major geographic regions
- have customer implementations at crossdepartamental and multiproject level.

ETL Tools Comparison

The information provided below lists major strengths and weaknesses of the most popular ETL vendors.

IBM (Information Server Infosphere platform)

Informatica PowerCenter

Microsoft (SQL Server Integration Services)

Oracle (OWB and ODI)

SAP BusinessObjects (Data Integrator / Data Services)


Sun Microsystems



Tibco Software


iWay Software

Pervasive Software

Open Text

Pitney Bowes Software