Best Data Integration Tools42Data integration involves combining data residing in different sources and providing users with a unified view of these data.Dell Boomi1https://dudodiprj2sv7.cloudfront.net/vendor-logos/QU/Ro/1VKOUZJX2NK3-180x180.PNGSQL Server Integration Services2https://dudodiprj2sv7.cloudfront.net/vendor-logos/tf/J4/RTX1AO2GSVNS-180x180.JPEGCenterprise Data Integrator3https://dudodiprj2sv7.cloudfront.net/vendor-logos/RT/EZ/BE189NVZUPFP-180x180.JPEGOracle GoldenGate4https://dudodiprj2sv7.cloudfront.net/vendor-logos/VC/02/T4E108T4IWP2-180x180.PNGOracle Data Integrator5https://dudodiprj2sv7.cloudfront.net/vendor-logos/VC/02/T4E108T4IWP2-180x180.PNGDataloader.io6https://dudodiprj2sv7.cloudfront.net/vendor-logos/tA/jR/XVG2TM0FRR4B-180x180.PNGTalend Open Studio7https://dudodiprj2sv7.cloudfront.net/vendor-logos/gz/28/APJ21HOT8KJ1-180x180.JPEGInformatica Enterprise Data Integration8https://dudodiprj2sv7.cloudfront.net/vendor-logos/VF/Bu/OVVS3ZL385NT-180x180.JPEGPowerCenter9https://dudodiprj2sv7.cloudfront.net/vendor-logos/VF/Bu/OVVS3ZL385NT-180x180.JPEGTalend Data Integration10https://dudodiprj2sv7.cloudfront.net/vendor-logos/gz/28/APJ21HOT8KJ1-180x180.JPEGIBM InfoSphere Information Server11https://dudodiprj2sv7.cloudfront.net/vendor-logos/pB/Jj/SEO8QKLQWG7P-180x180.JPEGOracle Warehouse Builder12https://dudodiprj2sv7.cloudfront.net/vendor-logos/VC/02/T4E108T4IWP2-180x180.PNGSAS/Access13https://dudodiprj2sv7.cloudfront.net/vendor-logos/1R/C2/78WM406O343V-180x180.JPEGTIBCO Data Virtualization14https://dudodiprj2sv7.cloudfront.net/vendor-logos/kf/kH/RMNIMTW93FUN-180x180.PNGNetWeaver Process Integration15https://dudodiprj2sv7.cloudfront.net/vendor-logos/sW/OA/CZD3RG21S16S-180x180.JPEGelastic.io Integration Platform16https://dudodiprj2sv7.cloudfront.net/product-logos/AS/Qr/TM4IW8VX1B9F.PNGAnalyza17https://dudodiprj2sv7.cloudfront.net/product-logos/Po/cF/K7QRNT6IJ31H.PNGSAS Data Integration Studio18https://dudodiprj2sv7.cloudfront.net/vendor-logos/1R/C2/78WM406O343V-180x180.JPEGRepreZen API Studio19https://dudodiprj2sv7.cloudfront.net/product-logos/NN/xc/6JM966GH86PF.PNGBusinessObjects Data Integrator20https://dudodiprj2sv7.cloudfront.net/vendor-logos/sW/OA/CZD3RG21S16S-180x180.JPEGTask Factory21https://dudodiprj2sv7.cloudfront.net/product-logos/nR/vZ/IEU1U6EM3BLD.PNGSAS DataFlux22https://dudodiprj2sv7.cloudfront.net/vendor-logos/1R/C2/78WM406O343V-180x180.JPEGActian DataConnect23https://dudodiprj2sv7.cloudfront.net/vendor-logos/zG/8t/NQRX03ZI9MZT-180x180.PNGDenodo24https://dudodiprj2sv7.cloudfront.net/product-logos/B0/5B/XI53AWLN9JXF.pngInformatica Master Data Management25https://dudodiprj2sv7.cloudfront.net/vendor-logos/VF/Bu/OVVS3ZL385NT-180x180.JPEG

Data Integration Tools

Best Data Integration Tools

TrustMaps are two-dimensional charts that compare products based on satisfaction ratings and research frequency by prospective buyers. Products must have 10 or more ratings to appear on this TrustMap, and those above the median line are considered Top Rated.

Data Integration Tools Overview

What are Data Integration Tools?

The need for data integration emerges from complex data center environments where multiple different systems are creating large volumes of data. This data must be understood in aggregate, rather than in isolation. Data integration is nothing more than a technique and technology for providing a unified and consistent view of enterprise-wide data.

Data Integration Tools Features & Capabilities

  • Ability to process data from a wide variety of sources such as mainframes, enterprise applications, spreadsheets, proprietary databases, etc.

  • Ability to process unstructured data from social media, email, web pages, etc.

  • Syntactic and semantic checks to make sure data conforms to business rules and policies

  • Deduplication and removal of incorrectly or improperly formatted data

  • Support for metadata

Types of Data Integration

There are several different approaches to achieving this goal which are quite different to each other and essentially solve slightly different problems: The main technologies for data integration are Extract, Transform Load (ETL), Enterprise Application Integration (EAI), and Enterprise Information Integration (EII), or data virtualization as it is more often called today.


Products listed in this category belong to the ETL data integration approach. Unlike the other listed approaches, ETL is designed for data migration and integration of large volumes of data to provide a basis for decision-making.

What is ETL?

ETL is a process whereby large volumes of required data are extracted from various databases and converted into a common format. The data is then cleansed, and loaded into the specialized reporting database called a data warehouse. It is then available for standard reporting purposes.


The data used in ETL can come from any source including flat files, Excel data, application data like CRM or ERP data, or mainframe application data. Perhaps the most difficult part of the process is the “Transform” component. Here, not only must the data be cleansed and any duplicates removed, but the software also has to resolve data consistency issues. It applies rules to consistently convert data to the appropriate form for the data warehouse or repository.

Once the data has been loaded into a data warehouse it is available for querying by business intelligence front-end processes that can pull consolidated data into reports and dashboards.

Shortcomings of Data Warehouses

One shortcoming of the data warehouse approach is that the data is not always current. Data warehouses pull data from databases periodically in batches, not in real time. If the data in the source database has changed, this might not be reflected in the data in the warehouse. Various strategies can be employed to achieve “real-time ETL”, although some of them place a significant load on the database. This can have performance repercussions.


The simplest thing to do is simply increase the frequency of batch updates to near real-time processing. But there are other solutions including continuously feeding the database using real-time data transport technologies, the use of staging tables, or a real-time data cache.

Pricing Information

Enterprise-level data integration tools can be very expensive with some products costing upwards of $10,000 per user per year. On top of that, you may need to pay for professional services to get up and running. SMB solutions are significantly cheaper than this.

Data Integration Products

Listings (1-25 of 80)

Dell Boomi

57 Ratings

Dell's Boomi product (acquired 2010) is a cloud integration platform.

SQL Server Integration Services

148 Ratings

Microsoft's SQL Server Integration Services (SSIS) is a data integration solution.

Centerprise Data Integrator

17 Ratings

Centerprise Data Integrator is an integration platform that includes tools for data integration, data transformation, data quality, and data profiling.

Oracle GoldenGate

51 Ratings

Oracle GoldenGate is database management software for data integration, and availability support for heterogeneous databases.

Oracle Data Integrator

89 Ratings

Oracle has about 3,500 data integration customer and competes with Informatica, IBM InfoSphere, Talend and SAS DatFlux.

Dataloader.io

22 Ratings

Dataloader.io delivers a cloud based solution to import and export information from Salesforce.

Talend Open Studio

36 Ratings

Talend Open Studio is a data integration solution.

Informatica Enterprise Data Integration

45 Ratings

Informatica is the leading vendor in the data integration space with about 5,000 customers.

PowerCenter

16 Ratings

PowerCenter from Informatica is a data integration platform.

Talend Data Integration

38 Ratings

The Talend Integration Suite, from Talend, is a set of tools for data integration.

IBM InfoSphere Information Server

21 Ratings

IBM InfoSphere is an enterprise grade master data management solution used by over 700 customers. It competes with Oracle's Siebel UCM product and Informatica.

Oracle Warehouse Builder

16 Ratings

Oracle Warehouse Builder is a data integration solution, from Oracle.

SAS/Access

10 Ratings

SAS/Access is a data integration solution, from SAS.

TIBCO Data Virtualization

7 Ratings

Cisco Data Virtualization, formerly Composite (acquired July 2013) is, as the name might suggest, a data or datacenter virtualization platform.

NetWeaver Process Integration

6 Ratings

SAP NetWeaver Process Integration is an application integration solution.

elastic.io Integration Platform

2 Ratings

The elastic.io Integration Platform is designed as a set of tools for data transformation and data integration both cloud-to-cloud and cloud-to-ground. It belongs to the hybrid integration platform category, as it can be deployed in the cloud as well as on-premise. The elastic.io platform is...

Analyza

1 Ratings

Analyza is a business intelligence solution that is provided by PIT Business. The vendor provides support services in Luxembourg, Belgium, France, and other parts of Europe. Analyza allows users to: Build several indicators and dashboardsBuild ad-hoc analysis without IT knowledgeNavigate through...

SAS Data Integration Studio

8 Ratings

SAS Data Integration Studio is as the name would suggest a data integration solution, from SAS.

RepreZen API Studio

1 Ratings

RepreZen™ API Studio is an enterprise-class API design platform, built from the ground up to meet the demands of large-scale integration programs. The vendor says that while other tools only address individual APIs, RepreZen optimizes at the organizational scale, aligning interfaces and...

BusinessObjects Data Integrator

7 Ratings

BusinessObjects Data Integrator from SAS is a data integration platform.

Task Factory

1 Ratings

According to the vendor, Task Factory offers essential, high-performance components and tasks for SQL Server Integration Services (SSIS) that eliminate the need for programming. With over 50 components, Task Factory aims to increase productivity, improve performance and increase ROI. Task Factory...

SAS DataFlux

7 Ratings

SAS DataFlux's capabilities handle data profiling, matching, cleansing and monitoring. Capabilities are available as individual products or as a platform. DataFlux competes with Informatica, Trilliium, Ataccama, and SAP Data Quality Management.

Actian DataConnect

3 Ratings

Originally developed by Pervasive Software, the Actian DataConnect (formerly Actian Integration Hub) is data integration technology.

Denodo

4 Ratings

Denodo is the eponymous data integration platform from the global company headquartered in Silicon Valley.

Informatica Master Data Management

20 Ratings

Informatica MDM is an enterprise master data management solution that competes directly with IBM's InfoSphere and Oracle's Siebel UCM product. The product has about 200 licensed users.