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 lifecycle 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, this powerful 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 lat/long coordinates to addresses; preventing fraud with identity verification; and cleansing worldwide names, emails, 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% 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% 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, 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 ecommerce, 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 & 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 & 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.