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 function of the solution is great."
"In terms of my personal experience, it works fine."
"The data copy template is a valuable feature."
"The security of the agent that is installed on-premises is very good."
"The solution is okay."
"It is very modular. It works well. We've used Data Factory and then made calls to libraries outside of Data Factory to do things that it wasn't optimized to do, and it worked really well. It is obviously proprietary in regards to Microsoft created it, but it is pretty easy and direct to bring in outside capabilities into Data Factory."
"On the tool itself, we've never experienced any bugs or glitches. There haven't been crashes. Stability has been good."
"The most valuable aspect is the copy capability."
"It has the ability to easily load slowly changing dimensions."
"ODI significantly improves data integration and management by allowing customization of data types from various sources like SQL Server databases."
"Integration with all systems is easy with Oracle Data Integrator, and it is easy to use. I have not used any other product, but with Oracle Data Integrator, we can easily connect to an ERP system, an SAP system, or a cloud application."
"ODI is a very accessible tool, especially since the mapping functionality has been added."
"The CAEM is very useful in its modularity and portability."
"The Knowledge Module approach provides an easy and reusable way to create our own integration strategies. It's easy to create these Knowledge Modules to connect to new technologies, for instance."
"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 installation of the client ODI Studio is easy."
"Data Factory's performance during heavy data processing isn't great."
"Azure Data Factory should be cheaper to move data to a data center abroad for calamities in case of disasters."
"User-friendliness and user effectiveness are unquestionably important, and it may be a good option here to improve the user experience. However, I believe that more and more sophisticated monitoring would be beneficial."
"DataStage is easier to learn than Data Factory because it's more visual. Data Factory has some drag-and-drop options, but it's not as intuitive as DataStage. It would be better if they added more drag-and-drop features. You can start using DataStage without knowing the code. You don't need to learn how the code works before using the solution."
"Data Factory could be improved by eliminating the need for a physical data area. We have to extract data using Data Factory, then create a staging database for it with Azure SQL, which is very, very expensive. Another improvement would be lowering the licensing cost."
"The number of standard adaptors could be extended further."
"In the next release, it's important that some sort of scheduler for running tasks is added."
"It would be better if it had machine learning capabilities."
"The resource management aspect of the solution could be improved."
"Stability could be improved because some operators have issues."
"It has been very good. Just recently, I've faced an issue, but I solved it somehow. While integrating with a file, I faced an issue where I wanted output files, and I had used the text field limited quotations, but at the end of the file, there was a line breakage for the last column. So, we just removed the text field because it was not working correctly for us."
"The solution lacks some functions and features."
"It would be really good if Oracle considered enabling the tool to integrate with some other platforms that are deprecated simply for commercial reasons"
"ODI could improve by being more user-friendly. Informatica, which is also an ETL tool, similar to ODI, but Informatica is very user-friendly, easy to use, and simple to integrate, compared to ODI. ODI has many features, put them all together, and sometimes we get confused about which ones to use, which ones not to use."
"ODI could improve the ease of use. There is a steep learning curve to use the solution."
"If you have something like Cisco on top of it, you will have endless problems."
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.