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

Informatica Intelligent Data Management Cloud (IDMC) vs Oracle Data Quality comparison

 

Comparison Buyer's Guide

Executive Summary
 

Categories and Ranking

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

Featured Reviews

Raj Sethupathi - PeerSpot reviewer
Jun 13, 2024
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.
Venkatraman Bhat - PeerSpot reviewer
Sep 14, 2022
Fast, has good extraction, validation, and transformation features, and provides good support
Though validation is good and fast enough in Oracle Data Quality, an area for improvement is the accuracy of the validation. Though the solution offers multidimensional validation, it needs a bit more improvement in the accuracy aspect because smaller products can offer better accuracy in terms of validation compared to Oracle Data Quality. What I'd like to see from the solution in its next release, is an increase in compliances and regulations that would allow it to cover all industries because multiple verticals demand data quality nowadays, and this improvement will be helpful as Oracle Data Quality is an in-built delivered solution.

Quotes from Members

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

Pros

"The way that the solution scans is very useful."
"The staging and hierarchical features are the most valuable."
"I like the fact that you can find almost any product connection that you need and the list is always expanding."
"The program is stable and scalable."
"The Mapping Designer allows for declarative ETL development (visual scripting) that leverages a wide array of different transformations."
"I like that Informatica MDM has robust matching technology. Informatica MDM is also porting the external Java applications for validations. I can consider that a must-have. It is also exposed to Rest API calls, and we can engage in real-time integrations with any third-party systems."
"What I like best about Informatica MDM is its structured, table-based approach. Unlike Reltio, where data is only visible through the UI and cloud-based, the solution allows access to normalized tables. This means I can directly query and see data in each table. For instance, I can easily get all customer details from the customer table. However, for more complex queries, like seeing all customer interactions with the organization, some SQL knowledge is needed to join different tables and retrieve the details."
"I think the integration feature is probably one of the key features in Informatica MDM...Stability-wise, I rate the solution a ten out of ten."
"With Oracle Data Quality, the most valuable feature is entity matching."
"The features I like most about Oracle Data Quality include extraction, transformation, and validation, which makes it a multipurpose product such as Oracle GoldenGate and Oracle Data Integrator. I also like that Oracle Data Quality is very fast, so you can use it for a large volume of data within a short period. You have to do the validation very quickly, so the solution helps in that area of data quality. Another feature of Oracle Data Quality that I like is the MDM (Master Data Management) where you'll have a single source of protection, and this makes the solution perfect and helpful to my company."
"Once it is set up, it is easy to use and maintain."
"I have found the most valuable features to be data cleansing and deduplication."
 

Cons

"The solution doesn't directly connect to any of the analytical tools."
"Error reporting and debugging need improvement."
"If I want to scan the metadata from the data lineage or the Python code, such areas can get tedious in the tool."
"The biggest challenge I see is the IDE's for the cloud and automization are different."
"Most of the new features added by Informatica are through Elastic Mapping. It would be helpful to have features like multithreading or partitioning for Salesforce to enhance performance."
"The biggest pain point for us is the documentation. Typically, you have to go through knowledge forums and knowledge groups to find out about the syntax issues for interfacing with new products. Typically, you've got to deal with someone who has been through the pain before. Their documents are not really up to date with current innovations happening in the industry. As big as they are, you can't really expect it, but that's our pain point."
"Once the data is masked, we won't be able to reverse it back to its original value."
"The user interface can be a bit more functionality-aligned."
"Though validation is good and fast enough in Oracle Data Quality, an area for improvement is the accuracy of the validation. Though the solution offers multidimensional validation, it needs a bit more improvement in the accuracy aspect because smaller products can offer better accuracy in terms of validation compared to Oracle Data Quality. What I'd like to see from the solution in its next release, is an increase in compliances and regulations that would allow it to cover all industries because multiple verticals demand data quality nowadays, and this improvement will be helpful as Oracle Data Quality is an in-built delivered solution."
"Oracle Data Quality should integrate with data warehousing solutions such as Azure and CWS Office. For example, having the ability to integrate with tools, such as Azure Synapse and SQL data warehousing would be a great benefit."
"If the length of time required for deployment was reduced then it would be very helpful."
"Oracle is currently not that intuitive. We need to use programmers to write code for a lot of the procedures. We need to have them write CL SQL code and write a CL script."
 

Pricing and Cost Advice

"I have heard from customers that the product comes with a huge license cost."
"Informatica MDM's pricetag should come down. They have to cut some costs."
"We switched to Informatica PIM because it was cheaper than the Oracle solution. It is cheaper initially, but they will bundle it later. This is what happens in the industry."
"I'm not sure about the most recent pricing trends, but I don't believe it's significantly different from PowerCenter. I believe it is nearly the same."
"My understanding is that Informatica is quite expensive compare to other tools that are available in the market."
"It's offers value for money. They're more competitive with respect to pricing and offerings."
"It is cost effective and an easily accessible tool."
"It's an expensive solution."
"The vendor needs to revisit their pricing strategy."
"The price of this solution is comparable to other similar solutions."
report
Use our free recommendation engine to learn which Data Quality solutions are best for your needs.
815,854 professionals have used our research since 2012.
 

Top Industries

By visitors reading reviews
Financial Services Firm
17%
Computer Software Company
13%
Manufacturing Company
10%
Insurance Company
6%
Financial Services Firm
32%
Computer Software Company
10%
Manufacturing Company
8%
University
6%
 

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 ...
Ask a question
Earn 20 points
 

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
Datanomic
 

Overview

 

Sample Customers

The Travel Company, Carbonite
Roka Bioscience, Statistics Centre _ Abu Dhabi , Raymond James Financial inc., CaixaBank, Industrial Bank of Korea, Posco, NHS Business Services Authority, RWE Power, LIFE Financial Group,
Find out what your peers are saying about Informatica Intelligent Data Management Cloud (IDMC) vs. Oracle Data Quality and other solutions. Updated: October 2024.
815,854 professionals have used our research since 2012.