Informatica PowerExchange vs Mule Anypoint Platform vs Oracle Data Integrator (ODI) comparison

Cancel
You must select at least 2 products to compare!
Informatica Logo
2,714 views|2,036 comparisons
88% willing to recommend
MuleSoft Logo
5,228 views|3,103 comparisons
93% willing to recommend
Oracle Logo
15,558 views|8,845 comparisons
84% willing to recommend
Comparison Buyer's Guide
Executive Summary

We performed a comparison between Informatica PowerExchange, Mule Anypoint Platform, and Oracle Data Integrator (ODI) based on real PeerSpot user reviews.

Find out what your peers are saying about Amazon Web Services (AWS), MuleSoft, Matillion and others in Cloud Data Integration.
To learn more, read our detailed Cloud Data Integration Report (Updated: March 2024).
767,995 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 product’s flexibility is valuable.""Provides a significant amount of control over the landscape and overall implementation.""Overall, it's a good tool. It's currently number one on the market. It pretty much has all the necessary capabilities to pull the incremental data from the source system, technically speaking.""Mainstream integration and real-time integration are the best features.""The scalability is excellent.""The solution can connect to different systems i.e. mainframe, IMS or AS/400 Legacy Systems.""It is a scalable and versatile solution.""The main benefit of PowerExchange is its native real-time capabilities. Competing tools are counting on third-party packages or Oracle to offer real-time capabilities. However, Informatica has a native ability to scan the data on the file system level and capture the changes almost instantly when I push it to the consumers. The solution has a powerful built-in replication engine."

More Informatica PowerExchange Pros →

"The product’s ability to seamlessly translate protocols is great.""The product is very user-friendly.""The solution's deployment and proxy processes are very good.""Overall, it is a pretty good product. It is also very scalable.""MuleSoft offers with the Anypoint Platform a unified platform for API management and an integration Platform as a Service (iPaaS) as well as an on-premise Enterprise Service Bus pattern.""The most valuable feature of Mule Anypoint Platform is rapid development.""Whenever we need some support in our local language, we get it easily. They also have an office in Germany and if a person is unable to contact them by phone, they can go to the office in person.""The most valuable feature is their integrations and very good API management."

More Mule Anypoint Platform Pros →

"It can integrate with more recent databases like Cassandra, Hadoop, and other more recent Big Data databases.""ODI's most valuable features are it utilizes the database engine and is very lightweight.""The solution's initial setup is straightforward, especially compared to Mule, which our team has worked with before and found to be a bit more complex in terms of setup.""I like that Oracle Data Integrator (ODI) has a straightforward setup and offers good technical support.""The initial setup is easy.""The CAEM is very useful in its modularity and portability.""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.""The product has an ELT approach."

More Oracle Data Integrator (ODI) Pros →

Cons
"The solution could be made more user-friendly. The configurations are also quite difficult.""The product is not suitable for application integration.""Pushdown optimization could be improved.""The major shortcoming of PowerExchange is high availability and failover. None of the versions we've used to date have had the out-of-the-box ability to enable failover and high-availability requirements. This is a significant challenge and risk.""I would like to have easier integration with cloud platforms.""Integration with the largest number of databases and other systems would be important.""Should diversify more, maybe with a reporting and visualization utility,""Technical support can be improved with respect to delays in ticket response time."

More Informatica PowerExchange Cons →

"We would like an entire DevOps in place in this particular solution.""The runtime management and connectors could use some work and are vulnerable to breakage after upgrades.""Price-wise, it is a good product since it is reasonably priced...Mule Anypoint Platform can get too complex for non-technical people.""It would be better if we had a clearer view of the solution's future releases.""The stability could be better.""I would like to see some data integration and automation.""Mule should have better B2B integration.""The initial setup should be made easy and the documentation should have some guidance."

More Mule Anypoint Platform Cons →

"It lacks a suite of tools suitable for fully processing data and moving it into decision support warehouses.""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.""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.""If you have something like Cisco on top of it, you will have endless problems.""The performance of the user interface is in need of improvement.""I rate it a seven out of 10 because there is room for growth because ODI is still new, in comparison to Informatica, which is a mature product.""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."

More Oracle Data Integrator (ODI) Cons →

Pricing and Cost Advice
  • "An annual package license fee is required."
  • "The cost of PowerExchange is reasonable. It does not rely on complicated formulas or unrealistic equations. The pricing model is straightforward. There is one component, and real-time integration is included. Some other solutions require purchasing additional modules or third-party plugins for this capability."
  • "It's expensive. In fact, nobody would buy any product of Informatica if the price was the only consideration. It costs money, and it doesn't come cheap, but it provides value for money in many ways."
  • "There is a need to pay towards the licensing cost of the product. It is an expensive product."
  • "Many users don't prefer to use the product, considering the high costs attached to the licensing part of the solution."
  • "The product is not very expensive."
  • More Informatica PowerExchange Pricing and Cost Advice →

  • "Licensing can be complex as is the case with most iPaaS/cloud offerings."
  • "Mule is not the cheapest integration platform out there, but it deserves the price we are paying."
  • "The product comes complete at one set price including support."
  • "The licensing is core-based. My customers tell me that it's very expensive compared to the cost of other integration suites."
  • "Mule Anypoint Platform pricing is slightly higher compared to Dell Boomi."
  • "The solution is the priciest in the market which is an issue for some clients."
  • "The pricing of our solution is highly competitive. While it may not be categorized as exceptionally low, it is certainly more affordable compared to IBM."
  • "The product is still very expensive."
  • More Mule Anypoint Platform 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 →

    report
    Use our free recommendation engine to learn which Cloud Data Integration solutions are best for your needs.
    767,995 professionals have used our research since 2012.
    Comparison Review
    Anonymous User
    Questions from the Community
    Top Answer:The product is not very expensive. However, the price can grow depending on the customer’s needs and the data feed they… more »
    Top Answer:Informatica is now moving to the cloud. PowerExchange is not being promoted as it used to be. The product is not… more »
    Top Answer:I architected solutions using Oracle SOA/OSB, Spring Boot, MuleSoft Anypoint Platform on cloud / on-premises and hybrid… more »
    Top Answer:Our organization ran comparison tests to determine whether TIBCO BusinessWorks or Mule Anypoint platform integration and… more »
    Top Answer: This is a very flexible solution that comes with multiple uses. My organization mostly uses Mule Anypoint Platform for… more »
    Top Answer:Oracle Integration Cloud Service has a fairly easy initial setup, and Oracle offers initial support and guidance for… more »
    Ranking
    21st
    out of 100 in Data Integration
    Views
    2,714
    Comparisons
    2,036
    Reviews
    9
    Average Words per Review
    654
    Rating
    7.9
    3rd
    Views
    5,228
    Comparisons
    3,103
    Reviews
    21
    Average Words per Review
    547
    Rating
    8.5
    4th
    out of 100 in Data Integration
    Views
    15,558
    Comparisons
    8,845
    Reviews
    16
    Average Words per Review
    429
    Rating
    8.2
    Comparisons
    Also Known As
    PowerExchange, Connectors
    Data Integrator
    ODI
    Learn More
    Overview

    Informatica PowerExchange Connectors provides high performance, out-of-the-box connectivity without having to develop custom data access programs.

    Mule Anypoint Platform is a high-ranking solution that creates a communication layer between disparate systems to eliminate integration problems. The product retrieves and stores data streams from any source type, device, or application, both in the cloud and locally. Mule Anypoint Platform solves the most challenging connectivity problems across Software as a Service (SaaS), service-oriented architecture (SOA), and application programming interfaces (APIs) through connectivity, control, and composability. The unified hybrid integration platform achieves this by creating an application network of data, apps, and devices with API-led connectivity.

    The solution consists of a set of out-of-the-box connectors that work on any type of system and offers a configuration with low coding effort while minimizing the cost and constraints of hard point-to-point connections. The use cases of Mule Anypoint Platform include:

    • Utilizing APIs for application delivery: Specialists can use Mule Anypoint Platform to jumpstart application development and take advantage of pre-built assets or utilize APIs built anywhere using their CI/CD pipelines. Companies can build APIs from scratch in diverse protocols and test them with built-in support for Maven and Jenkins.

    • Flexible deployment: Mule Anypoint Platform can be used in any architecture or environment. The product offers its users flexibility and freedom to select between using MuleSoft's fully managed infrastructure or deployment in popular cloud providers like Amazon AWS, Microsoft Azure, and Google Cloud Platform.

    • Data protection: The product offers high levels of security and compliance with various standards and policies. It can be utilized by companies for protecting data, microservices, APIs, and integrations without development overheads.

    • API and service management and monitoring: The product offers an all-in-one platform for users to manage, secure, and scale their APIs as well as troubleshoot and diagnose in real time to detect underlying issues.

    • Custom marketplace building: Mule Anypoint Platform can be used to facilitate the creation of custom marketplaces for customers, partners, and employees. The product offers pre-built APIs, templates, connectors, accelerators, and other integrations for this purpose.

    Mule Anypoint Platform Features

    Mule Anypoint Platform consists of features for APIs and integrations that are separated into three categories: API management, integration, and deployment and monitoring. These features include:

    • Anypoint Flex Gateway: This feature is designed to manage and secure APIs running across any environment.

    • Anypoint API Governance: This feature ensures consistent API security and quality with self-service tools.

    • Anypoint API Designer: API Designer offers a visual or code-based guided process for designing, documenting, and testing APIs in any language.

    • Anypoint Studio: Through this feature, users can accelerate implementation with prebuilt modules for common integration requirements.

    • Anypoint Connectors: This capacity of the solution allows system integration using a web interface or a desktop-integrated development environment (IDE).

    • Anypoint Code Builder: This is a new feature of the product that is made for developers to design, develop, and deploy APIs, integrations, and automations from a single environment, utilizing an innovative IDE.

    • Anypoint Monitoring: Through this feature, users can monitor in real time their integrations, APIs, and microservices all in one place.

    • Anypoint Runtime Fabric: This is a container service that brings cloud benefits to on-premises deployments both in data centers and on a private cloud.

    • CloudHub: This is the Platform as a Service (PaaS) component of Mule Anypoint Platform.

    • Anypoint Security: This feature offers advanced defense for users' APIs and integrations.

    Mule Anypoint Platform Benefits

    Mule Anypoint Platform offers multiple benefits for companies that utilize its services. Some of the biggest advantages of the product include:

    • Mule Anypoint Platform reduces development time to deliver efficient resource management from a single platform.

    • The product improves agility with innovative architecture that adheres to customers' specific needs.

    • The solution utilizes open technologies that provide customers with reusability, modularity, and collaboration opportunities.

    • Mule Anypoint Platform comes with automated security and governance that ensures customers' data is protected at enterprise levels.

    • The product has built-in reliability, visibility, and scalability, which make operations more resilient for users.

    • The solution is constantly updated and ensures a competitive environment for users through flexible services.

    Reviews from Real Users

    Michael S., a senior enterprise architect at a tech services company, gives Mule Anypoint Platform a high rating and states that the product is constantly improving to help connect applications, data, and devices.

    A senior technical architect at a tech services company likes Mule Anypoint Platform for the good stability with an easy setup and good technical support that the product provides.

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

    Sample Customers
    ACH Food, BNSF Railway Company, Illinois State University
    VMware, Gucci, MasterCard, Target, Time Inc, Hershey's, Tesla, Spotify, Office Depot, Intuit, CBS, Amtrak, Salesforce, Gap, Ralph Lauren
    Griffith University, Kansas City Power & Light, Keste, Raymond James Financial, Valdosta State University
    Top Industries
    REVIEWERS
    Computer Software Company25%
    Insurance Company25%
    Financial Services Firm13%
    Comms Service Provider13%
    VISITORS READING REVIEWS
    Financial Services Firm27%
    Insurance Company12%
    Computer Software Company12%
    Government7%
    REVIEWERS
    Computer Software Company33%
    Healthcare Company11%
    Recruiting/Hr Firm11%
    Media Company6%
    VISITORS READING REVIEWS
    Educational Organization21%
    Computer Software Company14%
    Financial Services Firm9%
    Manufacturing Company8%
    REVIEWERS
    Financial Services Firm24%
    Comms Service Provider11%
    Computer Software Company8%
    University5%
    VISITORS READING REVIEWS
    Financial Services Firm16%
    Computer Software Company14%
    Government8%
    Manufacturing Company8%
    Company Size
    REVIEWERS
    Small Business37%
    Midsize Enterprise11%
    Large Enterprise53%
    VISITORS READING REVIEWS
    Small Business12%
    Midsize Enterprise8%
    Large Enterprise80%
    REVIEWERS
    Small Business30%
    Midsize Enterprise21%
    Large Enterprise49%
    VISITORS READING REVIEWS
    Small Business15%
    Midsize Enterprise28%
    Large Enterprise57%
    REVIEWERS
    Small Business32%
    Midsize Enterprise16%
    Large Enterprise52%
    VISITORS READING REVIEWS
    Small Business17%
    Midsize Enterprise12%
    Large Enterprise71%
    Buyer's Guide
    Cloud Data Integration
    March 2024
    Find out what your peers are saying about Amazon Web Services (AWS), MuleSoft, Matillion and others in Cloud Data Integration. Updated: March 2024.
    767,995 professionals have used our research since 2012.