Try our new research platform with insights from 80,000+ expert users

Informatica Intelligent Data Management Cloud (IDMC) vs Oracle Data Integrator (ODI) comparison

 

Comparison Buyer's Guide

Executive SummaryUpdated on Dec 19, 2024

Review summaries and opinions

We asked business professionals to review the solutions they use. Here are some excerpts of what they said:
 

ROI

Sentiment score
7.1
Informatica Cloud enhances data quality and processes, with ROI influenced by master data, change management, and adoption rates.
Sentiment score
7.6
Oracle Data Integrator provides high ROI, reducing custom ETL efforts and costs, with Cloud version enhancing implementation and efficiency.
 

Customer Service

Sentiment score
6.9
Informatica offers strong support, praised for expertise but needing consistent response times; priority and contracts affect service quality.
Sentiment score
5.9
ODI support gets mixed reviews; quick solo responses but struggles in multi-product setups, often leading users to forums.
Due to the tool's maturity limitations, solutions are not always simple and often require workarounds.
I can get solutions quickly, and any tickets I submit to Oracle are responded to and resolved rapidly.
 

Scalability Issues

Sentiment score
7.3
Informatica Intelligent Data Management Cloud offers scalable solutions, handling large volumes with proper planning and excellent documentation for user satisfaction.
Sentiment score
7.6
Oracle Data Integrator scales well, integrating with WebLogic, while configuration and setup impact its performance in various environments.
As a SaaS platform, IDMC is quite scalable and provides complete flexibility.
 

Stability Issues

Sentiment score
7.7
Informatica IDMC is generally reliable despite occasional issues, with strong vendor support ensuring minimal downtime and manageable bugs.
Sentiment score
7.3
Oracle Data Integrator is stable and efficient, with minor configuration challenges resolved in newer versions like 12.1.3 and 12cR2.
Stability is crucial because IDMC holds business-critical data, and it needs to be available all the time for business users.
 

Room For Improvement

Informatica IDMC needs UI improvements, better automation, pricing review, enhanced support, and performance enhancements for optimal usability.
ODI users seek improved performance, usability, integration, and cost-efficiency, with better error handling, authentication, and automation features.
The tool needs to mature in terms of category-specific attributes or dynamic attributes.
If I use a source system like Oracle and a target system like Teradata, ODI will still run, but it struggles a bit with different infrastructures.
 

Setup Cost

Informatica IDMC pricing is high, varies by project, and often suits large enterprises with negotiable options.
Oracle Data Integrator has complex, costly pricing with various licensing options; discounts and packages can reduce expenses for enterprises.
It ranges from a quarter million to a couple of million a year.
ODI is cheaper compared to Informatica PowerCenter and IBM DataStage.
 

Valuable Features

Informatica IDMC provides flexible data management with seamless integration, AI capabilities, and robust governance for efficient data handling.
Oracle Data Integrator features flexible, customizable integration with diverse technologies, enhancing performance and efficiency in data integration tasks.
The platform's ability to pull in data from other platforms without the need for an additional integration tool enhances its appeal.
Oracle Data Integrator (ODI) is powerful and strong if my system uses Oracle components for environments like OLTP, enterprise data warehouse, or data marts.
 

Categories and Ranking

Informatica Intelligent Dat...
Ranking in Data Integration
3rd
Average Rating
7.8
Reviews Sentiment
6.8
Number of Reviews
182
Ranking in other categories
Data Quality (1st), Business Process Management (BPM) (13th), Business-to-Business Middleware (4th), API Management (8th), Cloud Data Integration (3rd), Data Governance (2nd), Test Data Management (3rd), Cloud Master Data Management (MDM) Solutions (1st), Data Management Platforms (DMP) (1st), Data Masking (2nd), Metadata Management (1st), Test Data Management Services (3rd), Product Information Management (PIM) (1st), Data Observability (2nd)
Oracle Data Integrator (ODI)
Ranking in Data Integration
7th
Average Rating
8.2
Reviews Sentiment
6.8
Number of Reviews
71
Ranking in other categories
No ranking in other categories
 

Mindshare comparison

As of April 2025, in the Data Integration category, the mindshare of Informatica Intelligent Data Management Cloud (IDMC) is 4.6%, down from 7.5% compared to the previous year. The mindshare of Oracle Data Integrator (ODI) is 4.6%, up from 4.4% compared to the previous year. It is calculated based on PeerSpot user engagement data.
Data Integration
 

Featured Reviews

Raj Sethupathi - PeerSpot reviewer
Offers profiling and address standardization but can be complicated
Informatica Data Quality has its data warehouse, primarily using Oracle and some SQL databases. You need a database to host the data. The cleansed version of the data is stored in the data warehouse. It integrates with PowerCenter and other Informatica tools. The integration details can be complex, but a regional setup is involved in this process. Profiling smaller datasets, such as 10,000-50,000 records, worked fine. However, unexpected issues could arise with larger datasets, such as thousands of records or more, especially with tables containing many columns. Handling tables with fifty or more columns can be challenging, even in Excel. A mismatch in data types could cause the entire system to crash. Continual enhancements are being made to address these issues, which can be unique to specific industries like finance and healthcare.
Jagadish Sau - PeerSpot reviewer
Straightforward to implement, scalable, and has good stability and documentation, but technical support could still be improved
My company has around ten users of Oracle Data Integrator (ODI). A team of two to five people handles the deployment and maintenance of the solution. The current client of my company has this plan of moving to the cloud, with the possibility of replacing the ETL tool altogether, which could mean that more data is coming up, so there may be a plan to increase the usage of Oracle Data Integrator (ODI). My advice to others looking into implementing Oracle Data Integrator (ODI) is that if your database is on Oracle or SQL server, then Oracle Data Integrator (ODI) is a good tool to use. My rating for Oracle Data Integrator (ODI) is seven out of ten.
report
Use our free recommendation engine to learn which Data Integration solutions are best for your needs.
845,040 professionals have used our research since 2012.
 

Comparison Review

it_user99375 - PeerSpot reviewer
Mar 31, 2014
Oracle GoldenGate vs. Oracle Active Dataguard
As an Oracle DBA, while working upon high availability of your database you may stumble upon various Oracle strategic capabilities that fall into categories of Oracle Replication. Oracle provides various technologies for replication like GoldenGate, streams, and Active Dataguard. Replication…
 

Top Industries

By visitors reading reviews
Financial Services Firm
17%
Computer Software Company
12%
Manufacturing Company
10%
Insurance Company
6%
Financial Services Firm
17%
Computer Software Company
12%
Government
10%
Manufacturing Company
8%
 

Company Size

By reviewers
Large Enterprise
Midsize Enterprise
Small Business
 

Questions from the Community

How does Azure Data Factory compare with Informatica Cloud Data Integration?
Azure Data Factory is a solid product offering many transformation functions; It has pre-load and post-load transformations, allowing users to apply transformations either in code by using Power Q...
Which Informatica product would you choose - PowerCenter or Cloud Data Integration?
Complex transformations can easily be achieved using PowerCenter, which has all the features and tools to establish a real data governance strategy. Additionally, PowerCenter is able to manage huge...
What are the biggest benefits of using Informatica Cloud Data Integration?
When it comes to cloud data integration, this solution can provide you with multiple benefits, including: Overhead reduction by integrating data on any cloud in various ways Effective integration ...
What's the difference between Oracle Integration Cloud Service and Oracle Data Integrator (ODI)?
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 c...
What do you like most about Oracle Data Integrator (ODI)?
In comparison with other products of the same range, licensing mode is really attractive, no need to license according technology/topology to be used and an incredible Versatility to build any Data...
What is your experience regarding pricing and costs for Oracle Data Integrator (ODI)?
The pricing of Oracle Cloud Services is not favorable as it charges daily regardless of usage, unlike competitors who charge only for days used.
 

Also Known As

ActiveVOS, Active Endpoints, BPM, Address Verification, Persistent Data Masking, Cloud Test Data Management, PIM, , Enterprise Data Catalog, Data Integration Hub, Cloud Data Integration, Data Quality, Cloud API and App Integration
ODI
 

Overview

 

Sample Customers

The Travel Company, Carbonite
Griffith University, Kansas City Power & Light, Keste, Raymond James Financial, Valdosta State University
Find out what your peers are saying about Informatica Intelligent Data Management Cloud (IDMC) vs. Oracle Data Integrator (ODI) and other solutions. Updated: February 2025.
845,040 professionals have used our research since 2012.