We performed a comparison between Azure Data Factory and Oracle Data Integrator ODI based on our users’ reviews in five categories. After reading all of the collected data, you can find our conclusion below.
Comparison Results: The main difference between the two products is that Azure Data Factory needs better integration capabilities while users of Oracle Data Integrator (ODI) find that the solution integrates well with other systems.
"The two most valuable features of Azure Data Factory are that it's very scalable and that it's also highly reliable."
"The feature I found most helpful in Azure Data Factory is the pipeline feature, including being able to connect to different sources. Azure Data Factory also has built-in security, which is another valuable feature."
"The security of the agent that is installed on-premises is very good."
"The data mapping and the ability to systematically derive data are nice features. It worked really well for the solution we had. It is visual, and it did the transformation as we wanted."
"I like its integration with SQL pools, its ability to work with Databricks, its pipelines, and the serverless architecture are the most effective features."
"The most valuable features are data transformations."
"The overall performance is quite good."
"The most valuable feature of this solution would be ease of use."
"The CAEM is very useful in its modularity and portability."
"Besides loading data, we do most of our transformations in ODI."
"It has the ability to easily load slowly changing dimensions."
"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."
"The most valuable feature is Data movement."
"The tool improved our data integration workflow primarily due to its compatibility with Oracle. Its integration makes it very convenient for analytics. Its most valuable feature is robust extended capability. The solution's debugging capabilities are good."
"All our systems can be widely integrated by ODI, such as transactional systems, our data warehouses, and B2B integration."
"What I found most valuable in Oracle Data Integrator (ODI) is that it integrates well with almost all technologies currently being used in my company."
"The one element of the solution that we have used and could be improved is the user interface."
"Integration of data lineage would be a nice feature in terms of DevOps integration. It would make implementation for a company much easier. I'm not sure if that's already available or not. However, that would be a great feature to add if it isn't already there."
"There is always room to improve. There should be good examples of use that, of course, customers aren't always willing to share. It is Catch-22. It would help the user base if everybody had really good examples of deployments that worked, but when you ask people to put out their good deployments, which also includes me, you usually got, "No, I'm not going to do that." They don't have enough good examples. Microsoft probably just needs to pay one of their partners to build 20 or 30 examples of functional Data Factories and then share them as a user base."
"Sometimes I need to do some coding, and I'd like to avoid that. I'd like no-code integrations."
"It would be better if it had machine learning capabilities."
"Azure Data Factory uses many resources and has issues with parallel workflows."
"The solution needs to integrate more with other providers and should have a closer integration with Oracle BI."
"I would like to be informed about the changes ahead of time, so we are aware of what's coming."
"Oracle Data Integrator (ODI) is already good as a solution. Still, it needs some editing of its preview package, or if the package is upgraded, that will make Oracle Data Integrator (ODI) even better."
"ODI could improve by focusing on streamlining its features without unnecessary overhead."
"In our company, we haven't tried consuming services from IoT in our company yet, and I would like to know if the solution will support IoT services in the next release."
"The resource management aspect of the solution could be improved."
"There are certain things where it can be improved. Initial solution setup seems a bit complex at the start, it should be improved because it becomes bit tough for a novice to get started on this. Sometimes error description is not helpful to understand the problem it gives some generic type of errors which are at times not that helpful to understand the underlying root cause of the issue."
"ODI could improve the ease of use. There is a steep learning curve to use the solution."
"Technical Support could be better."
"Oracle support services are not up to the mark."
Azure Data Factory is ranked 1st in Data Integration with 81 reviews while Oracle Data Integrator (ODI) is ranked 4th in Data Integration with 68 reviews. Azure Data Factory is rated 8.0, while Oracle Data Integrator (ODI) is rated 8.2. The top reviewer of Azure Data Factory writes "The data factory agent is quite good but pricing needs to be more transparent". On the other hand, the top reviewer of Oracle Data Integrator (ODI) writes "Straightforward to implement, scalable, and has good stability and documentation, but technical support could still be improved". Azure Data Factory is most compared with Informatica PowerCenter, Informatica Cloud Data Integration, Alteryx Designer, Snowflake and SAP Data Services, whereas Oracle Data Integrator (ODI) is most compared with Oracle Integration Cloud Service, Informatica PowerCenter, SSIS, Oracle GoldenGate and Talend Open Studio. See our Azure Data Factory vs. Oracle Data Integrator (ODI) report.
See our list of best Data Integration vendors.
We monitor all Data Integration 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.