Monday, June 24, 2024

Best ETL Tools & Software

Datamation content and product recommendations are editorially independent. We may make money when you click on links to our partners. Learn More.

Clearly, ETL tools have their place in today’s data-drive enterprises. Every big data analytics project requires collecting data from disparate sources, getting it into the right format and then loading it back into the analytics software. So it’s no surprise that ETL, short for “Extract, Transform, Load” is used daily.

This ETL process can be a major headache for enterprises. In one Forrester report, customers said that up to 80 percent of their data warehouse workloads were ETL jobs. In addition to consuming valuable computing resources, this work also requires a lot of time on the part of business analysts and highly paid data scientists. As a result, both enterprises and vendors have been looking for ways to streamline and simplify the ETL process.

In the early days of the big data trend, most ETL solutions were standalone products that really only did one thing — ETL jobs. Today, however, the market has evolved and most ETL products are part of larger data integration solutions. These solutions now boast highly advanced capabilities and aim to make ETL as easy possible.

Unsurprisingly, the market for ETL solutions is booming. According to MarketsandMarkets, “The data integration market is expected to grow from $6.44 billion in 2017 to $12.24 billion by 2022, at a compound annual growth rate (CAGR) of 13.7 percent.”

Many vendors have jumped into the market with ETL and data integration solutions. The list below features eight of the largest ETL vendors and their key products.

Jump to:

1. Informatica Intelligent Data Integration Platform

Gartner named Informatica a Leader in its Magic Quadrant for Data Integration Tools, giving the vendor its highest overall score. For ETL, the company offers its Intelligent Data Integration Platform, which includes its Advanced Data Transformation, B2B Data Exchange, Connectors, Integration Hub, PowerCenter (automation) and Real-Time Integration products.

Informatica’s biggest strengths are its large customer base and its extensive product line. Gartner estimated that 9,000 organizations use Informatica’s data integration products and that 75 percent of the contract review calls it receives in relation to data integration mention Informatica. The company also has an ecosystem with more than 500 partners, and it offers training, certification, services and support.

However, the company has a reputation for high prices. Also, Informatica offers so many different products that it can be confusing for customers.

2. Dell Boomi

Purchased by Dell in 2010, Boomi offers an integration platform as a service (iPaaS) that includes ETL capabilities. Gartner named Boomi a Leader in its Magic Quadrant for Enterprise Integration Platform as a Service and noted that the company experienced more than 50 percent revenue growth in 2017, adding 1,500 clients.

The Boomi platform boasts high flexibility with the ability to integrate both cloud-based and on-premises data and applications, and it supports real-time, event-based and batch processing. The company boasts that it has more than 7,500 customers, including Novartis, LinkedIn, and Kelly-Moore Paints.

When it comes to weaknesses, Gartner cautions that some users, particularly those who describe themselves as “citizen integrators” found the Dell Boomi interface difficult to use.

3. IBM InfoSphere DataStage

IBM describes InfoSphere DataStage as “a leading ETL platform that integrates data across multiple enterprise systems.” Named a Leader by Gartner, it runs on-premises or in the cloud and on either distributed or mainframe systems. IBM also offers a number of other data integration tools, including many that are sold under the InfoSphere brand name and its iPaaS called Application Integration Suite on Cloud.

Like Informatica and Dell Boomi, IBM enjoys a very large customer base. But unlike many of the other products on this list, DataStage is focused primarily on ETL, although it integrates with other IBM tools and the Hadoop ecosystem. IBM offers flexpoint licensing.

On the downside, Gartner said that some customers find it difficult to understand IBM’s pricing, and that they often need technical help to use DataSphere with other IBM data and analytics tools.

4. SAS Data Management

Known for its business intelligence and analytics solutions, SAS calls its Data Management Platform “the industry’s leading integration technology.” It features support for Hadoop and legacy data platforms, ETL capabilities, a drag-and-drop GUI, data federation, data governance, metadata management and much more. It has also been named a Leader in the Gartner Magic Quadrant.

Strengths of the Data Management Platform include its ability to integrate data from a very broad array of sources. It has strong support for the Hadoop ecosystem, including Impala, Pivotal HAWQ, MapReduce, Pig and Hive, and it promises a truly integrated solution that is easy for business users to utilize without assistance from IT.

The biggest weakness of the SAS solution is its high price.

5. SAP Data Services

SAP Data Services promises universal data access, native-text data processing, intuitive business user interfaces, data quality dashboards, simplified data governance, high performance and high scalability. It deploys on-premises only, and it includes data quality as well as data integration capabilities. The company also offers a number of other on-premises and cloud-based data integration and analytics tools.

Customers who use other SAP software will likely be attracted to its data management and ETL products because they make it easy to incorporate data from other SAP applications. And its clean interface provides a good experience for business users.

On the con side, SAP, like many of the vendors in this list, gets negative reviews for its pricing. SAP also has such a large product lineup that customers also sometimes get confused about which products they really need.

6. Oracle Data Integration Platform Cloud

Part of Oracle’s relatively new Autonomous Cloud services, Data Integration Platform Cloud offers artificial intelligence and machine learning capabilities, as well as automated data migration and data warehouse building. According to Oracle it is “self-driving, self-securing and self-repairing.” It can access both Oracle and non-Oracle data, and it promises an intuitive user experience.

Oracle’s claim to fame in this space is really its autonomous capabilities, which make the solution easier to manage. The company also promises zero downtime for its data migration and ETL capabilities. Its cloud pricing is also fairly straightforward.

According to Gartner, however, some customers have complained about the solution’s lack of documentation. Customers have also said that it is difficult to find skilled personnel to use the solution because it is so new to the market.

7. Talend Data Management Platform

In addition to ETL capabilities, the Talend Data Management Platform offers data quality, data governance, data profiling and more. It claims that it can help customers “develop and deploy end-to-end data integration jobs 10 times faster than hand coding, at 1/5th the cost of competitors.” It was named a Leader and received the highest score in the Forrester Wave: Big Data Fabric, Q2 2018 report. It also has an open source solution called Talend Open Studio.

Talend’s strengths include its strong support for Hadoop, Spark, containers and serverless computing. Thanks to its open source roots, it also costs less than some competing solutions, and it has an Eclipse-based development environment that the company says helps customers develop and deploy integrations 10 times faster than competing solutions.

However, the Gartner report noted that some customers have reported stability issues with Talend software, and it is difficult to find staff or support partners who are familiar with the solution. See the Talend Data Platform updates.

8. Microsoft Azure Data Factory

Microsoft offers a fully managed, cloud-based ETL service called Azure Data Factory. It has connectors for more than 70 different data services, features an easy-to-use drag-and-drop interface, supports multiple programming languages and is highly scalable. Customers include Pier1 Imports, Rockwell Automation and the Real Madrid soccer team.

One of the biggest strengths of the Microsoft service is its low total cost of ownership. Also, the interface should be familiar to users of other Microsoft software. It integrates easily with other Azure services, and it boasts strong security.

On the other hand, Gartner cautioned that the solution is not yet well known because it is relatively new and untested.

Honorable Mention

Several other ETL vendors that were not included in our top eight are also worthy of mention. They include Information Builders Data Management Platform, Hitachi Vantara Pentaho Data Integration, Alooma Platform and CloverDX.

ETL Tool Comparison Chart

Vendor ETL Product Strengths Weaknesses
Informatica Data Integration Platform  • Highly rated by analysts
• Extensive product portfolio
 • Reputation for high prices
• Overlapping products
Dell Boomi Dell Boomi Platform  • Strong growth
• Large customer base
• Versatility
  • Poor user experience
IBM InfoSphere DataStage    • Large customer base
• Support for cloud, on-premises, distributed and mainframe systems
 • Confusing pricing
• Difficult deployment
SAS Data Management  • Large customer base
• Ease of use
• Strong Hadoop support
 • High price
SAP Data Services Support for other SAP applications
Easy-to-use interface
High price
Oracle Data Integration Platform Cloud  • Autonomous capabilities
• Zero downtime
 • Lack of documentation
• New to the market
Talend Data Management Platform  • Low price
• Support for containers, serverless computing and open source solutions
• Eclipse-based development
 • Stability issues
• Difficult to find experienced staff
Microsoft Azure Data Factory   •  Low price
• Familiar interface
 • New to the market


Subscribe to Data Insider

Learn the latest news and best practices about data science, big data analytics, artificial intelligence, data security, and more.

Similar articles

Get the Free Newsletter!

Subscribe to Data Insider for top news, trends & analysis

Latest Articles