Data Integration Tools
Top Rated Products
(1-5 of 6)
Centerprise Data Integrator is an integration platform that includes tools for data integration, data transformation, data quality, and data profiling.
TIBCO Integration is used to connect diverse business solutions, data sources, and devices into a single, seamless system.
SAP Data Intelligence is presented by the vendor as a single solution to innovate with data. It provides data-driven innovation in the cloud, on premise, and through BYOL deployments. It is described by the vendor as the new evolution of the company's data orchestration and management…
TIBCO Data Virtualization is an enterprise data virtualization solution that orchestrates access to multiple and varied data sources and delivers the datasets and IT-curated data services foundation for nearly any solution.
All Products
(101-125 of 193)
TerminusHub is for collaborative data integration. Users can share, build and integrate databases with their teams and the wider world. The vendor states user's project can keep data synchronized with TerminusHub and make the latest data accessible to their team no matter where they…
Meroxa is a data streaming platform designed to create a real-time data infrastructure. It aims to automate the heavy lifting of change data capture, monitoring, and data loading.
Users can develop and govern data with Data Lake Governance Center (DGC), a one-stop data lake operations platform from Huawei Cloud. Cloud-based big data storage and compute engines make it easier for users to rapidly grow enterprise's big data operations. DGC helps users build…
Explore recently added products
Innominds company iFusion Analytics offers their data integration as a service offering for managing heterogenous and / or unstructured data sources.
Sesame Software in Santa Clara invites businesses to protect and integrate your valuable corporate data with their flagship Relational Junction suite of Enterprise Application Integration products. Sesame Software provides solutions for over 100 different SaaS applications including…
Digital Transformation requires an IT environment to be agile, flexible and constantly evolving. The only way to successfully achieve Digital Transformation is to implement an orchestration layer to federate the entire environment from a managerial, operational and technical perspective…
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,…
Enterprise Enabler is a data virtualization or data integration platform from Stone Bond Technologies in Houston, Texas.
Datica in Minneapolis (formerly Catalyze, or catalyze.io) offers solutions to developing healthcare applications in the cloud that requires data integration and compliance with complicated rules and controls. Datica boasts a family of single-source solutions to those challenges.
The scalable ibi™ Omni-Gen® Data Integration Framework provides data integration and cleansing technologies that ensure data is timely, accurate, consistent, and accessible. Interoperable Omni-Gen architecture insulates end users from data complexities and ensures delivery of the…
EntelliFusion is a fully-managed cloud or on premise platform for integrating, cleaning, storing & securing semi-structured or structured operational data for centralized analytics and machine learning activities at enterprise scale, a true full-stack capability. It can connect…
GoSaaS Integrator is a lightweight, scalable enterprise integration solution which works with both on premise and cloud applications. The GoSaaS integrator is designed for the synchronization of objects between any two systems. It is a message based integration system that has the…
FinCluez is a single data platform that addresses varied and complex data requirements across business areas, from Profinch, that helps banks to manage critical data effectively. FinCluez enables users to keep pace with changing customer needs and a continuously evolving regulatory…
Octolis is a full-stack data platform for marketing teams. It enables marketers to faster analyze and deploy data-driven use cases. Sitting on top of a database, Octolis provides a way to unify, score and sync actionable data in business tools.
A distributed data integration framework that simplifies common aspects of big data integration such as data ingestion, replication, organization and lifecycle management for both streaming and batch data ecosystems. It is open source and free to use under an Apache 2.0 license.
Etleap, headquartered in San Francisco, aims to simplify and automate ETL. Etleap's data wrangler and modeling tools let users control how data is transformed for analysis, without writing any code.
HighByte is an industrial software company founded in 2018 with headquarters in Portland, Maine USA. The company builds solutions that address the data architecture and integration challenges created by Industry 4.0. HighByte Intelligence Hub, the company’s Industrial DataOps software,…
Fraxses by Intenda is a distributed data platform that provides organisations with a framework on which to build a data fabric or data mesh architecture. While Fraxses fully supports traditional data integration processes, it advances a connect, not collect approach, whereby data…
Gravity is used by analysts, data scientists and data engineers to build no-code data pipelines without relying on IT or DevOps. Sources, destinations and integrations are added from one screen where users can access APIs and streaming sources.
Cloud based ETL platform that helps businesses collect, aggregate, analyze and report on datasets using automated dashboards. Conversionomics can automate and accelerate the data preparation cycle, even if it means combining thousands of sources, dimensions, and metrics, adding…
An iPaaS platform for integration and business process automation. Linx is a platform for building custom integrations at scale. The platform provides enterprise-grade capability and flexibility to cater to a wide range of integration use cases for today’s growing businesses, including…
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…
Qualtrics LTI by Drieam is a plug-in (LTI app) for an integrated LMS. Using Qualtrics LTI, institutional research professionals, department admins, and faculty can embed their Qualtrics surveys inside the LMS, and then actions take place within the trusted environment that the LMS…
Formstack Sync (formerly Bedrock Data) was a bi-directional sync tool from Formstack since the company acquired Bedrock Data in 2019. The product was sunsetted in April of 2022 and is no longer available.
The CloudNine Discovery Portal consists of a downloaded application that is used to upload and integrate data for discovery into one of CloudNine's ediscovery products (LAW, Review, Analyst, etc.). It simplifies data integration processes, provides deduplication, and ensures the…
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.
Learn More About Data Integration Tools
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.
ETL Tools Comparison
When comparing ETL tools and data integration products, consider the following criteria:
Deployment: Many cloud-based and SaaS products are available. Cloud-based deployment can be simpler and leaner, especially for teams with limited IT infra structure. However, you’ll sacrifice some level of control and customization. An on-premise solution gives you more control, but at the price of more infrastructure and support staff. If you handle sensitive data, you’ll also need to make sure that your cloud provider has appropriate compliance and encryption.
Open-Source vs Proprietary: Open-source data integration tools are reliable, time-tested alternatives to proprietary software. They’re often cheaper, too. However, open-source tools aren’t great for new users or engineers that need a polished, UX-focused workflow. They’re best for experienced users that are prepared to fully engage with the software’s customization and integration capabilities.
Existing Ecosystem: ETL and data integration tools are designed to be flexible, but it’s almost universally simpler to pick a tool that’s designed with your existing tech stack in mind. Start by evaluating these products, and expand your search only if they don’t meet core needs.
Use Case: If you’re just starting out, don’t pick a comprehensive platform. Start small, and grow later. If you know you’re planning to scale up, look for ETL tools that fit easily into larger pipelines.
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.
Related Categories
Frequently Asked Questions
What businesses benefit most from data integration tools?
What are the best Data Integration Tools?
The top rated data integration tools are as follows: