the Information Builders' iWay DataMigrator is a data integration toolset.
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.
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.
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 (51-75 of 99)
Invantive is a solution provider for real estate developers and project driven companies. Based upon ten successful years of experience with project development and project management, the company says they can help their customers improve projects through their extendible but cost-effective soft...
Part of IBM's InfoSphere Data Replication offerings, InfoSphere Replication Server is a data integration solution.
SAS Federation Server is a data integration service.
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.
Bedrock Data is the eponymous data integration platform from the Boston-based company.
UNIFI, from the company Unifi Software in San Mateo, California, is a data integration platform.
Astera Software provides high-performance, complex data conversion and migration software.
Devart was founded in 1997 and is a leading developer of database tools, administration software, and ALM solutions. The vendor is also a data provider for various data servers, data integration and backup solutions. Devart’s customer base includes both Fortune 100 and Fortune 500 companies as ...
Enterprise Enabler is a data virtualization or data integration platform from Stone Bond Technologies in Houston, Texas.
Unit4 Consolidation integrates data from multiple sources across a fragmented IT structure providing a single-source of truth for analysis, compliance, and oversight.
RedPoint Data Management & Quality handles the core requirements of data management including data quality, with data-profiling and general-purpose data-cleansing functionality, including parsing, standardization, matching and cleansing. The platform functions across NoSQL, Hadoop, and tradit...
Clear Analytics provides business intelligence solutions. The company's stated mission is data access to all. According to the the company, their products help organizations acquire access to data with as little friction as possible.
Infor Cloverleaf Integration Suite is a data integration platform and suite of applications from ERP vendor Infor, optimized for healthcare organizations and their systems.
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 cr...
1EDISource is an EDI software product designed to help organizations transform B2B operations.
Cozyroc is a set of components for developing ETL solutions with Microsoft SQL Server Integration Services (SSIS).
ZappySys SSIS PowerPack is a collection of drag and drop connectors/tasks for SSIS.
Progress Software offers DataDirect, a data connectivity solution which helps enterprises integrate data across relational, big data and cloud databases.
Syncfusion provides enterprise development solutions. The company has over 12,000 customers, including large financial institutions, Fortune 100 companies, and global IT consultancies. Founded in 2001, Syncfusion is headquartered in Research Triangle Park, NC.
Omatic Software is focused on extending, automating, and integrating Blackbaud software. The company’s stated goal is to help nonprofits better utilize resources by providing innovative tools to eliminate tiresome and manual processes, while creating automated and efficient workflows resulting in...
VL Virtual Logistics provides agile point to multi-channel data integration solutions.