Advice From The Community

Read answers to top Data Integration Tools questions. 430,745 professionals have gotten help from our community of experts.
Ariel Lindenfeld
Let the community know what you think. Share your opinions now!
author avatarreviewer1232958 (User)
User

Ease of modelling and deployment, connectors availability out of the box,,workflow automation,ETL capability,audit and control, transaction and batch processing, continuous Synch,low code,visual interface.

author avatarPhil Wilkins (Capgemini)
Consultant

I would be looking for things like:
- types of connections supported
- data transformation capabilities
- throughput
- can it support micro batching
- can a process be triggered by a data source
- security
- how does it work in a Hybrid scenario (assuming the organization isn't cloud-born)
- licensing and support costs (even open source has support implications - even if it's being patched by your own devs)
- expertise in the product, and product roadmap/life -- if it's difficult to get expertise in using a product or at least support until your own team is competent a problem can incur a lot of delays. If a product is approaching end of life - then skills with the product will disappear, you'll eventually need to change your solution

author avatarRamesh Vanteru (Larsen & Toubro Infotech Ltd.)
Consultant

Ease of use for ETL
Advanced ETL features for flexibility
Easy to test/debug
Reusable
Templates/Pre-built functionalities

author avatarNida Fatima (Astera)
Vendor

- Ease of use - The solution should offer the same level of usability to both IT and business users.
- Support for both batch and transaction-based integration
- Workflow automation - I would not want to spend my time scheduling and monitoring recurring jobs. Therefore, there should be support for time-based and event-based scheduling.
- Connectivity - Any business today works with a plethora of legacy and modern data sources. So the solution should offer out-of-the-box connectivity to a range of source and target databases.

author avatarKieran Connolly
Real User

Flexibility - can you code complex business domain rules using VB or C++?
Connections - what data sources it connects with and how it connects to them.
Stability - will it crash in development mode?
Reuse - can you create and re-use modules in multiple projects and deploy to server tasks?

author avatarit_user621570 (Director of Human Resources with 1,001-5,000 employees)
Vendor

Ease of use for ETL
Advanced ETL features for flexibility
Easy to test/debug
Reusable
Templates/Pre-built functionalities

author avatarit_user252576 (Business Intelligence and Decision Support Team Leader at a university with 1,001-5,000 employees)
Vendor

Data profiling, easy to use, connectivity capabilities to different kind of sources (unstructured data, flat files, common rdms, soap and json ) advanced data transform capabilties

See more Data Integration Tools questions »

What is Data Integration Tools?

According to IT Central Station users, data integration is all about data and governance quality. Our members want to be able to transform, organize, review, and find all sorts of data (including unstructured data, flat files, etc.) quickly and easily. Data integration tools should be customizable with efficient processing, source agnostics, real-time monitoring and debugging, and provide good documentation. Reusability and connectivity were also ranked as important factors.

Find out what your peers are saying about Microsoft, Informatica, Talend and others in Data Integration Tools. Updated: July 2020.
430,745 professionals have used our research since 2012.