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

Melissa Data Quality vs SQL Power Data Quality comparison

 

Comparison Buyer's Guide

Executive Summary
 

Categories and Ranking

Melissa Data Quality
Ranking in Data Scrubbing Software
4th
Average Rating
8.4
Number of Reviews
40
Ranking in other categories
Data Quality (8th)
SQL Power Data Quality
Ranking in Data Scrubbing Software
6th
Average Rating
8.8
Number of Reviews
4
Ranking in other categories
No ranking in other categories
 

Mindshare comparison

As of November 2024, in the Data Scrubbing Software category, the mindshare of Melissa Data Quality is 4.6%, down from 4.9% compared to the previous year. The mindshare of SQL Power Data Quality is 0.9%, down from 1.4% compared to the previous year. It is calculated based on PeerSpot user engagement data.
Data Scrubbing Software
 

Featured Reviews

GM
Feb 21, 2024
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.
Ayinde Hammed - PeerSpot reviewer
Oct 2, 2023
Helps you cleanse your data, validate and correct addresses, and identify and remove duplicates
I use SQL most of the time to clean up the data, transform it, and then push it into the database. We extract data from apps and from websites using a lot of applications. We do that using Python. We used Outlook before to pull data from, the source and then log into Snowflake.  The Nomo, select…

Quotes from Members

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

Pros

"This tool works better for us than using a batch processing system that we do not have enough control over as each record is being processed."
"Services for all manner of data-driven organizations, no matter their size or budget."
"Helps our organization provide accurate address information to our customers for direct mailing (household) and other campaigns they want to do."
"We use a Melissa API to access the data, so it easy to use, accurate, and fast."
"Through more accurate data, our marketing department has been able to increase delivery and conversion rates through email direct marketing initiatives."
"Provides quality accurate data that our downstream solutions depend on."
"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."
"​Allows us to identify cell phones before dialing, and giving us data about callers."
"The solution is able to integrate with many systems and other products."
"The Nomo, select form, and so on are the most valuable features."
"It is a scalable solution. We have over 1,000 SQL Power Data Quality users in our organization."
 

Cons

"Did not work as advertized. Needs better results in address parsing, as described on the website."
"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."
"The SSIS component setup seems a little klunky."
"It would be nice if it also had a user interface, as it did in years past."
"It will mix up family members at times, so we will change addresses at times that shouldn’t be changed."
"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."
"The custom software solution we still use in-house makes Excel a lot slower than usual."
"The normalization factor should be improved so that it is better scaled. It should be more user-friendly."
"Downtime issues should be improved."
"The only area of improvement that we've come across within the solution was the portfolio roadmap creation. There's a bit of limitation there, but otherwise, the tool itself is very good."
 

Pricing and Cost Advice

"This vendor has no equal in pricing for equivalent functionality."
"Pricing is very reasonable."
"Generally, the cost is ROI positive, depending on your shipping volume."
"I think it's worth the value for me to run it."
"Buy a lot more credits than you think you’re going to need."
"It's affordable."
"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."
"Understand how may transactions you will be processing so that you can get the right tier pricing."
Information not available
report
Use our free recommendation engine to learn which Data Scrubbing Software solutions are best for your needs.
814,763 professionals have used our research since 2012.
 

Top Industries

By visitors reading reviews
Manufacturing Company
13%
Financial Services Firm
11%
Insurance Company
10%
Computer Software Company
9%
No data available
 

Company Size

By reviewers
Large Enterprise
Midsize Enterprise
Small Business
No data available
 

Questions from the Community

Ask a question
Earn 20 points
What do you like most about SQL Power Data Quality?
The Nomo, select form, and so on are the most valuable features.
What advice do you have for others considering SQL Power Data Quality?
It is a very good solution and I recommend it. I rate the overall solution an eight out of ten.
 

Learn More

 

Overview

 

Sample Customers

Boeing Co., FedEx, Ford Motor Co, Hewlett Packard, Meade-Johnson, Microsoft, Panasonic, Proctor & Gamble, SAAB Cars USA, Sony, Walt Disney, Weight Watchers, and Intel.
TimeWarner, Champion Technologies Tiscali, Oneil, Broadspire,youbet.com, Pepsi Co, Citco, John Lewes
Find out what your peers are saying about Melissa Data Quality vs. SQL Power Data Quality and other solutions. Updated: October 2024.
814,763 professionals have used our research since 2012.