SQL Server Data Quality
Data Quality and Enhancement Transforms for SQL Server Integration Services (SSIS)
Melissa’s Data Quality Components for SSIS is a unique set of global data quality tools for Microsoft’s integration and ETL (extract-transform-load) solution that empower users to collect data from any source, clean and enrich it during migration and integration operations, to gain immediate insight for actionable intelligence.
- Achieve better insight with clean, accurate customer data
- Easily onboard, apply standards, enforce rules, cleanse, and enrich Big Data
- Run data quality on premise and in the Cloud
Melissa Data Quality and Enhancement Transforms
Melissa leverages the integration power of SQL Server to provide a full spectrum of data quality with the following transforms:
![SQL Server Data Quality - Profiler SQL Server Data Quality - Profiler](images17/sql-server-data-profiler.png)
Profiler
The Profiler transform generates patterns and statistics to identify weaknesses in your data quality process and gain insight into the actual health of your data.
![SQL Server Data Quality - Contact Verify SQL Server Data Quality - Contact Verify](images17/sql-server-contact-data-verify.png)
Contact Verify
The Contact Verify transform verifies, corrects, and standardizes U.S and Canada postal addresses, email addresses, and phone numbers and converts US addresses to roof-top latitude/longitude coordinates.
![SQL Server Data Quality - Global Verify SQL Server Data Quality - Global Verify](images17/sql-server-global-verify.png)
Global Verify
The Global Verify transform verifies, corrects and standardizes postal addresses, email addresses, and phone numbers for 240+ countries, plus converts street addresses to precise latitude/longitude coordinates.
![SQL Server Data Quality - Personator SQL Server Data Quality - Personator](images17/sql-server-personator.png)
Personator
The Personator transform verifies identity, validates postal address, email address, and phone number, plus updates the current address for a contact and enriches records with missing email, phone, address data and demographic info.
![SQL Server Data Quality - Property SQL Server Data Quality - Property](images17/sql-server-property-mortgage-data.png)
Property
The Property transform provides information about a given property parcel, including: assessed value; last sale price; current mortgage; physical dimensions of the land and buildings; and square footage.
![SQL Server Data Quality - MatchUp SQL Server Data Quality - MatchUp](images17/sql-server-fuzzy-matching.png)
MatchUp
The MatchUp transform provides advanced deduping/matching capabilities and survivorship rules to eliminate duplicates and create a single customer view.
![SQL Server Data Quality - Fuzzy Matching SQL Server Data Quality - Fuzzy Matching](images17/sql-server-fuzzy-match.png)
Fuzzy Matching
The Fuzzy Matching transform compares and matches single and multiple columns using a toolbox of algorithms to identify hard-to-spot similar and duplicate records.
![SQL Server Data Quality - IP Locator SQL Server Data Quality - IP Locator](images17/sql-server-ip-locator.png)
IP Locator
The IP Locator transform geolocates a given IP address and returns latitude/longitude, city, state, postal code, county and ISP information.
![SQL Server Data Quality - Business Coder SQL Server Data Quality - Business Coder](images17/sql-server-firmographic-data.png)
Business Coder
The Business Coder transform provides detailed firmographic data on over 25 million U.S. businesses – ideal for standardizing business entities, consolidating records and lead scoring.
![SQL Server Data Quality - SmartMover SQL Server Data Quality - SmartMover](images17/sql-server-change-of-address-ncoalink-processing.png)
SmartMover
The SmartMover transform matches your address records against the USPS NCOALink database or Canada Post NCOA database and returns the current address of customers that have moved.
![SQL Server Data Quality - Cleanser SQL Server Data Quality - Cleanser](images17/sql-server-data-cleansing.png)
Cleanser
The Cleanser transform utilizes a variety of expressions and triggers to correct data inconsistencies fast.
Helpful Resources