Product Review of Melissa Data’s Data Quality Components for SSIS v3.2


Aug 10, 2012

Page: 1/7

Introduction

In this present era of information age, accurate information of customers is extremely essential for any organization to be successful. It is in this regard that Melissa Data’s Data Quality Components for SSIS becomes an essential tool. In this article I will demonstrate how easily an organization can leverage Melissa Data’s Contact Verify SSIS Component to Standardize, Verify, Correct and Normalize U.S and Canadian addresses. The usage of this Melissa Data’s Data Quality Components can help organizations save millions of dollars in a year by storing accurate customer information in their databases. Accuracy in fields like name, full address, phone, email, geocodes etc. can help organizations reach their customer on time and successfully close a business deal. Melissa Data’s Data Quality Components can be effectively used by any organization who believes in “Customer is the King”.

"This article has a total of 7 pages including this page. Click the links below to open all 7 pages in a seperate window to learn more about Melissa Data's Data Quality Components for SSIS. Page 1, Page 2, Page 3, Page 4, Page 5, Page 6, Page 7"

Product Information

Melissa Data Website Link: http://www.melissadata.com/data-quality-ssis/index.htm

Download Free Trial: Melissa Data's Data Quality Component for SSIS  

Melissa Data Product Demo: How to Use Melissa Data’s Contact Verify Data Quality Components for SSIS 

Different Data Quality Components offered by Melissa Data for SSIS

Melissa Data offers different data quality components for SSIS which are mentioned below:-

1. Contact Verify Component
2. Global Verify Component
3. SmartMover Component
4. MatchUp Component
5. Fuzzy Match Component

Let us understand each of these above mentioned Components and their capabilities:-

By Using Melissa Data’s Contact Verify Data Quality Component for SSIS an Organization can:-

  • Standardize, Verify & Correct U.S and Canadian Addresses
  • Verify & Normalize U.S. and Canadian Phones Numbers
  • Parse Names, Gender & Detect suspicious words or companies in name fields
  • Geocode addresses by assigning rooftop latitude and longitude coordinates

By Using Melissa Data’s Global Verify Data Quality Component for SSIS an organization can:-

  • Standardize, Correct, Verify, and Format addresses for 240 Countries & Territories

By Using Melissa Data’s SmartMover Data Quality Component for SSIS an organization can update:-

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

By Using Melissa Data’s MatchUp Data Quality Component for SSIS an organization can:-

  • Identify duplicate records with domain specific knowledge of contact information

By Using Melissa Data’s Fuzzy Match Data Quality Component for SSIS an organization can:-

  • Link related records with a toolbox of fuzzy algorithms and match thresholds

As mentioned earlier this article will explore Melissa Data’s Contact Verify Data Quality Component for SSIS. I would recommend readers to try out other components such as Global Verify Component, SmartMover Component, MatchUp Component and Fuzzy Match Component which are highly useful as well.

Why to Use Melissa Data’s Contact Verify Data Quality Components for SSIS?

The Contact Verify Component is a cleansing and an enrichment tool that allows one to correct addresses and verify that they are deliverable, append geographic information, parse and generalize full name, validate phone numbers, email addresses etc. The Contact Verify Component makes use of Melissa Data API’s as its driving engine and its extensive collection of reference data from different sources to give you the best results for Contact Verification. The advantage of using cleansed data comes in the form of better delivery of shipments, more satisfied customers and better Return on Investment (ROI).

Who should be Using Melissa Data’s Data Quality Components for SSIS?

MyTechMantra.com recommends this product to be used by Logistics and Shipping Industry, Postal Department, Sales and Marketing Departments of Various Companies, Health Care Industry, e-Commerce Industry, Education Sector to name a few.

Prerequisites & System Requirements for Installing Melissa Data’s Data Quality Components for SSIS v3.2 Minimum Requirements

  • 32-Bit Microsoft Windows™ Server 2003, 2008, 2008 R2, Vista, 7
  • Microsoft SQL Server 2005/2008/R2 (32-bit)/2012
  • 6 GB hard-disk space

Recommended Requirements

  • 64-Bit Microsoft Windows™ Server 2003, 2008, 2008 R2, Vista, 7
  • Microsoft SQL Server 2005/2008/R2 (64-bit)/2012
  • 6 GB hard-disk space

My Environment

I have installed Melissa Data’s Data Quality Components for SSIS v3.2 on my SQL Server 2008 (64-bit) SP3 Server running on Windows Server 2008 (64-bit).

How to Install Melissa Data’s Data Quality Components for SSIS v3.2

Installation of Melissa Data’s Data Quality Components for SSIS v3.2 requires certain steps to be followed. Click on the below link to see a step by step guide for the installation.

Step by Step Guide to Install Melissa Data's Data Quality Component for SSIS

Click on Next Page to continue reading rest of the article…

Next Page..

Continue Free Learning...

  • Please leave below your valuable feedback for this article.
  • Feel Free to refer this article to your friends and colleagues using the below “Share this Article” option.
  • Do subscriber to our News Letter to continue your free learning.
  • Don’t forget to Like Us on Facebook and do follow us on Twitter for latest updates.

Share this Article



Follow @MyTechMantra on Twitter
We're on Facebook
Bookmark and Share

"Receive newsletters and special offers about SQL Server, BizTalk and SharePoint from MyTechMantra. We respect your privacy and you can unsubscribe at any time."