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
Reviews Sentiment
6.8
Number of Reviews
181
Ranking in other categories
Data Integration (3rd), Business Process Management (BPM) (6th), 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
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
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

"Informatica MDM stands out as a tool that can give you the flexibility needed for doing channel-specific data quality or business validation."
"We use it for various use cases, including data provisioning, data validation, continuous monitoring of data quality, and data standardization."
"It has flexibility in extending the data model."
"Axon has a marketplace that allows you to showcase all the assets the data owner has, so they can request access. That's one feature we use extensively. Axon also offers great visibility and intuitive searchability, allowing you to easily search data assets. You can check the lineage and see the work EDC does. EDC handles all the classification, cataloging, and lineage. It's integrated with Axon, and anyone can see that."
"The capability of the tool to scan and capture the metadata from a variety of sources is one of the capabilities that I find most useful. The central repository into which it is going to put that captured metadata is the best."
"The feature of auto-onboarding of the assets, enterprise assets via EDC is good."
"The solution's scalability is high."
"​The tool manually checks on applying business rules and helps to implement them."
"Once it is set up, it is easy to use and maintain."
"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."
"I have found the most valuable features to be data cleansing and deduplication."
"With Oracle Data Quality, the most valuable feature is entity matching."
 

Cons

"The cloud version of Axon is far behind the on-prem, and many of my clients want to go fully to the cloud. However, Axon has to be an on-prem installation. I would like to see their cloud products catch up with their on-prem capabilities."
"While my company operates on the cloud, we have seen that Informatica Cloud Data Integration has some performance issues causing it to lag."
"There are also some technical issues sometimes with integrations because clients have a lot of different types of data sources."
"One area that needs to improve is the user experience because it is very complex. The trial version is very complex so it's not easy to start using the program immediately. You must study the rules first."
"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."
"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."
"This is a costly solution. We have several customers who evaluate it but then look for other solutions because of the cost. At present, Informatica MDM comes as an on-premises or cloud-based solution. I would like to see them offer a SaaS-based MDM model. I think they are working on it."
"The product isn't mature enough to provide suitable connectors to various data engines."
"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."
"If the length of time required for deployment was reduced then it would be very helpful."
"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."
"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."
 

Pricing and Cost Advice

"it's expensive, but if you're looking for a stable solution, Informatica MDM is a good one to choose."
"Pricing is determined by the number of licensed users as well as the number of Core CPUs."
"We got a 50% discount."
"I rate Informatica MDM's price a six on a scale of one to ten, where one is a low price, and ten is a high price."
"The pricing is high compared to other tools on the market."
"The product is highly-priced."
"I rate the licensing cost of Informatica MDM a five out of ten."
"Informatica Cloud Data Integration is famously known for its high price. The vendor targets large enterprises, and not medium or small companies. These large companies, and organizations, handle large amounts of data. If you go into any large bank, such as American or Canadian banks, these banks use this solution because it is more reliable, secure, and has more functionality."
"The price of this solution is comparable to other similar solutions."
"The vendor needs to revisit their pricing strategy."
report
Use our free recommendation engine to learn which Data Quality solutions are best for your needs.
823,875 professionals have used our research since 2012.
 

Top Industries

By visitors reading reviews
Financial Services Firm
17%
Computer Software Company
12%
Manufacturing Company
10%
Government
6%
Financial Services Firm
32%
Manufacturing Company
8%
Computer Software 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: December 2024.
823,875 professionals have used our research since 2012.