Data Quality Components for SQL Server Integration Services (SSIS) enable you to clean, complete, and consolidate your People Data, so you know it’s trustworthy and actionable.
Our data quality components offer a full spectrum of solutions to profile, cleanse, verify, match, merge, purge, parse, standardize, and enrich with geographic, demographic, and firmographic insights.
Melissa is focused on delivering the industry’s most complete solution for data quality and data integration. We offer enterprise-class capabilities with features superior to or not available in other products. Compare, side by side, the features and functionalities of our Community Edition and Full Edition of Data Quality Components for SQL Server.
Solve common data parsing and formatting issues with free edition.
Get access to our full spectrum of data quality solutions for a limited time.
Poor data quality equals poor business. The first step in improving data quality is to profile your data to gain valuable insight into the accessiblilty and usability of your data. The Data Profiling component does just that – it generates simple to advanced profiling information – including basic data statistics (mean, median, frequency, variation, etc.) and details (structure, content, classifications, etc.). Armed with this information you can identify weak points in your data collection processes and work to optimize data quality over time with the Profiling Component's monitoring capabilities.
The Generalized Cleansing Component empowers you to build data cleansing scripts for data suffering from a wide range of errors and inconsistencies. The component combines six operations that allow you to cleanse data and save operations (simple or complex) for future projects. The component is highly customizable so you can use programmatic expressions and regular expressions to trigger operations – giving you the ability to self-validate non-contact data to your own specifications.
Cleansing Operations Available:
Use the Global Contact Verify Component to clean, verify, standardize and format all your global people data – name, address, email and phone. The component utilizes a USPS® CASS-Certified™ engine to return a complete and standardized U.S. address and even adds missing ZIP+4® data, missing suite and apartment numbers, and corrects spelling and formatting errors. Additionally, the component will verify addresses from 240+ countries, standardize addresses to local country format, and add missing postal codes, regions, etc. The component supports many different language sets and can transform non-Latin writing systems into Latin characters so addresses in foreign languages like Russian, Greek, Chinese, Japanese, and others can easily be validated.
The component will geocode international addresses for 40+ countries, providing a precise (rooftop) latitude/longitude coordinate for an address to power market segmentation, sales clustering, logistics, risk exposure, and more.
The component also does verification on your phone, email, and name data. Phone verification includes real-time lookup technology to distinguish between global landlines and mobile numbers, and validates the number is accurate, live, and callable. Caller ID will return the name and address associated with the billing contact.
Email verification capabilities include: real-time email mailbox verification to ensure an inbox is live; email syntax and domain correction; and FCC Mobile Domain Detection to ensure CAN-SPAM compliance.
The Personator Component taps a multisourced dataset containing billions of records to validate for each provided element of a U.S. or Canadian contact record: name; address; phone; and/or email – and match name-to-address to verify identity.
The Personator Component also enriches your contact records by:
Need the speed and security of on-prem deployment?
We offer a Contact Verify Component as an on-prem API for address, name, email, and phone verification to meet your security, privacy, compliance, and/or bandwidth requirements.
On average, a database contains 8 - 10% duplicate records. These duplicates result in waste and inefficiencies and cloud your ability to get a single, accurate view of the customer. The MatchUp Component uses advanced fuzzy matching algorithms and deep domain knowledge of contact data to find even the hardest-to-detect U.S. and international (Canada, Europe, South America, Australasia, and more) duplicate records.
The Fuzzy Match Component leverages a toolbox of state-of-the-art fuzzy matching algorithms and allows user-specified granular control on match thresholds and even fine tuning of the algorithms. Fuzzy Match can use any of the following matching algorithms on any column in your database to identify “non-exact matching” duplicate records:
The SmartMover Component provides change-of-address processing for U.S. and Canadian addresses. This helps you stay in touch with consumers and businesses that have moved, eliminate the costs associated with undeliverable-as-addressed mail, and qualify for applicable postal discounts.
For U.S. addresses, the SmartMover component matches your customer records against the USPS® full NCOALink® data file of 160 million moves going back 48-months. Processing your records utilizing the SmartMover component will satisfy the USPS Move Update requirement for a period of 95 days from the date of processing to qualify for First-Class™ and Standard Mail® discounts. Melissa is a NCOALink® Full Service Provider licensee of the USPS. NCOALink® processing requires a Processing Acknowledgement Form (PAF). Download a copy of our NCOALink PAF
For Canadian addresses, the SmartMover component will match your address file against the Canada Post NCOA® database containing over 11 million records over the last 72 months. Melissa is one of only a handful of Canada Post licensees. Canada NCOA processing requires a signed copy of the Canadian NCOA Acknowledgement Form. Download a copy of our Canadian NCOA form.
The Demographic Component provides detailed consumer demographics from over 2 billion records containing 250 million individuals and 170 million households in the U.S. This valuable information offers you deeper insight into your customers, their behavior, and trends.
The Following variables can be added:
The Property Component provides valuable property and mortgage data from over 140 million records for the U.S. Access variables from over 165 fields in categories such as: parcel; property address; owner; owner mail address; property values; current sale; current trust deed; prior sale; lot/land; square footage; building. For a complete list of data available click here.
The IP Location Component provides the geographic location of an Internet Protocol (IP) address, including latitude, longitude, city, state, ZIP Code™/Postal Code, region, hosting Internet Service Provider (ISP), connection speed and type, and domain name. This information helps you identify where your web visitors are coming from. This is useful for ecommerce sites where you might want to prepopulate country code on forms, display a different language, filter access from countries you don’t do business with, and/or reduce credit card fraud based on geographic location. IP Location can also help fight illegal spamming and hacking by identifying the location of the problem.
Add detailed firmographic data to your business records including company and contact information (name, address, phone, and email address), job title, SIC/NAICs codes, employee size, stockticker abbreviation, sales estimate and more, with the BusinessCoder component. Improve lead scoring, analytics, sales and marketing efforts by adding firmographic elements to your prospect and account records.
Melissa Data’s Personator World Web Service makes it easy to check and verify your data in real time. Using trusted reference and national databases, the service can verify a person’s name, address, phone, email, date of birth and national ID.
Request a free trial by filling out the form.