The 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 Tool Survey 11.0, showing how each ETL tool scores against the requirements.
ETL Tools comparison
The comparison shows the results of the following ETL tools.
1. Commercial ETL Tools comparison
> Oracle Warehouse Builder (OWB)
Oracle Warehouse Builder (OWB) enables you to take raw data, typically in different formats and disparate systems, and transform it into high-quality information that’s optimized for business reporting and analytics.
With a single, easy-to-use interface, Oracle Warehouse Builder (OWB) allows you to design ETL processes between target warehouses, intermediate storage areas and the end user.
> SAP Business Objects Data Services XI
SAP Business Objects Data Services allows organizations to easily explore, extract, transform, and deliver data anywhere, at any frequency. Ensure the integrity of your data, maximize developer productivity, and accelerate data integration performance for all operational and analytic initiatives.
> IBM Information Server (DataStage)
IBM Information Integration is the leader in data integration. Our platform integrates and transforms data improving productivity, flexibility and performance, so you have the right information for your business.
> SAS Data Integration Studio
SAS Data Integration Studio gives you THE POWER TO KNOW how to quickly attain and manage consistent and trusted data throughout the organization. We offer a comprehensive data integration solution that provides organizations with the flexibility, reliability and agility to respond quickly to new data integration requirements, consolidate vendors, standardize on one integration solution and reduce the overall cost of data integration.
> Informatica PowerCenter
Informatica PowerCenter maximizes the business value of data. PowerCenter is a unified enterprise data integration platform for accessing, discovering, and integrating data from virtually any business system, in any format.
> Elixir Repertoire
Enterprises today need a powerful yet flexible data access solution to extract, aggregate, transform and load across multiple disparate data sources from databases, applications, as well as office documents. With business users quickly becoming more technically savvy, the data access bottleneck can be eliminated with an easy-to-use data extraction and transformation tool.
> Information Builders Data Migrator
Information Builders data integration solutions allow for direct access to all of your data, so you can design your architecture to address the unique information needs of all your users. It accelerates the deployment and reduces the risk of all types of data integration projects ý including extract, transform, and load (ETL), enterprise information integration (EII) initiatives, and Web services deployments.
> Microsoft SQL Server Integration Services (SSIS)
Creating process flow for data through your organization can be one of the most challenging tasks. SQL Server Integration Services (SSIS) helps you with a robust enterprise-class data integration application.
> Pitney Bowes DataFlow Manager
Sagent Data Flow is a powerful and flexible integration engine that brings together data from disparate sources into a single view where a comprehensive set of data transformation tools can merge and cleanse the data to enhance its business value.
> Pervasive Data Integrator
In today’s information-driven markets, businesses face the competitive challenge of finding new and better ways to aggregate, replicate, convert, and load data from across the enterprise into centralized stores for informed decision making.
> OpenText Integration Center
Data Integration accesses, enriches, and delivers corporate data from any source to any target for warehousing and business intelligence.
> ETL Solutions Transformation Manager
The effective capture, management and leveraging of data, whether internal or external, represents the greatest opportunity – and the most difficult challenge – for any enterprise. Data Integration is fundamental to meet the challenge and often requires a substantial and on-going proportion of the organization’s resources to deliver.
> IBM DataManager / DecisionStream
IBM Cognos data integration is an enterprise-wide ETL solution designed for high performance business intelligence. It optimizes data merging, extraction, transformation, and dimensional management to deliver data warehouses ready for business reporting and analysis.
> Astera Centerprise
Centerprise Data Integrator 5 provides a powerful, scalable, high-performance and affordable integration platform designed to be used by your business information experts.
> IBM DB2 Warehouse Edition
is the most comprehensive data warehouse solution in the industry; providing you with all of the capabilities necessary to glean maximum return from your most important investment – your information!
> Adeptia Integration Suite
Adeptia Integration Suite is a state-of-the-art software product that includes comprehensive, end-to-end functionality to meet any organizations’ current and future integration requirements. It integrates any application with any data at any location.
2. Open source ETL tools comparison
> Pentaho Data Integration
Pentaho Data Integration is a powerful, metadata-driven ETL tool designed to bridge the gap between business and IT; Turning your company’s data into increased profits.
> Talend Open Studio Integration Suite
Talend’s flagship product, Talend Open Studio, is the most open, innovative and powerful data integration solution on the market today. Talend Open Studio provides advanced capabilities that dramatically improve the productivity of data integration job design; and proven scalability to ensure optimal execution.
> CloverETL
CloverETL Engine and CloverETL GUI (Designer) are tools meant for developing data transformations and data integration applications. They are based on Java technology and therefore platform independent and resource-efficient.
The ETL Tool Survey Report
All the information is packed as a report available for purchase: the ETL Tool Survey 2011 .
Since 2003, the consultancy and analyst company Passionned Group has been closely monitoring the ETL market and we put our professional experience, vision and research findings in a comprehensive ETL tools comparison available for purchase.
