IT Central Station is now PeerSpot: Here's why

Oracle Data Integrator (ODI) vs SAP Process Orchestration comparison

Cancel
You must select at least 2 products to compare!
Featured Review
Buyer's Guide
Cloud Data Integration
July 2022
Find out what your peers are saying about MuleSoft, Amazon, Informatica and others in Cloud Data Integration. Updated: July 2022.
619,967 professionals have used our research since 2012.
Quotes From Members
We asked business professionals to review the solutions they use.
Here are some excerpts of what they said:
Pros
"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."

More Oracle Data Integrator (ODI) Pros →

"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."

More SAP Process Orchestration Pros →

Cons
"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."

More Oracle Data Integrator (ODI) Cons →

"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."

More SAP Process Orchestration Cons →

Pricing and Cost Advice
  • "The solution is expensive because of the model they use. The cost is for the license and for support."
  • "ODI comes included when buying the cloud version of the Oracle database license."
  • More Oracle Data Integrator (ODI) Pricing and Cost Advice →

  • "There are fees in addition to the licensing."
  • "It's not an expensive solution."
  • "Looking at market conditions, vendors nowadays are giving products at very low price levels. However, SAP Process Orchestration have not yet reduced their prices. The prices could be reduced a lot to stay competitive."
  • "The license is a one-time payment, and additional costs are only incurred on the infrastructure side since it's an on-premise solution."
  • "The price of SAP Process Orchestration was reasonable."
  • More SAP Process Orchestration Pricing and Cost Advice →

    report
    Use our free recommendation engine to learn which Cloud Data Integration solutions are best for your needs.
    619,967 professionals have used our research since 2012.
    Questions from the Community
    Top Answer:Oracle Integration Cloud Service has a fairly easy initial setup, and Oracle offers initial support and guidance for those who might find the setup to be challenging. There are complications that come… more »
    Top Answer:What is the OLAP that you are using? Hosted in Cloud or on-premise?  The target DB should have its tool to extract data.
    Top Answer:I know I'm late to the party but here are my comments to this. I would ask what version of ODI are you running, but for the most part it doesn't matter. I will say that since you are saying Mapping… more »
    Top Answer:The most valuable features of SAP Process Orchestration are the standard APIs that we can use.
    Top Answer: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… more »
    Ranking
    6th
    Views
    22,842
    Comparisons
    15,104
    Reviews
    8
    Average Words per Review
    495
    Rating
    8.4
    Views
    9,368
    Comparisons
    5,879
    Reviews
    10
    Average Words per Review
    665
    Rating
    7.9
    Comparisons
    Also Known As
    ODI
    SAP NetWeaver Process Integration, NetWeaver Process Integration
    Learn More
    Overview

    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:

    • Automatic documentation generation
    • Visualization of data flows in the interfaces
    • Customization of generated code
    • Automatic reverse-engineering of existing applications or databases
    • Graphical development and maintenance of transformation and integration interfaces
    • Robust data integrity control features, assuring the consistency and correctness of data
    • Powerful core differentiators
    • Heterogeneous ELT, declarative design and knowledge modules
    • Flexibility and modularity
    • Oracle Data Integrator repository
    • Topology navigator
    • Operator Navigator
    • Security Navigator
    • Integrator Console
    • ODI domains

    Oracle Data Integrator Benefits

    There are many benefits to implementing ODI. Some of the biggest advantages the solution offers include:

    • Efficient architecture: Oracle Data Integrator has a simple architecture that utilizes the source and target servers to perform complex transformations, making it an efficient solution.
    • Supports all platforms: ODI gives you platform independence by supporting all platforms, hardware, and OSes with the same software.
    • Cost-effective: Oracle Data Integrator reduces costs associated with initial hardware and software acquisition, and also decreases maintenance costs because it eliminates the need for an ETL Server and an ETL engine.
    • Automatic detection of faulty data: By using ODI, faulty data is recycled before insertion in the target application, providing you with a data quality firewall.
    • Easy development and maintenance: With a low learning curve, Oracle Data Integrator increases developer productivity while facilitating ongoing maintenance. 
    • Active integration: ODI includes all styles of data integration: data-based, event-based and service-based.

    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."

    SAP NetWeaver Process Integration facilitates the integration of business processes that span different departments, organizations, or companies. SAP PI is based on general standards so as to enable 3rd-party systems to be integrated. At the center of SAP PI is an XML-based communication that uses HTTP (Hyper Text Transfer Protocol). Irrespective of the scenario used, the application-specific contents are transferred in messages in user-defined XML eXtensible Markup Language) from the sender to the receiver either via the Integration Server, or directly between the systems involved. SAP PI can be installed in different ways: Dual usage type installation: Based on both AS ABAP and AS Java. and Advanced Adapter Engine Extended (AEX): Based on AS Java only.
    Offer
    Learn more about Oracle Data Integrator (ODI)
    Learn more about SAP Process Orchestration
    Sample Customers
    Griffith University, Kansas City Power & Light, Keste, Raymond James Financial, Valdosta State University
    Lenovo, Dansk Supermarked A/S, Ego Pharmaceuticals Pty. Ltd, Kaeser Kompressoren
    Top Industries
    REVIEWERS
    Financial Services Firm27%
    Computer Software Company12%
    University8%
    Hospitality Company8%
    VISITORS READING REVIEWS
    Computer Software Company33%
    Comms Service Provider16%
    Financial Services Firm10%
    Government6%
    REVIEWERS
    Computer Software Company23%
    Manufacturing Company23%
    Energy/Utilities Company15%
    Recreational Facilities/Services Company8%
    VISITORS READING REVIEWS
    Computer Software Company29%
    Comms Service Provider13%
    Manufacturing Company9%
    Energy/Utilities Company8%
    Company Size
    REVIEWERS
    Small Business34%
    Midsize Enterprise12%
    Large Enterprise54%
    VISITORS READING REVIEWS
    Small Business14%
    Midsize Enterprise14%
    Large Enterprise72%
    REVIEWERS
    Small Business28%
    Large Enterprise72%
    VISITORS READING REVIEWS
    Small Business14%
    Midsize Enterprise14%
    Large Enterprise72%
    Buyer's Guide
    Cloud Data Integration
    July 2022
    Find out what your peers are saying about MuleSoft, Amazon, Informatica and others in Cloud Data Integration. Updated: July 2022.
    619,967 professionals have used our research since 2012.

    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.