ETL TOOLS COMPARISON

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.

ETL as a service for Redshift

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 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 cross-departamental and multiproject level.

ETL Tools Comparison

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

Alooma

Advantages:

Disadvantages:

IBM (Information Server Infosphere platform)

Advantages:

Disadvantages:

Informatica PowerCenter

Advantages:

Disadvantages:

Microsoft (SQL Server Integration Services)

Advantages:

Disadvantages:

Oracle (OWB and ODI)

Advantages:

Disadvantages:

SAP BusinessObjects (Data Integrator / Data Services)

Advantages:

Disadvantages:

SAS

Sun Microsystems

Sybase

Syncsort

Tibco Software

ETI

iWay Software

Pervasive Software

Open Text

Pitney Bowes Software




ETL as a service for Redshift