2014-12-09 11:39:00 UTC

When evaluating Data Integration, what aspect do you think is the most important to look for?

Let the community know what you think. Share your opinions now!
1616 Answers

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

2019-09-13 02:33:45 UTC13 September 19

- 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.

2018-11-05 11:47:30 UTC05 November 18
Real UserTOP 5

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?

2018-06-12 08:09:10 UTC12 June 18

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

2017-03-06 21:16:12 UTC06 March 17
Real User

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

2015-07-31 08:41:01 UTC31 July 15
Real User

Less code more productivity

2015-04-27 10:49:39 UTC27 April 15
Real User

Data Quality, Data governance, Data profiling, and advanced ETL functions embedded, multiples and native connectivity with structured and unstructured data.

2015-04-07 23:14:04 UTC07 April 15

1. Flexibility. A DI tool should be like water to fit the shape of each glass every time. Ability to learn.!
2. Ease of development, installation, implementing topology architecture.
3. Reusability of coding.
4. Ease of maintenance, management and operation.
5. Learning curve.
6. Ability to talk with related products (Data Quality, Replication, etc.) fully integrated and out-of-the-box.

2016-10-26 09:21:29 UTC26 October 16

When evaluating data integration, think about versioning and auditability. Other ETL/ELT tools preach it, however ODI lives and breaths it. Also look at reusability. 12c especially has lots of cool reusable parts that will make development easy and quick. Security should also be at the top of the list. Can you lock someone down to a single job or even a portion of that job? ODI you can. Are you looking for a data warehouse tool of just something to copy a file from one place to another? Even though ODI can do both I would say that you would be killing a fly with an atom bomb if you just need to shuffle files around. Think about what you need to hook into now and in the future. ODI you can create custom connections, so even if you forgot about something most likely you can connect to it. I have even hooked it to iTunes reports.

2016-04-28 13:48:06 UTC28 April 16

Ease of data extract, Ability to support complex Integration between desperate systems, Ability to feed data to different downstream systems, Ability to perform data quality check and Availability of ETL out of box functions..

2016-04-11 20:19:19 UTC11 April 16
Real UserTOP 10

Ease of use (modeling), flexible options for transformations and custom code, data source agnostic, efficient processing engine, real time monitoring and solid debug tools, good reuse options (refactoring segments of a process to new projects or flows, etc.) good but flexible governance and good documentation (or strong Google search results).

2015-09-30 18:31:26 UTC30 September 15

Data quality, data governance, possibility for advance data transformations in a much more easier manner

2015-08-31 08:20:01 UTC31 August 15
Real User

Data Quality, Governance, Data profiling, Flexibility and ease of use

2015-07-29 06:54:49 UTC29 July 15
ConsultantTOP 5

Reusability, Flexibility, Data Governance, Data Quality, Connectivity

2015-07-23 12:31:39 UTC23 July 15
Real User

Easy to use, Easy to manage

2015-03-10 10:29:09 UTC10 March 15
Real UserTOP 20

Data Quality, Data Volume, Frequency Of Update (Schedule) and Cross Object communication In an overview.

There could other factors as well but primarily I will go to evaluate this.

2014-12-22 07:29:13 UTC22 December 14
Find out what your peers are saying about Microsoft, Informatica, Oracle and others in Data Integration Tools. Updated: August 2019.
365,820 professionals have used our research since 2012.
Sign Up with Email