15种数据集成工具2018

转自： https://www.guru99.com/data-integration-tools.html

Data integration is the process of combining data from many different sources. It is used for analysis, business intelligence, reporting. Here, are some top data integration tools with key features and download links.

1) CloverETL:

Clover is an open source tool for generating code coverage reports. It provides a blend of rapid visual design of transformations with coding customization.

Features:

• Very easy to use because of on-the-fly byte code
• Batch Inbound and outbound processing for a bulk extract of data
• Full coverage and metrics for latest test run
• Inline annotation helps to highlight statement-level coverage visually
• Test optimization feature makes it painless to test suite before every check-in
• Visual solution to automate data pipelines

Download link: http://www.cloveretl.com/

2) Syncsort:

Syncsort is popular Data integration Solution. It includes a library of used cases with common cases like joins, hash aggregations, weblogs, and processing.

Features:

Build Once, Reuse multiple times
Allows to scale-in & Scale-out
Achieve or exceed service level agreements
Collect, process and integrate data from untapped sources
It allows development without Constraints
Free-up database capacity & accelerate user query performance
Eliminate the requirement for constant coding and tuning
Reduce the cost structure of data integration
Download link: https://www.syncsort.com/en/Solutions/Hadoop-Solutions

3) QlikView:

Qlik is a data Integration tool. It allows creating visualizations, dashboards, and apps. It also allows seeing the entire story that lives within data.

Features:

Simple drag-and-drop interfaces to create flexible, interactive data visualizations
Use natural search to navigate complex information
Instantly respond to interactions and changes
Supports multiple data sources and file types
It allows easy security for data and content across all devices
It shares relevant analyses, including apps and stories using centralized hub
Download link: http://www.qlik.com/us/

4) Centerprise:

Centerprise by Astera is a complete data integration solution. It includes data integration, data transformation, data quality, and data profiling.

Features:

It helps to made Integration easy
It provides a robust, scalable, high-performance, and affordable integration.
Job Flow, Scheduling, and Execution
Data Quality and Profiling
Forward and backward append:
Performance and Scalability
It offers extensibility and Openness
Download link: http://info.astera.com/Centerprise-Activity_Trial-Download-Landing-Page.html

5) Actian:

Actian DataConnect is a hybrid data integration solution. It can quickly design, deploy, and manage data integrations on premise, or in the cloud.

Features:

Connect to on-premise and cloud sources using hundreds of pre-built connectors
Easy-to-use and standardized approach to RESTful web service APIs
Scale quickly and complete integrations by creating reusable templates using the IDE framework
Helps to design robust high-performance with the help of interactive feedback
Work directly with metadata using this tool for power users
It offers flexible deployment Options
Download link: https://www.actian.com/data-integration/dataconnect-integration/

6) Adeptia Connect:

Adeptia Connect is an enterprise-class integration platform. It allows the user to perform data mapping, data transformation, and data integration.

Features:

It provides simple user interface to manages external connections and data interfaces
It offers capability for users to create connections without help of IT professionals
It radically simplifies and reduces the expenses associated with managing the network
It provides flexible and Agile Business
Provide support for efficient Services Delivery
Download link: https://adeptia.com/products/Adeptia-Connect-IPaaS

7) Talend

Talend offers robust enterprise data integration software. It’s open & scalable architecture helps respond faster to business requests. It provides many unified tools to develop and deploy data integration job.

Features:

Talend offers big data and cloud capabilities to simplify adoption of the latest innovations
Repurpose big data integrations to any cloud platform AWS, Microsoft Azure, Google
Leverage Spark in the cloud for the processing needed by machine learning
Download link: https://www.talend.com/download/

8) Information builders:

Information builders is a data integration tool. It simplifies big data management using modern, native approach to Hadoop-based data integration. iWay Big Data Integrator integrates both traditional data and big data.

Features:

It also ensures high levels of capability, compatibility, and flexibility
Information Builders provides a wide array of data application and B2B integration tools
Native Hadoop performance and resource negotiation
Support for a wide variety of big data integration
Streaming sources in batch and real-time via Spark and Hadoop
Improved security and encryption, with effective, process management
Download link: http://www.informationbuilders.com/

9) HVR:

HVR is a data integration tool. It allow users to replicate large volumes of data in real-time between data sources and targets. It also processes high volumes of data with minimal impact on database performance.

Features:

Helps to reduce latency
Most comprehensive solution for Common Cloud Data Integration Scenarios
Real-time and accurate reporting Enablement
Accelerate data movement
Ensure data is updated in real-time
It provides support for all of the real-time cloud data integration scenarios with a single set-up
Download link: https://www.hvr-software.com/free-trial/

10) Attunity:

Attunity Connect is an easy-to-use data integration solution. It provides fast, easy, cost-effective data access and availability. It allows real-time, seamless connectivity for a relational and non-relational data sources.

Features:

Access a wide range of enterprise data sources
Gain universal and service-oriented integration
Attunity has industry leading mainframe integration
Easy Integration with web applications
Data-driven business event detection
Simplify and accelerate integration using comprehensive software suite for VSAM, IMS/DB, and DB2 data
Download link: https://www.attunity.com/

11) Boomi:

The Boomi AtomSphere is a data integration platform as a service (iPaaS). It supports many application integration processes. It offers many powerful integration and data management capabilities.

Features:

It uses a visual interface to configure application integrations
It takes care of the complexity that would typically require significant developer resources
Application, data, and B2B integration
Design integration processes
Automate complex integrations
Lightweight, dynamic run-time engine
Automatic integration updates
Activity monitoring and event tracking
Real-time automatic updates
Download link: https://boomi.com/

12) Snaplogic

SnapLogic is a useful data integration tool. It allows enterprise IT departments and other lines of business to connect faster. It helps to accelerate the adoption of cloud apps like Workday, Salesforce, and ServiceNow.

Features:

Modern Application & Data Integration Services
It can securely transfer data from one location to another.
Provides a tool to set up integrations using visual interface without coding
It offers tools to manage the flow of data throughout its life cycle from creation and initial storage to deletion
It provides integration to BigData sources such as Hadoop and other NoSQL sources
Supports event or transaction based integrations that react to changes in real-time
Supports wide variety of connectors across SaaS, Enterprise, Big Data, Mainframe, Files
Download Link- https://www.snaplogic.com/

13) Alooma:

Alooma is a data integration platform. It enables real-time data processing, analytics, and business intelligence. It extracts, streams, transform and connect all data, error-free, in the cloud.

Features:

Bring data together with native and custom integrations, zero latency, and enterprise scalability
Create mashups to analyze transactional or user data with any other data source
Combine data storage silos into one location regardless if they are in the cloud or on-premise
Easily helps to capture all Interactions
Download link: https://www.alooma.com/

14) Liaison:

Liaison platform provides all types of integration. It is a fully managed service which supports data integration and management operations.

Features:

Easy integration and data management operations
Self-Service Analytics
Helps organization to improve efficiency and gain a competitive advantage
Built-In Compliance & Security
Integrates, transforms and transmits data between any two application end points
Allows to use complex pre- and post-processing rules for data cleansing and enrichment
Helps enterprises connect number of cloud applications and data sources
Help organization to monitor activities like data flow, integration status, and payload profile
Provides launching point to view and report on the data model
Integrates seamlessly with other third-party reporting tools
Download link: https://www.liaison.com/

15) Informatica

Informatica Data Integration offers the capability to connect & fetch data from different sources.

Features:

The tool has a centralized error logging system. It facilitates logging errors and rejecting data into relational tables
Built-in Intelligence to improve performance
Offers better designs with enforced best practices on code development
Code integration with other external Software Configuration tools
Synchronization among geographically distributed team members
Download link: https://www.informatica.com/products/data-integration.html