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 SQL Server Data Quality to provide a full spectrum of data quality with the following:
![SQL Server Data Quality - Data Profiling - United Kingdom SQL Server Data Quality - Data Profiling - United Kingdom](/images17/sql-server-data-profiler.png)
Data Profiling
Data Profiling 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 - United Kingdom SQL Server Data Quality - Contact Verify - United Kingdom](/images17/sql-server-contact-data-verify.png)
Contact Verify
Contact Verify can validate, correct and standardise domestic and international addresses, email addresses, and phone numbers and converts UK addresses to roof-top latitude/longitude coordinates.
![SQL Server Data Quality - eIDV Profile Check - United Kingdom SQL Server Data Quality - eIDV Profile Check - United Kingdom](/images17/sql-server-global-verify.png)
eIDV Profile Check
eIDV Profile Check can validate, correct and standardises postal addresses, email addresses, and phone numbers for 240+ countries, plus converts street addresses to precise latitude/longitude coordinates.
![SQL Server Data Quality - Personator - United Kingdom SQL Server Data Quality - Personator - United Kingdom](/images17/sql-server-personator.png)
Personator
Personator 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 - Identity Verification - United Kingdom SQL Server Data Quality - Identity Verification - United Kingdom](/images17/sql-server-personator-world.png)
Identity Verification
Identity Verification verifies an individual’s national ID, provides age verification, and performs watchlist/sanctions screening for fraud prevention and KYC/AML compliance.
![SQL Server Data Quality - Data Deduplication - United Kingdom SQL Server Data Quality - Data Deduplication - United Kingdom](/images17/sql-server-fuzzy-matching.png)
Data Deduplication
Data Deduplication provides advanced deduping/matching capabilities and survivorship rules to eliminate duplicates and create a single customer view.
![SQL Server Data Quality - Fuzzy Matching - United Kingdom SQL Server Data Quality - Fuzzy Matching - United Kingdom](/images17/sql-server-fuzzy-match.png)
Fuzzy Matching
Data Deduplication 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 - United Kingdom SQL Server Data Quality - IP Locator - United Kingdom](/images17/sql-server-ip-locator.png)
IP Locator
IP Locator geolocates a given IP address and returns latitude/longitude, city, state, postal code, county and ISP information.
![SQL Server Data Quality - Firmographic Data Enrichment - United Kingdom SQL Server Data Quality - Firmographic Data Enrichment - United Kingdom](/images17/sql-server-firmographic-data.png)
Firmographic Data Enrichment
Firmographic Data Enrichment provides detailed firmographic data on over 6 million UK businesses – ideal for standardising business entities, consolidating records and lead scoring.
![SQL Server Data Quality - Data Cleanse - United Kingdom SQL Server Data Quality - Data Cleanse - United Kingdom](/images17/sql-server-data-cleansing.png)
Data Cleanse
Data Cleanse utilises a variety of expressions and triggers to quickly correct data inconsistencies.
Helpful Resources