We performed a comparison between Alteryx Designer and Oracle Data Integrator (ODI) based on real PeerSpot user reviews.
Find out in this report how the two Data Integration solutions compare in terms of features, pricing, service and support, easy of deployment, and ROI."Alteryx Designer's user interface is great, as it is very user-friendly."
"I believe in the ability to connect to multiple data sources, as well as the ease of use to transform data and output data in a variety of formats."
"Alteryx Designer's best features are that it's easy to use and performs well."
"It has great UI."
"Alteryx Designer is easier to use for machine learning models. However, I am not very good at Python scripts which you will need to make the machine learning scripts."
"The functionality of drag and drop is the most valuable. It is a very user-friendly tool that can be understood easily. My teams also work with other solutions, such as Integration Services, and these solutions are very difficult for people who don't have technical knowledge."
"The most valuable features are the integrated properties and integrated connectivity."
"The product is intuitive and easy to use."
"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 CAEM is very useful in its modularity and portability."
"It can integrate with more recent databases like Cassandra, Hadoop, and other more recent Big Data databases."
"The most valuable feature of ODI is the to use of the whole ETL to create a data lake."
"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."
"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."
"Easy to understand, very developer-friendly, and has a big forum community and lots of documentation for support."
"The product has an ELT approach."
"It would be simpler if they provided a component where you could simply enter some parameters and see the results."
"Alteryx Designer overall should be easier to use."
"The product could offer more connectors and more databases with support for the in-database function."
"Alteryx's data science and machine learning capabilities are where it loses out to DataIQ."
"If the price were reduced then it would be more competitive."
"Optimizing processing times is one area I would like to see improved in Alteryx Designer. Sometimes, the workflows take an extremely long time to run. There are days when I have had to wait two to three hours for a single process to complete. There needs to be a functionality to split the processes."
"The only thing is sometimes it can be a bit slow."
"Its cost can sometimes be a drawback."
"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."
"The resource management aspect of the solution could be improved."
"If there was an add-on tool to hide the performance issues and solve them for me, then I might be interested in that as it would provide me value."
"At present, when multiple steps are executed in parallel in the load plan and errors occur, the error handling mechanism does not function correctly."
"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 tool should improve its pricing. It prevents the application of Oracle ODI on small and medium projects in countries like Croatia, Germany, or the US. While there are no technological obstacles to using it, the high price makes it unfeasible for projects with smaller budgets."
"ODI could improve the ease of use. There is a steep learning curve to use the solution."
"An area for improvement would be the lack of SQL compatibility - ODI has no ability to interact with SQL unstructured types and data types."
Alteryx Designer is ranked 9th in Data Integration with 27 reviews while Oracle Data Integrator (ODI) is ranked 4th in Data Integration with 67 reviews. Alteryx Designer is rated 8.0, while Oracle Data Integrator (ODI) is rated 8.2. The top reviewer of Alteryx Designer writes "An easy-to-use automation solution with satisfying customer support". 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". Alteryx Designer is most compared with Azure Data Factory, FME, Informatica PowerCenter, SSIS and Infogix Data360 Analyze, whereas Oracle Data Integrator (ODI) is most compared with Oracle Integration Cloud Service, Informatica PowerCenter, SSIS, Azure Data Factory and Oracle GoldenGate. See our Alteryx Designer 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.