Directions Magazine
Hello. Login | Register

Press Releases

Home | Submit Press Release

Melissa Data’s MatchUp for SQL Server Solves

Bookmark and Share
Thursday, May 8th 2014


Duplicate Customer Records for Data Integrators

Powerful Data Quality Tool Consolidates Duplicates into Single Golden Record; Objective Data Quality Score Uniquely Determines Most Accurate Customer Information

Rancho Santa Margarita, CALIF – May 8, 2014 – Melissa Data, a leading provider of contact data quality and integration solutions, today announced its TechEd 2014 exhibit will feature new matching and de-duplication functionality in the company’s MatchUp Component for SQL Server Integration Services (SSIS). Based on proprietary logic from Melissa Data, MatchUp consolidates duplicate customer records objectively, unlike any other data quality solution. Uniquely assessing the quality of individual data fields, MatchUp determines the best pieces of data to retain versus what to discard – enabling a smart, consistent method for data integrators to determine the best customer contact information in every field.

“A single, accurate view of the customer, known as the golden record, is the ideal for any business relying on customer data – reducing waste, optimizing marketing outreach and improving customer service. Yet common methods for matching and eliminating duplicate customer records involve subjective rules that don’t consider the accuracy of the data itself,” said Bud Walker, director of data quality solutions at Melissa Data. “MatchUp’s intelligent rules offer a smarter, more consistent method for determining what information survives in the database and why. It’s a critical data quality function that dramatically improves business operations.”

MatchUp assesses the content within the customer record,  in contrast to matching and de-duplication methods that rely solely on subjective principles, such as whether the record is the most recent, most complete or most frequent. Instead, selection criteria for determining a golden record is based on a relevant data quality score, derived from the validity of customer information such as addresses, phone numbers, emails and names.

Once the golden record is identified intelligently, MatchUp further references the data quality score during survivorship processes to support creation of an even better golden record; duplicate entries are then collapsed into a single customer record while retaining any additional information that may also be accurate and applicable. MatchUp relies on deep domain knowledge of names and addresses for survivorship operations, used to granularly identify matches between names and nicknames, street/alias addresses, companies, cities, states, postal codes, phones, emails, and other contact data components.

MatchUp is part of Melissa Data’s Data Quality Components for SQL Server Integration Services (SSIS), a suite of custom data cleansing transformation components for Microsoft SSIS, used to standardize, verify, correct, consolidate and update contact data for the most effective business communications. The suite further includes selected Community Editions for simple data quality procedures, free to developers and downloadable with no license required. Community Editions include Contact Verify CE for address, phone and name parsing, and email syntax correction; MatchUp CE provides simple matching and de-duplication without advanced survivorship operations, for up to 50,000 records using nine basic matchcodes.

Melissa Data will be demonstrating its MatchUp Component for SSIS at booth #1934 during Microsoft TechEd, May 12-15, 2014 at the George R. Brown Convention Center in Houston, TX. To download a free trial of Melissa Data’s MatchUp Component for SSIS, click here; to request access to Melissa Data’s free Community Editions, click here or call 1-800-MELISSA (635-4772).

About Melissa Data

Since 1985, Melissa Data has specialized in contact data quality and address management tools with a global perspective. The company’s solutions help organizations effectively capture and maintain international customer contact data at the point of entry, ensuring accurate customer information across the enterprise. More than 5,000 clients worldwide in arenas such as retail, education, healthcare, insurance, finance, government and other sectors, rely on Melissa Data for a full spectrum of data validation software and services. Melissa Data’s international operations readily enable access to local sales and support, including offices in the US, Europe and India. For more information or free product trials, visit www.MelissaData.com or call 1-800-MELISSA (635-4772). Follow Melissa Data on Twitter, Facebook, LinkedIn and YouTube.

#  #  #

Jackie Zerbst

MPowered Public Relations

pr@mpoweredpr.com

(714) 998-3448

Greg Brown

Vice President, Marketing

Greg@MelissaData.com

(800) 635-4772 x130

Bookmark and Share

Stay Connected

Twitter RSS Facebook LinkedIn Delicious Apple Devices Android Blackberry






Recent Comments

Apple, Sensors and Geodata Overload

What will we do with all of the Apple sensors: NFC, HealthKit, HomeKit, LED Sensors, barometers. Will they portend the beginning of yet another big data assault that will impact geospatial professionals? Will they catapult the “connected home” or “quantified self” craze? How will we use these data? Will standards be part of the adoption and who will own them?

Redefining Geospatial Data Versioning: The GeoGig Approach
Understanding Geographic Relationships: Counties, Places, Tracts and More
ASU alum’s mapping project a finalist in Google Impact Challenge
Maptitude Mapping Software 2014 Review
Do Everyday Maps Meet Your Expectations?
Observing Earth Today and Tomorrow: A National Plan
Taking NASA-USGS’s Landsat 8 to the Beach
StackMaps: mapping user needs

DirectionsMag.com

About Us | Advertise | Contact Us | Web Terms & Conditions | Privacy Policy
© 2014 Directions Media. All Rights Reserved