Compare Azure Data Factory vs. Oracle Data Integrator (ODI)

Azure Data Factory is ranked 6th in Data Integration Tools with 10 reviews while Oracle Data Integrator (ODI) is ranked 7th in Data Integration Tools with 9 reviews. Azure Data Factory is rated 8.2, while Oracle Data Integrator (ODI) is rated 8.2. The top reviewer of Azure Data Factory writes "Straightforward and scalable but could be more intuitive". On the other hand, the top reviewer of Oracle Data Integrator (ODI) writes "We can make all the EPM tools work together as one and we can create a puzzle that will increase the performance and capability of all EPM tools". Azure Data Factory is most compared with Talend Open Studio, Informatica PowerCenter and Informatica Enterprise Data Catalog, whereas Oracle Data Integrator (ODI) is most compared with Informatica PowerCenter, SSIS and Oracle Integration Cloud Service. See our Azure Data Factory vs. Oracle Data Integrator (ODI) report.
Cancel
You must select at least 2 products to compare!
Most Helpful Review
Find out what your peers are saying about Azure Data Factory vs. Oracle Data Integrator (ODI) and other solutions. Updated: March 2020.
407,096 professionals have used our research since 2012.
Quotes From Members

We asked business professionals to review the solutions they use. Here are some excerpts of what they said:

Pros
It is easy to deploy workflows and schedule jobs.From my experience so far, the best feature is the ability to copy data to any environment. We have 100 connects and we can connect them to the system and copy the data from its respective system to any environment. That is the best feature.It is a complete ETL Solution.Powerful but easy-to-use and intuitive.The most valuable features are data transformations.Data Factory itself is great. It's pretty straightforward. You can easily add sources, join and lookup information, etc. The ease of use is pretty good.From what we have seen so far, the solution seems very stable.The user interface is very good. It makes me feel very comfortable when I am using the tool.

Read more »

The most valuable feature that we use is the Knowledge Modules.It's completely user-friendly.​All our systems can be widely integrated by ODI, such as transactional systems, our data warehouses, and B2B integration.It has the ability to easily load slowly changing dimensions.​The installation of the client ODI Studio is easy.​Besides loading data, we do most of our transformations in ODI.In our DW/BI solution, ODI is the main tool to integrate the data in a daily batch way.Most of the functions are very straightforward, like the data model, mapping, package, and load plan. Thus, a new user could get started very fast.

Read more »

Cons
The setup and configuration process could be simplified.The user interface could use improvement. It's not a major issue but it's something that can be improved.The Microsoft documentation is too complicated.The product could provide more ways to import and export data.The speed and performance need to be improved.On the UI side, they could make it a little more intuitive in terms of how to add the radius components. Somebody who has been working with tools like Informatica or DataStage gets very used to how the UI looks and feels.The solution needs to integrate more with other providers and should have a closer integration with Oracle BI.The solution should offer better integration with Azure machine learning. We should be able to embed the cognitive services from Microsoft, for example as a web API. It should allow us to embed Azure machine learning in a more user-friendly way.

Read more »

The performance of the user interface is in need of improvement.Overall the product is fine, but sometimes its reports unknown errors while we compile ETL scripts.It would be really good if Oracle considered enabling the tool to integrate with some other platforms that are deprecated simply for commercial reasonsIt lacks a suite of tools suitable for fully processing data and moving it into decision support warehouses.​The stability of the software could be improved. Sometimes, the software just crashes. ​

Read more »

Pricing and Cost Advice
This is a cost-effective solution.Our licensing fees are approximately 15,000 ($150 USD) per month.In terms of licensing costs, we pay somewhere around S14,000 USD per month. There are some additional costs. For example, we would have to subscribe to some additional computing and for elasticity, but they are minimal.

Read more »

We found that the cost compared to other integration tools is a little high, but the solution works great.

Read more »

report
Use our free recommendation engine to learn which Data Integration Tools solutions are best for your needs.
407,096 professionals have used our research since 2012.
Ranking
6th
Views
8,394
Comparisons
6,600
Reviews
10
Average Words per Review
456
Avg. Rating
8.1
7th
Views
20,434
Comparisons
13,323
Reviews
9
Average Words per Review
356
Avg. Rating
8.1
Top Comparisons
Compared 16% of the time.
Also Known As
ODI
Learn
Microsoft
Oracle
Overview

Create, schedule, and manage your data integration at scale with Azure Data Factory - a hybrid data integration (ETL) service. Work with data wherever it lives, in the cloud or on-premises, with enterprise-grade security.

Oracle Data Integrator is a comprehensive data integration platform that covers all data integration requirements: from high-volume, high-performance batch loads, to event-driven, trickle-feed integration processes, to SOA-enabled data services. Oracle Data Integrator (ODI) 12c, the latest version of Oracle’s strategic Data Integration offering, provides superior developer productivity and improved user experience with a redesigned flow-based declarative user interface and deeper integration with Oracle GoldenGate. 

ODI12c further builds on its flexible and high-performance architecture with comprehensive big data support and added parallelism when executing data integration processes.  It includes interoperability with Oracle Warehouse Builder (OWB) for a quick and simple migration for OWB customers to ODI12c.  Additionally, ODI can be monitored from a single solution along with other Oracle technologies and applications through the integration with Oracle Enterprise Manager 12c.

Offer
Learn more about Azure Data Factory
Learn more about Oracle Data Integrator (ODI)
Sample Customers
Milliman, Pier 1 Imports, Rockwell Automation, Ziosk, Real Madrid Griffith University, Kansas City Power & Light, Keste, Raymond James Financial, Valdosta State University
Top Industries
VISITORS READING REVIEWS
Software R&D Company54%
Comms Service Provider9%
Insurance Company4%
Construction Company4%
REVIEWERS
Financial Services Firm30%
University10%
Insurance Company10%
Hospitality Company10%
VISITORS READING REVIEWS
Software R&D Company44%
Comms Service Provider10%
Financial Services Firm7%
Media Company5%
Company Size
REVIEWERS
Small Business19%
Midsize Enterprise25%
Large Enterprise56%
REVIEWERS
Small Business34%
Midsize Enterprise12%
Large Enterprise54%
VISITORS READING REVIEWS
Small Business4%
Midsize Enterprise11%
Large Enterprise85%
Find out what your peers are saying about Azure Data Factory vs. Oracle Data Integrator (ODI) and other solutions. Updated: March 2020.
407,096 professionals have used our research since 2012.
We monitor all Data Integration Tools reviews to prevent fraudulent reviews and keep review quality high. We do not post reviews by company employees or direct competitors. We validate each review for authenticity via cross-reference with LinkedIn, and personal follow-up with the reviewer when necessary.