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

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

 

Comparison Buyer's Guide

Executive SummaryUpdated on Jan 6, 2025

Review summaries and opinions

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

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) (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) (1st), Data Masking (2nd), Metadata Management (1st), Test Data Management Services (2nd), Product Information Management (PIM) (1st), Data Observability (2nd)
Melissa Data Quality
Ranking in Data Quality
8th
Average Rating
8.4
Reviews Sentiment
7.6
Number of Reviews
40
Ranking in other categories
Data Scrubbing Software (4th)
 

Mindshare comparison

As of February 2025, in the Data Quality category, the mindshare of Informatica Intelligent Data Management Cloud (IDMC) is 21.1%, down from 25.8% compared to the previous year. The mindshare of Melissa Data Quality is 2.7%, down from 3.2% compared to the previous year. It is calculated based on PeerSpot user engagement data.
Data Quality
 

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.
GM
SSIS MatchUp Component is Amazing
- Scalability is a limitation as it is single threaded. You can bypass this limitation by partitioning your data (say by alphabetic ranges) into multiple dataflows but even within a single dataflow the tool starts to really bog down if you are doing survivorship on a lot of columns. It's just very old technology written that's starting to show its age since it's been fundamentally the same for many years. To stay relavent they will need to replace it with either ADF or SSIS-IR compliant version. - Licensing could be greatly simplified. As soon as a license expires (which is specific to each server) the product stops functioning without prior notice and requires a new license by contacting the vendor. And updating the license is overly complicated. - The tool needs to provide resizable forms/windows like all other SSIS windows. Vendor claims its an SSIS limitation but that isn't true since pretty much all SSIS components are resizable except theirs! This is just an annoyance but needless impact on productivity when developing new data flows. - The tool needs to provide for incremental matching using the MatchUp for SSIS tool (they provide this for other solutions such as standalone tool and MatchUp web service). We had to code our own incremental logic to work around this. - Tool needs ability to sort mapped columns in the GUI when using advanced survivorship (only allowed when not using column-level survivorship). - It should provide an option for a procedural language (such as C# or VB) for survivor-ship expressions rather than relying on SSIS expression language. - It should provide a more sophisticated ability to concatenate groups of data fields into common blocks of data for advanced survivor-ship prioritization (we do most of this in SQL prior to feeding the data to the tool). - It should provide the ability to only do survivor-ship with no matching (matching is currently required when running data through the tool). - Tool should provide a component similar to BDD to enable the ability to split into multiple thread matches based on data partitions for matching and survivor-ship rather than requiring custom coding a parallel capable solution. We broke down customer data by first letter of last name into ranges of last names so we could run parallel data flows. - Documentation needs to be provided that is specific to MatchUp for SSIS. Most of their wiki pages were written for the web service API MatchUp Object rather than the SSIS component. - They need to update their wiki site documentation as much of it is not kept current. Its also very very basic offering very little in terms of guidelines. For example, the tool is single-threaded so getting great performance requires running multiple parallel data flows or BDD in a data flow which you can figure out on your own but many SSIS practitioners aren't familiar with those techniques. - The tool can hang or crash on rare occasions for unknown reason. Restarting the package resolves the problem. I suspect they have something to do with running on VM (vendor doesn't recommend running on VM) but have no evidence to support it. When it crashes it creates dump file with just vague message saying the executable stopped running.

Quotes from Members

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

Pros

"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."
"Offers data lineage feature"
"We can scan anything."
"The Mapping Designer allows for declarative ETL development (visual scripting) that leverages a wide array of different transformations."
"The Mapping Configuration and PowerCenter wizards are valuable. We use them to run our business logic."
"Replication allows us to fully replicate all objects from Shop Floor Data Collection (SFDC) to in-house/on-premises database in one job."
"The solution's most valuable features are its data quality, match-merge engine, and CLAIRE AI engine, which helps with AI automation."
"The data quality component is very good."
"​Ability to keep our data set clean and usable for our community searches.​"
"Ability to validate addresses, make corrections to address."
"Standardizing allows me to more effectively check for duplicate/existing records. Verifying increases the value of the data."
"Getting the most up to date address for our members. We like to keep in touch with membership a few times a year so we want to maintain up to date addresses to be sure they receive any information that we mail to them."
"Decreases chances of incorrect shipping addresses and, thus, returned packages."
"Services for all manner of data-driven organizations, no matter their size or budget."
"We like having the ability to write our own utilities/software to process our records and store the final output the way we want."
"We use a Melissa API to access the data, so it easy to use, accurate, and fast."
 

Cons

"Informatica Cloud Data Integration could improve the price by making it less expensive."
"Connectivity could be improved, it can be a little slow."
"Informatica Axon needs to improve its interface."
"It is more complicated to extract data using the product compared to Visio. The system could display the details on the screen."
"Informatica Data Quality has its data warehouse, primarily using Oracle and some SQL databases. You need a database to host the data."
"They could provide more robust performance for data integration processes. It would help in improving the data quality more efficiently."
"Informatica is very expensive."
"I think everything related to the APIs and the manageability of the APIs in Informatica MDM are areas where improvements are required."
"It would be helpful if a list of the codes and explanations could be included."
"The custom software solution we still use in-house makes Excel a lot slower than usual."
"Needs to provide more phone numbers, even cell numbers (scrubbed numbers)."
"Pricing is based on tiers, with each tier capped at a specified number of records processed. Once you go over the cap at one tier, you are automatically bumped to the next tier. However, they seem to count failed batch processes so it’s good to keep track of the number of records sent. They’ll fix the count when notified, but their system fails to detect actual successful processes versus failed processes."
"It really hasn't given us a phone number for the owner of the property, and that's one thing I'd really like to be getting. Either a phone number or email."
"I wish there was a way to do a "test run" and see what a particular format will give you."
"Tech support at Melissa Data was very quick to wash their hands of an issue and say it's IT policies on my side that are causing the issue. There was no offer to try and find a work-around. Just an overwhelming attitude of "it’s not our problem.""
"The SSIS component setup seems a little klunky."
 

Pricing and Cost Advice

"The solution's pricing model is easy, but it is very expensive."
"We got a 50% discount."
"We have licenses, and we are provided with certain particular services in the solution."
"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."
"Informatica MDM's pricing is not cheap but comparable to other vendors."
"It is expensive. That's probably the biggest drawback. The business has heartache paying the license, but that's mainly because they don't realize what value it brings. The key thing about the MDM solution is that it is in the backend, and no one sees what it is actually doing. You don't know it is a problem until it is not there."
"Informatica MDM is very expensive. Apart from licensing fees, they have broken down their products into multiple products, and they charge for each and every product. If the data is huge, they charge for the data. At times, we have to use third party services for data cleaning, and they charge for that as well."
"So, there are plans for licensing. There are subscription-based and usage-based licenses. Also, there are licenses for exceptional analytics, etc. In short, there are different models of licensing for every enterprise."
"Trial subscriptions (via cloud) are very cheap and easy to use. It’s a great way to test Listware to see if you want to go deeper with integration."
"Depends on situation. We prefer to have data onsite, but some might prefer web access."
"NCOA address verification was a requirement from USPS to send out the mailers. This was the only option that charged per address which was extremely helpful since we are a small non-profit school."
"Cloud version is very cheap. On-premise version is expensive."
"Understand how may transactions you will be processing so that you can get the right tier pricing."
"​We are concerned that our own pricing is going up every year for Melissa Data products, but we highly recommend the services for people who are routinely sending out mailings."
"This vendor has no equal in pricing for equivalent functionality."
"I think it's worth the value for me to run it."
report
Use our free recommendation engine to learn which Data Quality solutions are best for your needs.
832,138 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%
Manufacturing Company
14%
Insurance Company
13%
Financial Services Firm
10%
Computer Software Company
10%
 

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
No data available
 

Overview

 

Sample Customers

The Travel Company, Carbonite
Boeing Co., FedEx, Ford Motor Co, Hewlett Packard, Meade-Johnson, Microsoft, Panasonic, Proctor & Gamble, SAAB Cars USA, Sony, Walt Disney, Weight Watchers, and Intel.
Find out what your peers are saying about Informatica Intelligent Data Management Cloud (IDMC) vs. Melissa Data Quality and other solutions. Updated: January 2025.
832,138 professionals have used our research since 2012.