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.
"It's cloud-based, allowing multiple users to easily access the solution from the office or remote locations. I like that we can set up the security protocols for IP addresses, like allow lists. It's a pretty user-friendly product as well. The interface and build environment where you create pipelines are easy to use. It's straightforward to manage the digital transformation pipelines we build."
"The function of the solution is great."
"An excellent tool for pipeline orchestration."
"The tool's most valuable features are its connectors. It has many out-of-the-box connectors. We use ADF for ETL processes. Our main use case involves integrating data from various databases, processing it, and loading it into the target database. ADF plays a crucial role in orchestrating these ETL workflows."
"The most valuable feature of Azure Data Factory is the core features that help you through the whole Azure pipeline or value chain."
"The flexibility that Azure Data Factory offers is great."
"I like that it's a monolithic data platform. This is why we propose these solutions."
"On the tool itself, we've never experienced any bugs or glitches. There haven't been crashes. Stability has been good."
"The scalability is great. It's one of the reasons we chose the solution."
"I like that Oracle Data Integrator (ODI) has a straightforward setup and offers good technical support."
"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."
"ODI's most valuable features are it utilizes the database engine and is very lightweight."
"ODI significantly improves data integration and management by allowing customization of data types from various sources like SQL Server databases."
"It allows us to use many languages to develop and to integrate practically all the technologies of the Oracle suite as well as those from non-Oracle vendors."
"The most valuable features of ODI are the knowledge modules, such as the Loading Knowledge module and the Check Knowledge module, they are helpful. We can check for the constraints in ODI. That helps in figuring out what are the constraints that are the primary keys created in the tables. We can check them with the Check Knowledge module."
"The deployment should be easier."
"Azure Data Factory can improve by having support in the drivers for change data capture."
"This solution is currently only useful for basic data movement and file extractions, which we would like to see developed to handle more complex data transformations."
"There is no built-in function for automatically adding notifications concerning the progress or outline of a pipeline run."
"When working with AWS, we have noticed that the difference between ADF and AWS is that AWS is more customer-focused. They're more responsive compared to any other company. ADF is not as good as AWS, but it should be. If AWS is ten out of ten, ADF is around eight out of ten. I think AWS is easier to understand from the GUI perspective compared to ADF."
"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."
"Snowflake connectivity was recently added and if the vendor provided some videos on how to create data then that would be helpful."
"You cannot use a custom data delimiter, which means that you have problems receiving data in certain formats."
"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."
"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."
"The interface of ODI could be improved. For example, navigating and finding functions can be difficult. For example, you have to know which step you need to go to look at where your job status is. The logical step is a bit complex compared to other tools. It's much easier to get a graphical view, but with ODI, it's graphical, plus you have to know all the other pieces that fit around it. You have to think about the logical and physical aspects."
"The initial setup is complex, especially if you also have to install a console."
"An area for improvement would be the lack of SQL compatibility - ODI has no ability to interact with SQL unstructured types and data types."
"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."
"Reverse engineering is complicated and challenging to manage."
Azure Data Factory is ranked 1st in Data Integration with 81 reviews while Oracle Data Integrator (ODI) is ranked 4th in Data Integration with 67 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.