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 (8th), 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 (3rd), Product Information Management (PIM) (1st), Data Observability (2nd)
Oracle Data Quality
Ranking in Data Quality
10th
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 advanced features like task flow and conditional integration are particularly useful."
"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."
"Replication allows us to fully replicate all objects from Shop Floor Data Collection (SFDC) to in-house/on-premises database in one job."
"It has improved our organization because it has made our data more reliable. Data is the most important asset these days, and in order to trust your data, you need these tools to make sure that your data is clean and reliable."
"Informatica Data Quality is a product that is worth the money."
"The interface is really good."
"The most valuable feature of Informatica MDM is hierarchy management. It's not something that's typically available and effective within ERPs."
"The solution has multiple valuable features for metadata collection"
"I have found the most valuable features to be data cleansing and deduplication."
"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."
 

Cons

"Performance also needs to be significantly improved, especially when connecting to SFDC for read and write operations."
"It could be improved by including a buffer that saves data when there is a connectivity issue."
"I have received feedback from certain teams and there is a steep learning curve to use this solution."
"The biggest challenge I see is the IDE's for the cloud and automization are different."
"I would like to see better visuals for business users, such as a dashboard where they can precisely track where problems are."
"It is complicated to establish the lineage in EDC using PowerCenter mappings."
"Data integration should be improved."
"Informatica Axon's response times and certain aspects of the admin panel could be enhanced for better usability."
"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 rate the product's pricing a five on a scale of one to ten, where one is cheap and ten is expensive."
"The price is very high and has become a big concern for our customers who require the solution in order for their business to function smoothly."
"It's pretty high for us. It's more on the higher side, like low to middle high."
"Informatica is very expensive."
"Comparatively, their prices are a little bit too high."
"I rate the product's price a seven on a scale of one to ten, where one is the cheapest and ten is the most expensive. The product is a bit expensive."
"My understanding is that Informatica is quite expensive compare to other tools that are available in the market."
"Informatica Axon is a costly solution. I rate Informatica Axon a four out of ten for its pricing."
"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.
813,161 professionals have used our research since 2012.
 

Top Industries

By visitors reading reviews
Financial Services Firm
17%
Computer Software Company
13%
Manufacturing Company
10%
Government
6%
Financial Services Firm
30%
Computer Software Company
9%
Manufacturing Company
9%
Wholesaler/Distributor
5%
 

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 do you like most about Oracle Data Quality?
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. ...
What needs improvement with Oracle Data Quality?
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 m...
What is your primary use case for Oracle Data Quality?
We're mostly using Oracle Data Quality during the ETVL process, or to make sure that there's one source of truth and that there's no redundancy at all. We're also using the solution for quality ass...
 

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.
813,161 professionals have used our research since 2012.