RESEARCH & RESOURCES

Melissa Data Enables Full Spectrum Global Data Quality for SQL Server Integration Services

Comprehensive data quality toolkit optimizes master data management, reducing costs, and protecting customer data quality over time.

Note: TDWI’s editors carefully choose vendor-issued press releases about new or upgraded products and services. We have edited and/or condensed this release to highlight key features but make no claims as to the accuracy of the vendor's statements. 

Melissa Data, a leading provider of global contact data quality and integration solutions, today announced full spectrum data quality in its Data Quality Components for SQL Server Integration Services (SSIS). Offering a comprehensive suite of data transformations for Microsoft SSIS, Data Quality Components for SSIS supports the entire data quality life cycle for a global customer base, handling data profiling, verification, enrichment, and matching.

By assuring data quality from the point of entry into the system and as data is used for ongoing business processes, the toolkit enables database administrators (DBAs) and SSIS developers to manage, protect, and unify data into a single version of the truth for master data management (MDM) success.

As a flexible, all-in-one solution, Data Quality Components for SSIS enables data quality operations such as verifying U.S. and international addresses for more than 240 countries; adding rooftop latitude and longitude coordinates to addresses; preventing fraud with identity verification; and cleansing worldwide names, e-mail addresses, and telephone data. The toolkit also de-duplicates and consolidates international data by solving the challenge of parsing addresses worldwide, a complex process that recognizes vast differences in international customer data fields and how they are input to a data warehouse.

"Up to 94 percent of businesses recognize their customer data may be inaccurate, a result of not only data entry errors but also good data that has gone stale at a rate of 2 percent of customer records each month. This is a real threat to data warehousing and business intelligence initiatives, affecting the accuracy and usefulness of data used for communications, analytics, and compliance," said Bud Walker, vice president of enterprise sales and strategy at Melissa Data. "To reduce waste, drive revenue, improve business decisions, and stay in touch with your best customers, it's essential to implement an end-to-end approach -- profiling data to identify weaknesses and cleaning, enriching, and matching information to assure data is kept clean over time."

Data Quality Components for SSIS recognizes that data is coming from a greater number of real-time sources such as social media and e-commerce and features custom data cleansing transforms to cleanse, update, consolidate, and continuously enrich contact data. The Profiler Transform identifies problems and weaknesses with customer data as a critical first step; Contact Verify, Global Verify, Personator, and SmartMover Transforms work together to verify identity to prevent fraud and correct and standardize customer data to ensure it is accurate, reliable, up-to-date, and complete.

Personator Demographics, IP Locator and Property Transforms enable greater insight into customer data, providing more detailed information that improves the ability to contact customers most effectively. The MatchUp Transform flags duplicate records using powerful fuzzy matching algorithms; duplicates can be eliminated and the system identifies and retains the best overall record to ensure a single, accurate view of each customer.

Additional information is available at www.MelissaData.com.

TDWI Membership

Get immediate access to training discounts, video library, BI Teams, Skills, Budget Report, and more

Individual, Student, & Team memberships available.