Melissa Data, a developer of high performance data quality and address management solutions, today announced their new Data Quality Components for Microsoft’s SQL Server Integration Services (SSIS). This suite of custom data transformations delivers the industry-recognized criteria for complete Data Quality, including Data Profiling, Cleansing, Parsing, Standardization, Matching, and Monitoring. The tools aim to help IT professionals integrate increasingly complex enterprise data – in different formats, structures and sources - and deliver a single view of critical information assets.
Previously, implementing Master Data Management (MDM) or Data Quality initiatives involved extensive manual coding efforts or the need to purchase expensive data integration tools. Now, with Data Quality Components for SSIS, users can build their own toolkit at a very reasonable price to get exactly the functionality needed for the project.
Data Quality Components for SSIS comprises three sets of transforms:
Data Profiling and Monitoring: Identifies data quality issues that require immediate attention and corrects issues before quality of data declines.
Data Enrichment and Verification: Verifies contact data including: addresses, phone numbers, and email addresses, geocoding (spatial processing); and parses/genderizes names and detects vulgarities.
Data Matching and Cleansing: Corrects data values to meet specific business rules and standards, then consolidates customer records into identifiable groups and merges related records.
Demonstration videos and free trials of all SSIS components are available at: http://www.melissadata.com/dqt/data-quality-components-for-ssis.htm