Data Quality Components for SQL Server Integration Services SSIS

Easily cleanse, update and consolidate contact data within SSIS

“Melissa Data has leveraged the extensibility of the SSIS platform to create components that support Data Quality and master data management (MDM) including the address verification that Melissa Data is known for.”

- Denise Draper, Microsoft unit manager for SSIS

Easy to use and intuitive interface with drag/drop capabilities

Broad connectivity to any type of data

De-duplicate and cleanse inconsistent and redundant data

Validate, standardize and correct name, address, e-mail and telephone data

Deliver data quality routines without writing any code or programming hassles

Free technical support included. Details here

Capabilities

Quick Start

Requirements

Resources

Contact Verify Component

Standardize, verify, and correct U.S. and Canadian addresses
Verify and normalize U.S. and Canadian phones on a 7-10 digit level
Parse names, genderize, and detect suspicious words or companies in name field
Geocode addresses by assigning rooftop lat/long coordinates*

Personator Component*

Verifies name corresponds to address, email, and phone data
Appends missing name and company name, phone number, and/or email address

Global Verify Component*

Verifies international addresses for over 240 countries. List of supported countries
Transliterates many major character sets and displays output in either native or Roman characters
Geocodes international postal addresses by adding a latitude-longitude coordinate. List of supported countries

SmartMover Component*

U.S./Canadian change of address processing to update addresses of people or businesses that have moved

MatchUp Component*

Identify duplicate records with domain specific knowledge of contact information
Perform Fuzzy Matching using over 16 different Matching Algorithms
Automated and Intelligent Golden Record Selection through the Data Quality Score and other Algorithms
List Suppression and Intersection

Fuzzy Match Component*

Link related records with a toolbox of fuzzy algorithms and match thresholds
Perform Fuzzy Matching using over 16 different Matching Algorithms
Automated and Intelligent Golden Record Selection through the Data Quality Score and other Algorithms
List Suppression and Intersection

* Additional subscription required

Data Sheet
Quick Start Guide

System Requirements
Data Quality Components for SSIS are 32/64 bit tools available for Windows XP/2003/2008/Vista/7 and Microsoft SQL Server 2005/2008/2012

Minimum Requirements (Not Recommended)

32-Bit Windows XP/2003/2008/Vista/7
Microsoft SQL Server 2005/2008/2012
6 GB hard-disk space

Recommended Requirements

64-Bit Windows XP/2003/2008/Vista/7
Microsoft SQL Server 2008 R2
Microsoft SQL Server 2012
6 GB hard-disk space

Webinars

Content Verify Component
Learn how to parse, validate, correct and geocode contact information, including U.S. and Canadian addresses, phone numbers, email addresses and full names.

Fuzzy Matching Fundamentals
Got duplicate records? Learn how to use multiple fuzzy matching algorithms to link and merge related records within or across datasets with the Fuzzy Matching Component for SQL Server Integration Services (SSIS). This tutorial will show you how to easily set up the tool and view its features and functionality.

General Overview
A discussion of common issues in data quality and how these problems can be addressed using Melissa Data components for SQL Server Integration Services (SSIS).

Whitepapers

Six Steps to Managing Data Quality with SQL Server Integration Services Global Address Data Integration to SSIS: Using Melissa Data's Global Verify Component

Webinars

Contact Verify Component
Fuzzy Matching Fundamentals
General Overview

Case Studies

Cal Optima
Northern Ontario School of Medicine
SMARTech Corp.