Oracle Data Integrator (ODI) vs Quest SharePlex vs webMethods Integration Server comparison

Cancel
You must select at least 2 products to compare!
Oracle Logo
15,558 views|8,845 comparisons
84% willing to recommend
Quest Software Logo
2,703 views|1,739 comparisons
100% willing to recommend
Software AG Logo
3,421 views|2,391 comparisons
94% willing to recommend
Comparison Buyer's Guide
Executive Summary

We performed a comparison between Oracle Data Integrator (ODI), Quest SharePlex, and webMethods Integration Server based on real PeerSpot user reviews.

Find out what your peers are saying about Microsoft, Informatica, Oracle and others in Data Integration.
To learn more, read our detailed Data Integration Report (Updated: April 2024).
767,667 professionals have used our research since 2012.
Featured Review
Quotes From Members
We asked business professionals to review the solutions they use.
Here are some excerpts of what they said:
Pros
"The most valuable feature that we use is the Knowledge Modules.""The most valuable feature is Data movement.""I do not have to maintain a separate ETL instance. I can change the SQL when something is not performing correctly.""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.""It is an ETL tool, which does the extract, transform, and load.""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.""ODI's best features are customization, integration with other versioning tools, and the ability to define new knowledge modules.""The initial setup is easy."

More Oracle Data Integrator (ODI) Pros →

"I like SharePlex's Compare and Repair tool.""The core replication and its performance. Performance is crucial, and SharePlex is by far the fastest. The way it handles replication to multiple targets along with basic filtering, as well as from multiple sources to a single target, is very efficient.""Because of the volume of the transactions, we heavily use a feature that allows SharePlex to replicate thousands of transactions. It's called PEP, Post Enhancement Performance, and that has helped us scale tremendously.""There are some capabilities within SharePlex where you can see how the data is migrating and if it still maintains good data integrity. For example, if there are some tables that get out of sync, there are ways to find them and fix the problem on the spot. Since these are very common issues, we can easily fix these types of problems using utilities, like compare and repair. So, if you find something is out of sync, then you can just repair that table. It basically syncs that table from source to target to see if there are any differences. It will then replicate those differences to the target.""The core features of the solution we like are the reliability of the data transfer and the accuracy of data read and write. The stability of the solution is also excellent."

More Quest SharePlex Pros →

"What I like best about webMethods Integration Server is its portfolio of connectors.""The Software AG Designer has been great. It's very intuitive.""It's a visual tool, so our transformations can be quickly implemented without a lot of fuss. The fact that we have an easy way to expose REST services is also very interesting. It offers the possibility to connect over GMS to synchronize message brokers.""The product is very stable.""It integrates well with various servers.""It has a good integration server, designer, and a very good API portal.""Application integration, business process integration, and B2B partner integration are valuable. But among these, I feel B2B partner integration is the most valuable. This module integrates two business partners and exchanges data through electronic data interchange messages in the form of specific standards, without any manual process needed.""Operationally, I consider the solution to be quite good."

More webMethods Integration Server Pros →

Cons
"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.""ODI could improve the ease of use. There is a steep learning curve to use the solution.""It would be really good if Oracle considered enabling the tool to integrate with some other platforms that are deprecated simply for commercial reasons""The performance of the user interface is in need of improvement.""Technical Support could be better.""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.""There are certain things where it can be improved. Initial solution setup seems a bit complex at the start, it should be improved because it becomes bit tough for a novice to get started on this. Sometimes error description is not helpful to understand the problem it gives some generic type of errors which are at times not that helpful to understand the underlying root cause of the issue."

More Oracle Data Integrator (ODI) Cons →

"The reporting features need improvement. It would be very good for users to have a clear understanding of the status of replication.""I would like more ability to automate installation and configuration in line with some of the DevOps processes that are more mature in the market. That would be a considerable improvement.""For its function in relation to replication (i.e. filtering), I'd give it a six or seven out of 10. GoldenGate has much more functionality by comparison.""I don't know how easy it would be to change the architecture in an already implemented replication. For example, if we have a certain way of architecting for a particular database migration and want to change that during a period of time, is that an easy or difficult change? There was a need for us to change the architecture in-between the migration, but we didn't do it. We thought, "This is possibly complicated. Let's not change it in the middle because we were approaching our cutover date." That was one thing that we should have checked with support about for training.""I would like the solution to have some kind of machine learning and AI capabilities. Often, if we want to improve the performance of posting, we have to bump up a parameter. That means we need to stop the process, come up with a figure that we want to bump the parameter up to, and then start SharePlex. Machine learning and AI capabilities for these kinds of improvement would tremendously help boost productivity for us."

More Quest SharePlex Cons →

"Forced migration from MessageBroker to Universal Messaging requires large scale reimplementation for JMS.""In terms of scale, I would give it a four out of 10.""Other products have been using AI and cloud enhancements, but webMethods Integration Server is still lagging in that key area.""webMethods Integration Server needs to add more adapters.""​Large file handling is pretty hard comparatively to other middleware tools.""The stability of the various modules of the product suite have been a bit of a concern lately. Though their support team is always easy to reach out to, I would prefer it not come to that.""We need more dashboards and reporting engines that can provide detailed information for management. In short, we need better analytics.""The product must add more compatible connectors."

More webMethods Integration Server Cons →

Pricing and Cost Advice
  • "Being an ODI developer, I never had to pay for this product. I know that the pricing/licensing is not really low, but the product is really good."
  • "We found that the cost compared to other integration tools is a little high, but the solution works great."
  • "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."
  • "There is a standard license to use the solution but there are other costs in addition, such as hardware and operating system."
  • "Per user, it is $900 USD per year, though they will give some discount. However, even a 60% to 70% of discount for each won't help us much. On top of that, there is the perpetual license you must pay at the outset."
  • "I have yet to determine the exact figure for Oracle Data Integrator (ODI) pricing, but it has lower pricing than Informatica."
  • "The Oracle Data Integrator (ODI) pricing isn't expensive, but it's not cheap, so it's in the middle. I'd rate the pricing as three out of five."
  • More Oracle Data Integrator (ODI) Pricing and Cost Advice →

  • "It is not as expensive as Oracle GoldenGate and has worked really well within our budgets."
  • "It's really good value for the money. There are some things they could improve on, but in terms of the pricing, features, and support, as a holistic package, we are not thinking of anything else at this point in time."
  • More Quest SharePlex Pricing and Cost Advice →

  • "Initialy good pricing and good, if it comes to Enterprise license agreements."
  • "It is worth the cost."
  • "Always plan five years ahead and don’t jeopardize the quality of your project by dropping items from the bill of materials."
  • "Pricing has to be negotiated with the local Software AG representative. SAG can always prepare an appropriate pricing model for every client."
  • "Some of the licensing is "component-ized," which is confusing to new users/customers."
  • "It is expensive, but we reached a good agreement with the company. It is still a little bit expensive, but we got a better deal than the previous one."
  • "The pricing and licensing costs for webMethods are very high, which is the only reason that we might switch to another product."
  • "The vendor is flexible with respect to pricing."
  • More webMethods Integration Server Pricing and Cost Advice →

    report
    Use our free recommendation engine to learn which Data Integration solutions are best for your needs.
    767,667 professionals have used our research since 2012.
    Comparison Review
    Anonymous User
    Questions from the Community
    Top Answer:Oracle Integration Cloud Service has a fairly easy initial setup, and Oracle offers initial support and guidance for… more »
    Top Answer:I like SharePlex's Compare and Repair tool.
    Top Answer:I would like more ability to automate installation and configuration in line with some of the DevOps processes that are… more »
    Top Answer:We use SharePlex to migrate and update from one data center to another. It's helpful for DR and broadcasting solutions… more »
    Top Answer:The synchronous and asynchronous messaging system the solution provides is very good.
    Top Answer:Other products have been using AI and cloud enhancements, but webMethods Integration Server is still lagging in that key… more »
    Ranking
    4th
    out of 100 in Data Integration
    Views
    15,558
    Comparisons
    8,845
    Reviews
    16
    Average Words per Review
    429
    Rating
    8.2
    24th
    out of 100 in Data Integration
    Views
    2,703
    Comparisons
    1,739
    Reviews
    2
    Average Words per Review
    1,441
    Rating
    9.0
    Views
    3,421
    Comparisons
    2,391
    Reviews
    21
    Average Words per Review
    668
    Rating
    8.0
    Comparisons
    Also Known As
    ODI
    Dell SharePlex, SharePlex
    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."

    SharePlex database replication empowers your organization to achieve its database goals now and into the future. Make use of built-in monitoring, conflict resolution, data comparison and synchronization capabilities backed by award-winning support.

    webMethods Integration Server is widely considered to be the best integration server available in the marketplace today. The solution can help users integrate everything and anything.

    webMethods Integration Server allows organizations to display and integrate existing and new business activities. The solution offers components that help users create, test, and install new services. webMethods Integration Server can automate, organize, and construct various gathered services and traditional legacy systems into productive value-added processes. webMethods Integration Server works as a secure platform for distributing and running services. The solution obtains and translates user requests, recognizes and records the requested service, translates and moves the data in the necessary format, receives the information back, and returns the information to the user in the appropriate original format. webMethods is the primary solution used by enterprise organizations for integrating functional coordination with application servers, custom applications, and databases. webMethods makes it easy for enterprise organizations to share electronic documents seamlessly.

    Users have several options to audit webMethods Integration Server processes using some of the component metrics below:

    • Adapters: Using the SOA extension for webMethods, users can easily monitor the performance of every adapter users have deployed. Available metrics include Adapter Services, Adapter Connection Pools, and Adapter Notifications nodes.

    • Business Processes: A business process is a process that uses a specific set of rules to perform tasks in a prescribed order. Many business processes depend on the successful integration of numerous systems, involving many people in varying roles. With the SOA extension for webMethods, users can easily monitor that workflow, ensuring that processes are being performed as defined.

    • Java Services: This includes services created in Java or in languages coordinated with Java.

    • WebServices: This includes services regarding webserver endpoints and performance.

    • XSLT Services: This service will allow users to transform XML data into other formats and includes the transformation to other services.

    • Thread Pools: This metric uses threads to conduct services, gather documents from the webMethods Broker, and initiate triggers. Documents can be published locally on the server or to the broker that will send the document out. A JMS trigger receives inbound messages and then processes those messages accordingly.

    Reviews from Real Users:

    “There are a few things about this product that we definitely like. It is very robust. If you build it nicely, you can't go wrong with it. It's rock solid. The development is very fast. If you know what you're doing, you can develop something very easy and very fast.” - Rohit S., Integration Lead at a wellness & fitness company

    “One of the most important features is that it gives you the possibility to do low-level integration. We can meet any requirements through customizations, transformations, or the logic that needs to be put in. When clients come to me with any problem, in about 99% of cases, I say, "Yes, it is feasible to do through webMethods." It has reached such a level of flexibility and maturity. Most of the things are available out of the box, and even if something is not available out of the box, we can customize it and deliver it for a client's requirements.” - Sushant D., IT specialist at Accenture

    Sample Customers
    Griffith University, Kansas City Power & Light, Keste, Raymond James Financial, Valdosta State University
    Bodybuilding.com, Priceline.com, Ameco Beijing, Viasat, SK Broadband
    Fujitsu, Coca Cola, ING, Credit Suisse, Electrolux, GTA, CosmosDirekt
    Top Industries
    REVIEWERS
    Financial Services Firm24%
    Comms Service Provider11%
    Computer Software Company8%
    University5%
    VISITORS READING REVIEWS
    Financial Services Firm16%
    Computer Software Company14%
    Government8%
    Manufacturing Company8%
    VISITORS READING REVIEWS
    Financial Services Firm17%
    Computer Software Company15%
    Manufacturing Company7%
    Insurance Company6%
    REVIEWERS
    Computer Software Company28%
    Manufacturing Company18%
    Financial Services Firm10%
    Energy/Utilities Company8%
    VISITORS READING REVIEWS
    Financial Services Firm16%
    Computer Software Company14%
    Manufacturing Company10%
    Retailer7%
    Company Size
    REVIEWERS
    Small Business32%
    Midsize Enterprise16%
    Large Enterprise52%
    VISITORS READING REVIEWS
    Small Business17%
    Midsize Enterprise12%
    Large Enterprise71%
    VISITORS READING REVIEWS
    Small Business23%
    Midsize Enterprise12%
    Large Enterprise64%
    REVIEWERS
    Small Business21%
    Midsize Enterprise9%
    Large Enterprise70%
    VISITORS READING REVIEWS
    Small Business19%
    Midsize Enterprise11%
    Large Enterprise70%
    Buyer's Guide
    Data Integration
    April 2024
    Find out what your peers are saying about Microsoft, Informatica, Oracle and others in Data Integration. Updated: April 2024.
    767,667 professionals have used our research since 2012.