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."The solution is easy to integrate and user-friendly."
"It has great UI."
"The most valuable feature of Alteryx Designer is its ability to select all the inputs and formulas."
"The product offers very good analytics."
"It helps them to create customized workflows, transform data, perform calculations, and consolidate multiple data sources into a target database."
"I like Alteryx Designer's drag-and-drop feature, where you drag a component, configure it and quickly run it."
"The product is intuitive and easy to use."
"One of the things I like about Alteryx Designer is how easy it is to connect numerous data inputs, including API connectors. This helps tremendously in reducing the time required to extract data from systems like SAP that don't have straightforward connectivity options."
"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 scalability is great. It's one of the reasons we chose the solution."
"The most valuable features of ODI are the ease of development, you can have a template, and you can onboard transfer very quickly. There's a lot of knowledge modules available that we can use. If you want to connect, for example, a Sibyl, SQL, Oracle, or different products, we don't have to develop them from scratch. They are available, but if it's not, we can go into the marketplace and see if there's a connector there. Having the connector available reduces the amount of hard work needed. We only have to put the inputs and outputs. In some of the products, we use there is already integration available for ODI, which is helpful."
"It has the ability to easily load slowly changing dimensions."
"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."
"ODI significantly improves data integration and management by allowing customization of data types from various sources like SQL Server databases."
"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 initial setup is easy."
"The product could offer more connectors and more databases with support for the in-database function."
"It would be simpler if they provided a component where you could simply enter some parameters and see the results."
"I would like to be able to include small snippets of code inside of the solution. The tool has only drag-and-drop features to make it easy to use, but sometimes I feel like this makes it more complicated."
"We need more documentation."
"The major concern in Alteryx Designer stems from the high costs attached to the product."
"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 price of the product is an area with certain shortcomings where improvements are required."
"Alteryx could move faster to create a cloud equivalent of the desktop version of Designer."
"An area for improvement would be the lack of SQL compatibility - ODI has no ability to interact with SQL unstructured types and data types."
"I would only point out some minor bugs or glitches in the development interface (ODI studio)."
"The price needs to be lowered. It's too expensive."
"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."
"Oracle support services are not up to the mark."
"The solution lacks some functions and features."
"The resource management aspect of the solution could be improved."
"Technical Support could be better."
Alteryx Designer is ranked 9th in Data Integration with 28 reviews while Oracle Data Integrator (ODI) is ranked 4th in Data Integration with 68 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, SSIS, Informatica PowerCenter and Zapier, 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.