Address Verification and Data Scrubbing Powered by Melissa Data

People move, email domains change, phone area codes split, data entry personnel make mistakes, and the data coming in to your essential systems can already be wrong. $6 Billion was wasted in the US on data quality issues in 2008 alone.

Invalid addresses, phone numbers, and emails can negatively impact your business with everything from failed deliveries to failed marketing programs and poor customer service.  Address Verification powered by Melissa Data helps you verify that your customer, vendor, and supplier addresses, phone numbers, and email addresses are valid and correct by checking each one against a huge database of information.

Vast databases of information from institutions like USPS, Canada Post, Dun & Bradstreet, Advo, Experion, Verizon, etc. give the latest up-to-date information allowing address validation clear to the delivery point. Connecting to this validation service is as simple as running an install.

Data Quality Firewall

Pervasive creates a barrier that makes certain that data is clean, addresses, phone numbers, and emails are all valid, before it allows the data to enter your database.

Address verification all the way to the delivery point

Licensed tables from institutions like USPS, Canada Post, Dun & Bradstreet, Advo, Experion, Verizon, etc. give the latest up-to-date information allowing address validation clear to the delivery point.    Connecting to this validation service is as simple as running an install.

Data Scrubbing for Phone Numbers, Email Addresses, etc.

Licensed tables from institutions like USPS, Canada Post, Dun & Bradstreet, Advo, Experion, Verizon, etc. give the latest up-to-date verification of phone numbers, email addresses and other vital contact information. Connecting to this validation service is as simple as running an install.

Know your data challenges

Pervasive Data Profiler™ enables you to quickly and easily:

• Isolate irregularities
• Quantify business rules violations
• Identify null sets or values
• Ensure data compliance with 100% testing of data

Pervasive Data Profiler delivers:

• Parallel execution with automatic scaling across multiple CPUs making it lightning fast (based on cutting-edge Pervasive DataRush™ technology)
• Actionable, at-a-glance charts backed by drill-down analysis with percentages of success rate and specific counts
• Detailed views of Pass and Fail for files and equal range binning
• Statistical metrics such as mode, median, standard deviation and variance presented in a report that can be easily manipulated by other applications via XML

Pervasive Data Profiler™ was selected as Product of the Year for Data Quality in SearchDataManagement.com’s 2008 Product of the Year program.

See also Data Quality Assessment and Governance.

Data Remediation

As part of an integration process flow, Pervasive Data Profiler can split incoming data into passed and failed records based on any single or multiple data quality criteria you establish, whether it's business logic such as "only customers with over $100K/year income," or data logic like "only records with valid transaction dates." Passed records can immediately be loaded into your system.

Records that fail any or all of your criteria can simultaneously be remediated.You establish the data remediation rules necessary - such as "delete duplicates" or "insert a default value in required fields that are blank" - to improve data quality and make that data usable. Any records that can't  automatically be repaired can be sent to a reject file for human intervention.

Address Verification, Data Scrubbing, and Other Data Quality Resources