"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."
"Oracle provides great documentation."
"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."
"Easy to understand, very developer-friendly, and has a big forum community and lots of documentation for support."
"ODI's most valuable features are it utilizes the database engine and is very lightweight."
"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 solution is stable."
"With the latest version what I find to be the most valuable are the REST, SuccessFactors, and Ariba Network adapters."
"SAP Process Orchestration has all the features that are necessary."
"The most valuable features of SAP Process Orchestration are the standard APIs that we can use."
"The initial setup was straightforward."
"The solution provides very good and central logging systems. It offers high flexibility with vertical and horizontal extend capacity."
"The solution offers very good documentation and manuals to assist with understanding the solution."
"The solution lacks some functions and features."
"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 resource management aspect of the solution could be improved."
"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."
"An area for improvement would be the lack of SQL compatibility - ODI has no ability to interact with SQL unstructured types and data types."
"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."
"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."
"It's very difficult to find errors in a simple way."
"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."
"I feel that support is an area that needs improvement. They need to improve the response time and address the customer's issues as soon as possible."
"It is not a scalable solution for the cloud. I would not recommend this for the cloud."
"I think the main area that SAP PO should improve on is offering pre-delivered content like they do when you use SAP Cloud Platform Integration (CPI). SAP should not forget that they still have a lot of customers using Process Orchestration and they should focus more on providing pre-delivered content in SAP PO."
"The solution could be more scalable."
Oracle Data Integrator (ODI) is a data integration software solution that provides a unified infrastructure to streamline data and application integration projects. It uses a powerful design approach to data integration, which separates the declarative rules from the implementation details. The solution is based on a unique ELT (Extract Load Transform) architecture, eliminating the need for a standalone ETL server and proprietary engine.
Oracle Data Integrator Features
ODI has many valuable key features. Some of the most useful ones include:
Oracle Data Integrator Benefits
There are many benefits to implementing ODI. Some of the biggest advantages the solution offers include:
Reviews from Real Users
Below are some reviews and helpful feedback written by PeerSpot users currently using the Oracle Data Integrator (ODI) solution.
Brian D., Business Process and Strategy Specialist Advisor at NTTData, says, “The Knowledge Module (KM) is my favorite feature of ODI. This is where I learned how to use variables to make jobs dynamic. I took that knowledge and created a KM that would go into iTunes and pull the sales of eBooks. Making something that is reusable, like a KM, is important to not only reduce build time but also maintenance in the future.”
Ashok S., Applications Support Manager at a marketing services firm, mentions, "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."
Oracle Data Integrator (ODI) is ranked 6th in Data Integration Tools with 8 reviews while SAP Process Orchestration is ranked 3rd in Business-to-Business Middleware with 10 reviews. Oracle Data Integrator (ODI) is rated 8.4, while SAP Process Orchestration is rated 8.0. The top reviewer of Oracle Data Integrator (ODI) writes "We can make all the EPM tools work together as one and we can create a puzzle that will increase the performance and capability of all EPM tools". On the other hand, the top reviewer of SAP Process Orchestration writes "Gateway for all integrations that is stable and quick to install". Oracle Data Integrator (ODI) is most compared with Oracle Integration Cloud Service, SSIS, Informatica PowerCenter, Oracle GoldenGate and Azure Data Factory, whereas SAP Process Orchestration is most compared with Mule Anypoint Platform, SAP Data Services, webMethods Integration Server, IBM Sterling B2B Integration Services and Oracle Integration Cloud Service.
See our list of best Cloud Data Integration vendors.
We monitor all Cloud 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.