Ranking ETL tools | Market position of ETL tools

Ranking the ETL tools by category


The ETL Tools & Data Integration Research Report is a thorough, 100% independent analysis of the ETL tools market.

Expert opinions on 22 ETL tools
Access all research data
Over 90 selection criteria
Used in over 50 countries

order now

ETL tool ranking

Click on the links below to see what graphs and scores are available in the ETL Tools & Data Integration Survey 2018.

Buy and download the ETL Survey Report

ETL Functionality

In the graph below, the ETL tools are ranked by completeness. Their position has been calculated by awarding one point for each criterion for which a positive answer (‘Yes’) was received and adding up the points. The only exception is the ‘slowly changing dimensions’ criterion; if an ETL tool provided only manual support for this, zero points were awarded. If the tool provided support in the form of a wizard, one point was awarded. If out-of-the-box functionality was provided, two points were awarded.

ETL core functionality

In some cases, half points were awarded when the required functionality was only partly available. If the answer was ‘Yes, db’, then this concerns functionality that is only available in combination with the database, as is the case with Oracle Warehouse Builder (OWB), SQL Server Integration Services and IBM DB2 Warehouse Edition.

The maximum number of points was 51.

Ease-of-Use

A maximum of eight points awarded to the ETL tool for its ease-of-use. A maximum of two points was awarded for each of four attributes, 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). If the verdict was negative, then points were deducted. If for example, ease of use, WYSIWYG and task compatibility ETL/EAI earned a plus sign and screen design a minus sign, the tool was awarded two points (one points for each plus sign, minus one point for the minus sign).

The maximum number of points was 11.

Ease of use

There is a big difference between an ETL tool offering various options and features, and making them easy enough for everyone to use. A number of ETL tools offer certain features that can only be implemented by programming, either from inside or outside the tool. In these cases it was decided not to include this functionality in the final score, because the advantage compared with ‘normal programming’ was too small. We assumed that for a feature to work efficiently, it had, to some extent, to be implemented in an easy-to-use graphical interface. If you only intend your ETL tool to be used by highly trained IT professionals this may be less relevant.

Connectivity

The connectivity score was calculated by allocating points for the number of platforms that a product runs on natively, the number of sources that can be read natively, the number of enterprise applications which can be read directly and the support for reading messages from queues. The maximum number of points was 8.

Connectivity of ETL tools

Platforms

Categorization by number of supported platforms is shown in the graph below. All the various Windows versions have been added together and counted as one platform. The major three flavors of Unix have been counted separately. Linux has been counted as one platform. Finally since there are still some installations we looked at the Digital (now from HP) machines’ running OpenVMS and Tru64, the number of installations and the support for these platforms is decreasing.

Platforms supported

Future Prospects

Contrary to many studies that evaluate tools based only on their current market share, this study also attempts to evaluate ETL tools in terms of their future prospects. Market share is concerned with the past; it says nothing about the future. WordPerfect once had a huge market share but proved to have very little future potential.

ETL future prospects

The growth potential looks at a combination of how complete a product is i.e. the total number of features (including ease-of-use, connectivity and platform support) and how much functionality has been added in the last three years. This gives some indication of the investment that can be expected in the product and is an important issue when choosing a product, it is best to avoid products that are still existing on past glories and not investing in the future. Which ETL tools will dominate the market in the coming years?

Product Ranking based on ALL categories

There have been many requests for us to provide one total graph with the scores of all the products on all categories. Internally we had many discussions about how useful these scores are since we are comparing products which are intended for different customer situations, but by popular demand here is the “Total” view.

Overall ranking ETL tools

Price versus performance

In past versions of this report we attempted to look at price versus performance. Product pricing has become so complex that we can no longer do this with any degree of accuracy. We no longer publish prices in the report

Vendors were requested to provide Passionned with a price quotation for the following two configurations:

Configuration 1
Operating system: Windows 2003 Server * Hardware: Intel / 2 processors * Connections: Oracle, SQL Server (including flat files and ODBC/OLE DB) * Developers: 2 * Servers: Development and test (1 processor), production (2 processors)

Configuration 2
Operating system: Unix IBM AIX or HP UX or Sun Solaris * Hardware: 4 processors * Connections: Oracle, DB/400, SAP (including flat files) * Developers: 3 * Servers: Development and test (2 processors), production (4 processors)

Buy and download the ETL Survey Report

A selection of our customers

Become a customer with us now

Do you also want to become a customer of ours? We are happy to help you with ranking etl tools (market position of etl tools) or other things that will make you smarter.

Daan van Beek, Managing Director

DAAN VAN BEEK MSc

Managing Director

contact me directly

Fact sheet

Number of organizations serviced
122
Number of training courses
123
Number of participants trained
124
Overall customer rating
8.9
Number of consultants & teachers
125
Number of offices
3
Number of years active
14