User and Developer Guide

User and Developer Guide

Data Quality Service Example Overview

Data Quality Service Example Overview

Your organization needs to generate a validated, formatted mailing address for customer records. You inform a data quality developer about the types of information you require in the input and output records.
You inform the developer that you will provide the following input data:
  • Street Address
  • Locality
  • State
  • ZIP Code
  • Country
You inform the developer that you require the output data to be validated and formatted in three address lines.
The developer creates a data quality service that analyzes addresses and produces validated and formatted data. The developer provides you with the URL for this service.
You add the service to Data Quality for Microsoft Excel and run the service against customer address data in Excel worksheets.
The data quality service in this example analyzes address data and generates formatted postal addresses that the U.S. Postal Service certifies as deliverable addresses.