Melissa Data Adds Data Quality for SQL SSIS to Optimize Data Management

By CIOReview | Tuesday, October 27, 2015

RANCHO SANTA MARGARITA, CA: Adding a new feature of full spectrum data quality to its Data Quality Components for SQL Server Integrations Services (SSIS), Melissa Data now offers a comprehensive suite of data transformations for Microsoft SSIS. It will enable database administrators to manage, protect, and unify data into a single version for Master Data Management (MDM).

Melissa’s Data Quality Components for SSIS deliver data quality including data profiling, verification, enrichment, and matching. It helps to verify, standardize, and format data from more than 240 countries and delivers data quality routines without coding or programming. Moreover, it offers to clean, consolidate and complete data for analytics, Big Data, data warehousing and MDM. It also helps in solving the problem of parsing addresses by de duplicating and consolidating data.

The new features in the Data Quality Components for SSIS include the Profiler Transform that identifies problems and weaknesses along with customer data as the first step followed by which Contact Verify, Global Verify, Personator and SmartMover Transform work together to prevent fraud and correct customer data for accuracy and reliability. It also features personator demographics, IP locator, and property transforms that provide greater insights to customer 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," says Bud Walker, VP, Sales and Strategy, Melissa Data.