Data Quality Components for SQL Server Integration Services (SSIS)

Melissa Data offers Full and Community Editions to help tailor the right solution to the right problem

Data Quality Components for SSIS Editions

Capabilities Full Edition Community Edition
Global Verify Component
Global Address Verification & Standardization Global Address Verification & Standardization
Parse, standardize, verify, cleanse, transliterate, and format address data for over 240 countries and territories.
International Geocoding International Geocoding
Assign latitude and longitude coordinates (geocodes) to international address data for a better understanding of your customers and prospects.
Request Free Trial Download Free Copy

 

Capabilities Full Edition Community Edition
Contact Verification Component
Address Parsing Address Parsing
Format address records according to USPS® mailing standards and parse them into Street Number, Name, Prefix, Suffix, Pre-Direction, Post-Direction, City, State and Zip.
Name Parsing Name Parsing
Parse full names and multiple names into five components: prefix; first; middle or initial; last; and suffix. Our solution recognizes more than 190,000 first and last names.
(Last Name Only)
Email Correction Email Correction
Ensure the emails in your database are formatted correctly and follow the correct syntax.
Phone Formatting Phone Formatting
Verify, correct & standardize address data by matching a
street address against a ZIP Code to determine validity. Also, verify addresses beyond reach or unknown to USPS® delivery capabilities.
Address Verification Address Verification
Verify, correct & standardize address data by matching a
street address against a ZIP Code to determine validity. Also, verify addresses beyond reach or unknown to USPS® delivery capabilities.
Name Verification Name Verification
Parse and standardize full names and multiple names into five components: Prefix, First, Middle or Initial, Last, and Suffix.
Email Verification Email Verification
Verify Email Address Domains using a Web Service Domain Lookup and correct misspelled email domains.
Phone Verification Phone Verification
Verify the accuracy of U.S. and Canadian numbers, parse phone numbers into component parts (area code, prefix, number), and update area codes changed due to a split or overlay.
Geocoding Geocoding
We match U.S. and international addresses (over 60 countries) against multi-sourced data sets, providing rooftop precision geocoding (Lat/Long
coordinates) and enabling spatial analysis.
Genderizing Genderizing
Determine an individuals gender by first name and segment your list into male and female customers. Our Name Genderizer utilizes a built-in database of thousands of common first names.
License Required Yes No
Request Free Trial Download Free Copy

 

Capabilities Full Edition Lite Edition Community Edition
MatchUp Component MatchUp Component
Identify duplicate records with domain-specific knowledge of contact information; perform Fuzzy Matching using over 16 different Matching Algorithms; and more.
Record Limit Unlimited 1,000,000 50,000
Matchcodes* 19 built-in 19 built-in 9 built-in
Custom Matchcodes
License Required Yes Yes No
Request Free Trial Request Free Trial Download Free Copy

*Matchcodes - Determines the rules of which fields to consider for Matching(eg. Address, City, State, ZIP Code, and Last name).

*Custom Matchcodes - Allows for the creation of custom matching rules.

Capabilities Full Edition Community Edition
Profiler Component Profiler Component
Analyze new data before it is mergedinto a data warehouse, and then ensure data quality is maintained once it has been warehoused.
Record Limit Unlimited 50,000
Result Codes
License Required Yes No
Request Free Trial Download Free Copy
Download Free Trial of Data Quality Components for SQL Server Integration (SSIS)