Data Integration Tools

Best Data Integration Tools include:

Matillion, Astera Centerprise, Oracle GoldenGate, and Task Factory.

Data Integration Tools TrustMap

TrustMaps are two-dimensional charts that compare products based on trScore and research frequency by prospective buyers. Products must have 10 or more ratings to appear on this TrustMap.

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 cleaned, 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

(1-25 of 97) Sorted by Most Reviews

Syncsort Connect ETL (formerly DMX)
Syncsort Connect ETL (formerly DMX) is a data integration platform, from Syncsort.
iWay DataMigrator
the Information Builders' iWay DataMigrator is a data integration toolset.
Invantive Data Access Point
Cross-protocol data exchange across many platformsInvantive Data Access Point is both online and on-premises software that allows exchanging data across various communication protocols. Invantive Data Access Point acts as a proxy that based upon legacy and/or Invantive SQL statements exchanges data …
SAS Federation Server
SAS Federation Server is a data integration service.
Omni-Gen Data Quality Edition
Universal Adapter Framework from Information Builders is a data integration solution.
DataRush, formerly of Pervasive Software, is data integration technology gained with the company in Actian's April 2013 acquisition.
Formstack Sync (formerly Bedrock Data)
Formstack Sync (formerly Bedrock Data) is a bi-directional sync tool, now from Formstack since the company acquired Bedrock Data in 2019.
Stone Bond Enterprise Enabler
Enterprise Enabler is a data virtualization or data integration platform from Stone Bond Technologies in Houston, Texas.
Unit4 Consolidation
Unit4 Consolidation integrates data from multiple sources across a fragmented IT structure providing a single-source of truth for analysis, compliance, and oversight.
Layer7 Live API Creator (formerly CA Live API Creator)
Layer7 Live API Creator (formerly CA Live API Creator) from Broadcom company CA Technologies helps create application back-ends for internal applications, mobile development projects, data-as-a-service exposure, Internet of Things (IoT) enablement and partner application integrations, and also creat…
1EDISource is an EDI software product designed to help organizations transform B2B operations.
Progress Software offers DataDirect, a data connectivity solution which helps enterprises integrate data across relational, big data and cloud databases.
VL OMNI is a point to multi-channel integration partner for real-time accurate customer order data, shipment details, inventory, and prices. According to the vendor, this is how VL OMNI works: VL OMNI’s integrations work by connecting unique applications together (see diagram, below), normalizing th…
Layer2 Cloud Connector
The Layer2 Cloud Connector can integrate data and sync documents between 100+ corporate data sources without programming. It is used to connect services and apps on-premises or cloud-based, such as Microsoft Office 365, SharePoint, Dynamics, Azure, SQL/ERP/CRM, and more for migration, backup, or per…
QXchange is data integration software. It aims to quickly and easily transfer data between many standard data formats and applications, including MS Access, Excel, Comma delimited flat file, MS SQL Server, MySQL, QuickBooks, and others.
A high-performance, lean and robust integration framework + runtime (ESB) Intuitive drag-n-drop graphical integration workflowsSimple, annotation- and markup-driven configuration modelComplete with monitoring, analytics, clustering/HAMultiple deployment options: in-house / cloud (AWS EC2, Google Cl…
Integration Platform
Containerized orchestration middleware for full-stack management of small-to-large-scale UltraESB-driven integration solution deployments! Leverage the awesome scalability of Kubernetes and other orchestration platforms to host sophisticated integrationsCut down traditional budgets on VM licensing, …
Impetus Data Blending
Impetus headquartered in Los Gatos offers Data Blending, the company's data integration application for integrating data from disparate sources. The application supports rich analytics with diverse multi-structured data sets, data quality checking, and building large diverse datasets.
Lore IO
Lore IO is a collaborative data unification platform that promises to help companies ingest and unify disparate data sets from hundreds or thousands of sources. It generates standard outputs without the need for engineers to develop procedural ETL and data pipelines. The vendor aims to empower busin…
Altimetrik Altishell
Altimetrik headquartered in Southfield offers Altishell, an integration tool.
Bitwise offers Hydrograph, a data integration tool with provides ETL functionality on Hadoop and Spark.
Bitwise ETL Converter
The Bitwise ETL Converter supports data integration standardization and automates ETL migration from disparate systems.
iFusion Analytics
Innominds company iFusion Analytics offers their data integration as a service offering for managing heterogenous and / or unstructured data sources.
The vendor says they understand the challenges faced by agencies, marketing groups, sales teams, and business of all sizes.With so many CRM platforms to choose from, and many new options coming out every day, the likelihood of you needing to migrate your data from one CRM to another is very high. Th…
Striim is an enterprise-grade platform that offers continuous real-time data ingestion, high-speed in-flight stream processing, and sub-second delivery of data to cloud and on-premises endpoints.