“Name, Address, GeoCoder, Phone and Email verification components or transforms are all put into action as each individual data upload is scrubbed and merged into a single, uniform data set – creating a single anchor record per individual from which our customers operate multi-million- record mass communications strategies.”

- Jeff Averbeck, Chief Executive Officer, SMARTech

Enterprise data quality in a single, affordable platform

Features and Benefits
    • Delivers a single view of the customer
    • Supports data quality and MDM initiatives
    • Leverages MS SSIS to profile, cleanse and integrate critical information assets
    • Easy-to-use GUI
    • Lowest cost of ownership

Delivering the Full Spectrum of Data Quality
TDQ-IT leverages the power of Microsoft’s SQL Server Integrations Services (SSIS 2005/2008) to deliver the full spectrum of data quality processes as defined by industry analysts including:
 

Data Profiling Operates as the first line of defense to identify data quality issues that require immediate attention and avoid unnecessary processing of unacceptable data. Generalized Cleansing Corrects data values to meet specific business standards, customer business rules, or relationship constraints. Parsing and Standardization Parsing and restructuring data into a common format helps build more consistent data, for instance, standardizing addresses to USPS® specifications, or to custom-defined values and patterns specific to a particular business need. Matching Sophisticated matching technology consolidates customer records into identifiable groups, and links or merges related records within or across disparate datasets. Enrichment Adds value to customer data by attaching additional bits of data from other sources including; latitude/longitude coordinates; demographic data; full name parsing; phone number verification; and email validation. Monitoring Real-time monitoring puts into place automated processes to detect when data exceeds pre-set limits so you can immediately recognize and correct issues before the quality of your data declines.

Support for Master Data Management Initiatives
TDQ-IT also supports Master Data Management (MDM) processes including:
 

Identification Identifies, matches, and links customer information across heterogeneous data sources to create the best possible view of a customer. Central System of Record Leverages the combination of Melissa Data tools in conjunction with SQL Server data and application integration capabilities to integrate with a wide variety of data sources to deliver a Central System of Record. Single Customer View Utilizes a Central System of Record to consolidate data sources into a single customer view, or master reference file, and provides data to existing sources (via Microsoft real time, batch or SOA) to ensure accurate, consistent data across the enterprise. Data Quality Compliance Provides real-time monitoring and corrective-action techniques, including cleansing, address correction, validation and standardization to support data quality compliance.

System Requirements
    • Microsoft SQL Server 2005-2008 – any edition
    • .Net Framework 3.5
    • Windows XP SP2, Windows Server 2003 and Vista (Business or Home) 32/64-bit