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
We appreciated the extensive functionality provided in the out-of-the-box version. Osvaldo Cruz @ Cal Optima

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

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

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

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

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

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

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

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

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

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

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

Cleanser

The Cleanser transform utilizes a variety of expressions and triggers to correct data inconsistencies fast.


Helpful Resources

Video

Data Quality for SSIS Video

Watch Video
Blue Print Product Sheet

Blueprint for Banking Success

Read Now
Brochure

Data Quality for SSIS Brochure

Read Now
Ready to Start Your Demo?

Start today with Melissa's wide range of Data Quality Solutions, Tools, and Support.

Schedule a Demo