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
Reviews Sentiment
7.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
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
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

"We have only been using this for about two months, but it has sped up our processing significantly. It makes data mining easy and fast. We don't have to spend an entire month gathering correct information on leads. All we need is a list of home addresses, and in minutes we have names and phone numbers to increase our chance of these leads becoming customers."
"Standardizing allows me to more effectively check for duplicate/existing records. Verifying increases the value of the data."
"Helps our organization provide accurate address information to our customers for direct mailing (household) and other campaigns they want to do."
"​Initial setup was fairly straightforward. The documentation was very good in terms of how to integrate and consume the service(s) that we use. It did not take an abundance of time to set up things on our side to use the service."
"Address verification ensures our customers get their packages, and we aren’t charged for incomplete address information."
"I was able to dedupe millions of records in the past, and append the most recent email."
"​Ability to keep our data set clean and usable for our community searches.​"
"Be confident that the scalability and load are not going to be an issue with the services. ​"
"It is a scalable solution. We have over 1,000 SQL Power Data Quality users in our organization."
"The solution is able to integrate with many systems and other products."
"The Nomo, select form, and so on are the most valuable features."
 

Cons

"More countries should be supported by Melissa."
"Did not work as advertized. Needs better results in address parsing, as described on the website."
"There are some hitches in setup, especially with the new encoding, but otherwise it’s relatively simple."
"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 billing structure does not seem very accurate. We’ve had issues with miscounted batch records processed"
"Address validation and parsing in a few countries have room for improvement."
"The SSIS component setup seems a little klunky."
"Needs better email append coverage (but every vendor struggles with this)."
"The normalization factor should be improved so that it is better scaled. It should be more user-friendly."
"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."
"Downtime issues should be improved."
 

Pricing and Cost Advice

"Cloud version is very cheap. On-premise version is expensive."
"The only complaint that I have towards it is they sell licenses based on a range of usage, and I feel those ranges are too large."
"It's affordable."
"​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."
"Melissa pricing is competitive."
"​You should have a good idea of the size of your data and the amount of cleansing you will be doing, so you will purchase the appropriate size bundle.​"
"Be sure to determine how the data is priced (record-based versus credit-based or some hybrid of data and services)."
"I think it's worth the value for me to run it."
Information not available
report
Use our free recommendation engine to learn which Data Scrubbing Software solutions are best for your needs.
816,406 professionals have used our research since 2012.
 

Top Industries

By visitors reading reviews
Manufacturing Company
14%
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.
816,406 professionals have used our research since 2012.