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 most valuable feature is the copy activity."
"The solution can scale very easily."
"We have found the bulk load feature very valuable."
"Powerful but easy-to-use and intuitive."
"The most valuable feature of Azure Data Factory is the core features that help you through the whole Azure pipeline or value chain."
"An excellent tool for pipeline orchestration."
"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."
"Oracle provides great documentation."
"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."
"The most valuable feature of ODI is the to use of the whole ETL to create a data lake."
"I do not have to maintain a separate ETL instance. I can change the SQL when something is not performing correctly."
"It's scalable."
"The scalability is great. It's one of the reasons we chose the solution."
"The installation of the client ODI Studio is easy."
"ODI is a very accessible tool, especially since the mapping functionality has been added."
"For some of the data, there were some issues with data mapping. Some of the error messages were a little bit foggy. There could be more of a quick start guide or some inline examples. The documentation could be better."
"There's space for improvement in the development process of the data pipelines."
"There's no Oracle connector if you want to do transformation using data flow activity, so Azure Data Factory needs more connectors for data flow transformation."
"I would like to be informed about the changes ahead of time, so we are aware of what's coming."
"Data Factory's monitorability could be better."
"Azure Data Factory could benefit from improvements in its monitoring capabilities to provide a more robust feature set. Enhancing the ease of deployment to higher environments within Azure DevOps would be beneficial, as the current process often requires extensive scripting and pipeline development. It is also known for the flexibility of the data flow feature, particularly in supporting more dynamic data-driven architectures. These enhancements would contribute to a more seamless and efficient workflow within GitLab."
"There are limitations when processing more than one GD file."
"The product's technical support has certain shortcomings, making it an area where improvements are required."
"If you have something like Cisco on top of it, you will have endless problems."
"Oracle support services are not up to the mark."
"I rate it a seven out of 10 because there is room for growth because ODI is still new, in comparison to Informatica, which is a mature product."
"Technical Support could be better."
"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."
"An area for improvement would be the lack of SQL compatibility - ODI has no ability to interact with SQL unstructured types and data types."
"The initial setup is a bit complex compared to other tools."
"The resource management aspect of the solution could be improved."
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.