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."I do not have to maintain a separate ETL instance. I can change the SQL when something is not performing correctly."
"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."
"I like that Oracle Data Integrator (ODI) has a straightforward setup and offers good technical support."
"The most valuable feature is Data movement."
"In our DW/BI solution, ODI is the main tool to integrate the data in a daily batch way."
"Oracle provides great documentation."
"It has the ability to easily load slowly changing dimensions."
"It can integrate with more recent databases like Cassandra, Hadoop, and other more recent Big Data databases."
"The solution provides very good and central logging systems. It offers high flexibility with vertical and horizontal extend capacity."
"The monitoring tools are the most valuable feature."
"t is a pretty stable solution. I have not seen any outages in the solution."
"It is simple to transfer files."
"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."
"The initial setup was straightforward."
"The product has good technical support but you usually will not need it because it is quite stable."
"Process Orchestration fulfils the need for middleware to mediate types of connectivity."
"Overall the product is fine, but sometimes its reports unknown errors while we compile ETL scripts."
"I would only point out some minor bugs or glitches in the development interface (ODI studio)."
"An area for improvement in Oracle Data Integrator (ODI) is real-time integration. Currently, my company has a workaround to implement real-time integration, an area on which Oracle must focus more. Real-time integration should be easier in Oracle Data Integrator (ODI). Another area for improvement in Oracle Data Integrator (ODI) is integration with more publishers and subscribers rather than just database integrations."
"It needs easier security."
"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 initial setup is complex, especially if you also have to install a console."
"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."
"It lacks a suite of tools suitable for fully processing data and moving it into decision support warehouses."
"The solution needs to move to the cloud."
"The solution could be more scalable."
"In terms of technical support, it would be helpful if they handled the tickets a bit faster when queries are sent to them."
"The solution is not very scalable because it is at the end of its life."
"SAP Process Orchestration could improve from an API standpoint. This is not an API management tool, which is one of its drawbacks. However, SAP has released an SAP Cloud Platform Integration which has all of the features, such as API management along with process integration to replace what they had previously."
"The older version of the solution will no longer be supported."
"It would be beneficial to enhance the ease of implementing new projects and improve overall stability in our implementations."
"It is not a scalable solution for the cloud. I would not recommend this for the cloud."
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, Informatica PowerCenter, SSIS, Azure Data Factory and Oracle GoldenGate, whereas SAP Process Orchestration is most compared with Mule Anypoint Platform, SAP Data Services, IBM Sterling B2B Integration Services, webMethods Integration Server and IBM B2B Integrator. 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.