We performed a comparison between Oracle Data Integrator (ODI) and SAP Process Orchestration 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 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."
"It has the ability to easily load slowly changing dimensions."
"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 initial setup is easy."
"In our DW/BI solution, ODI is the main tool to integrate the data in a daily batch way."
"Easy to understand, very developer-friendly, and has a big forum community and lots of documentation for support."
"All our systems can be widely integrated by ODI, such as transactional systems, our data warehouses, and B2B integration."
"Oracle provides great documentation."
"The initial setup is easy."
"SAP Process Orchestration is middleware where we are able to manage and interact with everything from a single location. One of the most beneficial areas is monitoring which is very easy because it is all in one place. There are many adapters added recently that can be used for new functionality. The solution is easy to operate and it is more mature than the cloud solution provided by SAP."
"It is a scalable solution."
"The most valuable feature is the seamless integration with backend systems."
"The monitoring tools are the most valuable feature."
"With the latest version what I find to be the most valuable are the REST, SuccessFactors, and Ariba Network adapters."
"The solution is stable."
"The solution offers very good documentation and manuals to assist with understanding the solution."
"The initial setup is complex, especially if you also have to install a console."
"The price needs to be lowered. It's too expensive."
"At present, when multiple steps are executed in parallel in the load plan and errors occur, the error handling mechanism does not function correctly."
"An area for improvement would be the lack of SQL compatibility - ODI has no ability to interact with SQL unstructured types and data types."
"Oracle Data Integrator (ODI) is already good as a solution. Still, it needs some editing of its preview package, or if the package is upgraded, that will make Oracle Data Integrator (ODI) even better."
"ODI could improve the ease of use. There is a steep learning curve to use the solution."
"Reverse engineering is complicated and challenging to manage."
"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."
"Process Orchestration needs to provide secure connectivity as no one has any data information."
"The solution is not very scalable because it is at the end of its life."
"In terms of technical support, it would be helpful if they handled the tickets a bit faster when queries are sent to them."
"The product roadmap suggests it will approach the end of support in several years, and a lot of innovations are now implemented by SAP not in SAP PO, but in SAP Integration Suite, hence, the platform is stable, but doesn't receive a lot of new features in recent updates."
"Its administration management feature needs to be simpler to use."
"It is not a scalable solution for the cloud. I would not recommend this for the cloud."
"The older version of the solution will no longer be supported."
"The usability is an area where it can be improved upon."
Oracle Data Integrator (ODI) is ranked 4th in Data Integration with 67 reviews while SAP Process Orchestration is ranked 1st in Business-to-Business Middleware with 28 reviews. Oracle Data Integrator (ODI) is rated 8.2, while SAP Process Orchestration is rated 8.2. 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 SAP Process Orchestration writes "A tool that can be useful for small integrations and large integrations". Oracle Data Integrator (ODI) is most compared with Oracle Integration Cloud Service, SSIS, Informatica PowerCenter, Azure Data Factory and Oracle GoldenGate, whereas SAP Process Orchestration is most compared with Mule Anypoint Platform, SAP Data Services, webMethods Integration Server and IBM Sterling B2B Integration Services. See our Oracle Data Integrator (ODI) vs. SAP Process Orchestration report.
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.