The 28 Best Data Integration Tools and Software for 2020

1

Adeptia

Description: Adeptia offers enterprise data integration tools that can be used by non-technical business users. Adeptia Connect features a simple user interface to manage all external connections and data interfaces. It also includes self-service partner onboarding and a no-code approach that lets users and partners view, setup and manage data connections. The platform touts a suite of pre-built connections and Cloud Services Integration, as well as B2B standards and protocol support.

#Data Integration #Integration #Customer Data Integration

2

alooma

Description: Alooma offers a data pipeline service that integrates with popular data sources. The Alooma platform features end-to-end security, which ensures that every event is securely transferred to a data warehouse (SOC2, HIPAA, and EU-US Privacy Shield certified). The solution responds to data changes in real-time to make sure no events are lost. Users can choose to manage changes automatically or get notified and make changes on-demand. The tool also infers data automatically to provide customizable control.

#Business & Commerce #Backup & Sync #Office & Productivity

3

Boomi

Description: Boomi is a Dell Technologies company. Boomi’s flagship product, AtomShere, supports integration processes between cloud platforms, software-as-a-service applications, and on-prem systems. AtomSphere uses a visual interface to configure application integrations. The solution’s runtime tool, Boomi Atom, allows integrations to be deployed wherever they are needed. The AtomSphere platform is available in several editions, based on use case and functionality.

#Data Integration #API Tools #Web Service Automation 9 social mentions

4

Celigo

Description: Celigo offers an Integration Platform as a Service product called Integrator.io. The solution enables organizations to connect applications, synchronize data, and automate processes. Celigo features an integration wizard that includes an API assistant, visual field mapping interface, and drop-down menus. The tool also offers reusable pre-configured integration templates available on the integrator.io marketplace, allowing users to create their own library of reusable, standalone flows.

#Web Service Automation #API Tools #Data Integration 3 social mentions

5

Cleo Integration Cloud

Description: The Cleo Integration Cloud allows organizations to connect to enterprise and SaaS applications with a variety of connectors and APIs. The tool automatically accepts, transforms, orchestrates, connects and integrates all B2B data types from any source and to any target, and can be deployed via several different methods. Cleo Integration Cloud can also be embedded for SaaS or Information Services organizations and can be utilized as a managed service to offload complex integrations to the vendor’s experts.

#Data Integration #Web Service Automation #API Tools

6

Denodo

Description: The Denodo Platform offers data virtualization for joining multistructured data sources from database management systems, documents, and a wide variety of other big data, cloud, and enterprise sources. Connectivity support includes relational databases, legacy data, flat files, CML, packed applications, and emerging data types including Hadoop. Denodo is the only data virtualization solution to be provisioned as a virtual image on Amazon AWS Marketplace.

#Data Integration #Data Dashboard #AI Platform

7

Diyotta

Description: Diyotta is a unified data integration platform that integrates with modern data lake and data warehousing environments. The drag-and-drop user interface and native processing capabilities make this product one to consider. Diyotta enables shorter development times, faster data movement, and reusability across the enterprise to make future development simple. Diyotta touts the industry’s first data integration software to leverage modern data processing platforms like Hadoop, Snowflake, Google BigQuery, and Amazon Redshift.

#Backup & Sync #Development #Business & Commerce

8

Fivetran

Description: Fivetran is an automated data integration platform that delivers ready-to-use connectors, transformations and analytics templates that adapt as schemas and APIs change. The product can sync data from cloud applications, databases, and event logs. Integrations are built for analysts who need data centralized but don’t want to spend time maintaining their own pipelines or ETL systems. Fivetran is easy to deploy, scalable, and offers some of the best security features of any provider in the space.

#Data Integration #ETL #Data Replication 12 social mentions

9

Pentaho

Description: Hitachi Vantara’s Pentaho platform for data integration and analytics offers traditional capabilities and big data connectivity. The solution supports the latest Hadoop distributions from Cloudera, Hortonworks, MapR, and Amazon Web Services. However, one of the tool’s shortcomings is that its big data focus takes attention away from other use cases. Pentaho can be deployed on-prem, in the cloud, or via a hybrid model. The tool’s most recent update to version 8 features Spark and Kafka stream processing improvements and security add-ons.

#Data Integration #ETL #Business Intelligence

10

HVR

Description: HVR offers a variety of data integration capabilities, including cloud, data lake, and real-time integration, database and file replication, and database migration. The product allows organizations to move data bi-directionally between on-prem solutions and the cloud. Real-time data movement continuously analyzes changes in data generated by transactional systems, machines, sensors, mobile devices, and websites. The company has raised funding recently to expand its footprint in hybrid integration scenarios.

#Monitoring Tools #Web Service Automation #MySQL Tools

11

InfoSphere

#Data Integration #Product Information Management #Digital Asset Management

12

Informatica Intelligent Data Platform

#Data Integration #AI Platform #Data Management Platform (DMP)

13

Jitterbit

Description: Jitterbit offers cloud data integration and API transformation capabilities. The company’s main product, Jitterbit Harmony, allows organizations to design, deploy, and manage the entire integration lifecycle. The platform features a graphical interface for guided drag-and-drop configuration, integration via pre-built templates, and the ability to infuse applications with artificial intelligence. Users can run the tool in cloud, hybrid, or on-prem environments, and feed consolidated data to real-time analytics.

#Web Service Automation #Data Integration #API Tools

14

Keboola

Description: Keboola is a cloud-based data integration platform that connects data sources to analytics platforms. It supports the entire data workflow process, from the point of data extraction, preparation, cleansing, warehousing, and all the way to its integration, enrichment, and loading. Keboola offers more than 200 integrations and features an environment that allows users to build their own data applications or integrations using GitHub and Docker. The product can also automate low-value activities while account for audit trail, version control and access management.

#Data Integration #ETL #Data Extraction 2 social mentions

15

Matillion

Description: Matillion offers data integration software for cloud data warehouses, and was designed for Amazon Redshift, Snowflake, and Google BigQuery. The product works by allowing users to consolidate large data sets and quickly perform data transformations. It features expert technical support as well, all by Matillion solution architects and comes free of charge. Full support is offered throughout the customer lifecycle, including trial and complex use case development. Matillion includes more than 70 pre-built connectors.

#Data Integration #ETL #Monitoring Tools 1 social mentions

16

SQL Server Integration Services

#Data Integration #ETL #Monitoring Tools

17

MuleSoft Anypoint Platform

#Integrations Platform As A Service #Web Service Automation #Data Integration

18

Oracle Cloud Integration

#Data Integration #Web Service Automation #API Tools

19

Qlik

Description: The Qlik product suite features a range of data integration capabilities that span four distinct product lines. The flagship product is Qlik Replicate, a tool that replicates, synchronizes, distributes, consolidates, and ingests data across all major databases, data warehouses, and Hadoop. The portfolio of products is buoyed by Qlik Compose and Qlik Visibility. The provider also offers Qlik CloudBeam, an Integration Platform as a Service tool, which provides cloud-optimized data replication from all major on-prem sources to Amazon Web Services, Microsoft Azure, and Google Cloud.

#Data Analytics #Data Integration #Data Dashboard 1 social mentions

20

SAP Data Services

Description: SAP provides on-prem and cloud integration functionality through two main channels. Traditional capabilities are offered through SAP Data Services, a data management platform that provides capabilities for data integration, quality, and cleansing. Integration Platform as a Service features are available through the SAP Cloud Platform. SAP’s Cloud Platform integrates processes and data between cloud apps, 3rd party applications, and on-prem solutions.

#Backup & Sync #Development #Business & Commerce

21

SAS Data Management

Description: SAS is the largest independent vendor in the data integration tools market. The provider offers its core capabilities via SAS Data Management, where data integration and quality tools are interwoven. It includes flexible query language support, metadata integration, push-down database processing, and various optimization and performance capabilities. The company’s data virtualization tool, Federation Server, enables advanced data masking and encryption that allows users to determine who’s authorized to view data.

#Business & Commerce #Product Information Management #Monitoring Tools

22

snaplogic

Description: SnapLogic’s Intelligent Integration Platform integrates across applications, databases, data warehouses, big data streams, and IoT deployments. It allows both IT and business users to create data pipelines that can be deployed on-prem or in the cloud. It features an HTML5 visual designer and a proprietary AI algorithm called Iris that learns common integration patterns and drives self-service by recommending flows. Complete support for complex transformations, conditional operations, triggers, parameterization, aggregation, and reuse maximizes the tool’s flexibility.

#Web Service Automation #Data Integration #API Tools

23

Striim

Description: Striim offers a real-time data integration solution that enables continuous query processing and streaming analytics. Striim integrates data from a wide variety of sources, including transaction/change data, events, log files, application and IoT sensor, and real-time correlation across multiple streams. The platform features pre-built data pipelines, out-of-the-box wizards for configuration and coding, and a drag-and-drop dashboard builder.

#Backup & Sync #Development #Business & Commerce

24

precisely Connect

Description: Syncsort offers its data integration capabilities via two product families, Syncsort Connect and Syncsort Ironstream. The company’s flagship application data integration tools are the Syncsort Connect product family. Syncsort allows users to hasten database queries and applications by putting relational databases to best use. The Intelligent Execution feature dynamically selects the most efficient algorithms based on the data structures and system attributes it encounters at run-time.

#Data Integration #Data Management #Cloud Data Services

25

Talend Open Studio

#Data Integration #Sales Tools #OS & Utilities

26

Tamr

Description: Tamr offers a machine learning-based data integration product called Unify. The solution allows organizations to connect to any tabular data and publish it anywhere. Users can map schemas with machine learning suggestions and normalize data formats using Spark and SQL. Tamr’s Master Records feature provides a complete view of all entities via simple yes and no questions as well. Tamr has also begun offering an issue tracker specifically designed for data called Steward (beta).

#Office & Productivity #Business & Commerce #Tool

27

TIBCO Cloud Integration

Description: TIBCO’s flagship Integration Platform as a Service product, TIBCO Cloud Integration, requires no code. It also allows users to create, model, and deploy APIs in a completely guided process. TIBCO acquired Scribe Software in June 2018 and has rolled its capabilities into TIBCO Cloud Integration as a complimentary package. TIBCO offers a fully integrated data platform that can handle a variety of data integration use cases. The company’s acquisition of Cisco’s data virtualization technologies rounds out its product portfolio even further.

#Web Service Automation #Data Integration #API Tools

28

TMM Data

#Data Integration #ETL #Monitoring Tools