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 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)
Melissa Data Quality
Ranking in Data Quality
8th
Average Rating
8.4
Reviews Sentiment
7.4
Number of Reviews
40
Ranking in other categories
Data Scrubbing Software (4th)
 

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

"Its data cleansing capabilities are very valuable. The match and merge and the audit trail functionalities are very good."
"The most valuable feature of Informatica Axon is that it is flexible and user-friendly."
"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."
"The most valuable feature of Informatica Axon has been the data marketplace."
"The solution allows the complete governance process, starting from the data quality, those definitions, and it can get the data quality in the EDC."
"Multifeatured and easily scalable data catalog, with good data domain discovery and data profiling features."
"The metadata management of Informatica is great."
"The staging and hierarchical features are the most valuable."
"There have been tangible benefits in combating fraudulent transactions. The information from Melissa Data is fed straight into our fraud system. This creates efficiency but also removes the need for manual address checks."
"Services for all manner of data-driven organizations, no matter their size or budget."
"Through more accurate data, our marketing department has been able to increase delivery and conversion rates through email direct marketing initiatives."
"Decreases chances of incorrect shipping addresses and, thus, returned packages."
"Enables us to send out bulk mailings when we need to verify NCOA."
"Standardizing allows me to more effectively check for duplicate/existing records. Verifying increases the value of the data."
"​It has a straightforward, easy setup."
"​Ability to keep our data set clean and usable for our community searches.​"
 

Cons

"Currently, there are limitations in processing and the interface."
"Certain shortcomings in the product's UI make it an area where improvements are required."
"I have received feedback from certain teams and there is a steep learning curve to use this solution."
"Its features for partitioning and optimization could be better."
"The data discovery isn't that good yet for Salesforce. We have another tool that we use for this. It may be a problem because Salesforce on the cloud."
"With the solution, we had some issues, and we have every day, and we used to open a ticket. Sometimes, there are data issues and transformation issues."
"Informatica MDM has limitations with connectivity."
"One area that could use improvement is the speed of the web interfaces. At present, they are very slow. I think it is essential that we are original and robust on-premises."
"Many issues, sometimes I have to completely log out and start over."
"One thing I would want to have, when you're doing a property search, you can do it either on the FIPS in the APN number or the address itself. For some entries, I'll have the APN number, and some I'll have the address. Apparently it cannot process something when both the FIPS-APN and the address are on there. I have to sort, once with one and once with the other, which is a little bit of a pain."
"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."
"We would appreciate it if there was a larger database so that we could find information more often. For example, we can search for 10 people and only find the information for three of them, if we are lucky."
"An area for improvement is where an end customer's address is not found in the Melissa Data database, even though it is a valid address."
"Pricing model."
"Address validation and parsing in a few countries have room for improvement."
"The tool needs to provide resizable forms/windows like all other SSIS windows. Vendor claims its an SSIS limitation however all SSIS components are resizable so that isn't true. This is just an annoyance but needless."
 

Pricing and Cost Advice

"The solution's pricing model is easy, but it is very expensive."
"It's offers value for money. They're more competitive with respect to pricing and offerings."
"The product is highly-priced."
"I rate the product's pricing a seven on a scale of one to ten, where one is the lowest price and ten is the highest price."
"The price of Informatica Cloud Data Integration could be reduced."
"The price is comparable."
"It's pretty high for us. It's more on the higher side, like low to middle high."
"It's a costly solution"
"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."
"They were willing to work with our preferred vendors, though it involved extra steps to get the license."
"Generally, the cost is ROI positive, depending on your shipping volume."
"This vendor has no equal in pricing for equivalent functionality."
"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."
"It's affordable."
"The price for address validation is similar in all software. However, the price for geocoding decides the actual pricing. If you get their most accurate geocoding (called GeoPoints), then it will add about $10k+ per million requests."
report
Use our free recommendation engine to learn which Data Quality solutions are best for your needs.
824,067 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%
Financial Services Firm
12%
Insurance Company
11%
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: December 2024.
824,067 professionals have used our research since 2012.