We performed a comparison between Oracle Data Integrator (ODI) and WSO2 Enterprise Integrator 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 initial setup is easy."
"The CAEM is very useful in its modularity and portability."
"Oracle provides great documentation."
"The most valuable feature is Data movement."
"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 is an ETL tool, which does the extract, transform, and load."
"In our DW/BI solution, ODI is the main tool to integrate the data in a daily batch way."
"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."
"It's a consolidated product. It works and it does its job pretty well."
"The solution basically conforms to our standards."
"The learning curve for this solution is very good."
"It's a very complete product. It allows us to network security and add more layers of security to the system."
"The solution's technical support is very knowledgeable."
"The solution's customer service is good."
"In my opinion, the most valuable aspect of this solution is its extensive range of adaptors and connectors. This feature holds significant importance and provides great value to users."
"The installation process is easy."
"The solution lacks some functions and features."
"It needs easier security."
"ODI could improve by focusing on streamlining its features without unnecessary overhead."
"An area for improvement would be the lack of SQL compatibility - ODI has no ability to interact with SQL unstructured types and data types."
"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 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."
"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 server is very specific and it is very difficult to get experience with it."
"I would like to see them bring back a feature, from earlier versions, that was very useful in debugging and finding issues."
"If I have to buy software, then it becomes expensive for me."
"There are a lot of security settings that when you apply you have to re-apply again every time you modify a setting. It is something that really needs to be enhanced."
"You cannot include the validation of XPath."
"One of the reasons that we are looking for a replacement is their way of defining integration. The language of the XML structures that I use to describe the integrations are not that standard, and it's not easy to find people who are familiar with this approach."
"They should introduce better pricing for small companies."
"The micro integrator should be improved. There is room for enhancement considering alternative integration components."
Oracle Data Integrator (ODI) is ranked 4th in Data Integration with 67 reviews while WSO2 Enterprise Integrator is ranked 19th in Data Integration with 18 reviews. Oracle Data Integrator (ODI) is rated 8.2, while WSO2 Enterprise Integrator is rated 7.6. 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". On the other hand, the top reviewer of WSO2 Enterprise Integrator writes "Consolidated, reliable, and has responsive technical support". Oracle Data Integrator (ODI) is most compared with Oracle Integration Cloud Service, Informatica PowerCenter, SSIS, Azure Data Factory and Oracle GoldenGate, whereas WSO2 Enterprise Integrator is most compared with Red Hat Fuse, IBM Integration Bus, Oracle Service Bus, webMethods Integration Server and Talend Open Studio. See our Oracle Data Integrator (ODI) vs. WSO2 Enterprise Integrator 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.