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
Request Demo

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:

SQL Server Data Quality - Profiler - United Kingdom

Data Profiling

Profiler 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

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 - Global Verify - United Kingdom

eIDV Profile Check

Global Verify 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

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 - Personator World - United Kingdom

Identity Verification

Personator World 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 - MatchUp - United Kingdom

MatchUp

MatchUp 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

Data Deduplication

Fuzzy Matching 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

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 - Business Coder - United Kingdom

Firmographic Data Enrichment

Business Coder provides detailed firmographic data on over 6 million UK businesses – ideal for standardising business entities, consolidating records and lead scoring.

SQL Server Data Quality - Cleanser - United Kingdom

Data Cleanse

Cleanser utilises a variety of expressions and triggers to quickly correct data inconsistencies.


Request a Demonstration

A demonstration with one of our representatives gives you a first-hand look at our products in action. Request one today.

Request Demo Now

Helpful Resources

Video

Data Quality for SSIS Video

Watch Video
Webinar

Fundamentals of SSIS Contact Data Cleansing

Watch Webinar
Brochure

Data Quality for SSIS Brochure

Read Now