Case Study: SMARTech Corp. achieves a single consolidated customer view and stable ETL with Melissa Data’s DQC

SMARTech Integrates Enterprise Data Quality Platform to Consolidate Data Sets

SMARTech Corp., a provider of hosting, network services and Internet applications, needed to consolidate disparate customer data into a single, accurate master view to support its smartCommunicator portal. After struggling with a previous vendor’s unstable ownership, limited support and difficult integration, SMARTech selected Melissa and implemented Melissa Data’s Data Quality Components for SSIS (DQC) to provide integrated profiling, parsing, cleansing, matching and verification within their ETL processes.

Melissa’s DQC was embedded as the hub of the smartData import tool, running name, address, geocode, phone and email verification transforms inside SSIS to clean, standardize, enhance and deduplicate records into a single anchor record per individual. The solution stabilized and accelerated ETL, reduced training and support overhead, enabled multi‑million‑record campaigns (smartMailer can send up to 5 million emails per hour) with improved deliverability, and delivered measurable benefits including about a 95% deliverability rate and a consolidated, single view of the customer.

SMARTech Corp.

Jeff Averbeck

CEO