Siebel Data Quality Administration Guide > Overview of Data Quality > Data Quality Products for Data Matching and Data Cleansing >

Oracle Data Quality Address Validation Server

The Oracle Data Quality Address Validation Server is an address standardization application that provides capabilities to parse, standardize, transliterate, duplicate, and validate address data, resulting in improved address data quality. The validation capability requires the licensing of appropriate postal directories for the countries where address validation is required.

The Oracle Data Quality Address Validation Server uses a licensed version of the third-party software, Informatica Identity Resolution, for data cleansing.

Features of Oracle Data Quality Address Validation Server are:

• Integrated single API supporting all countries:

  Oracle Data Quality Address Validation Server lets you use a single API for all countries, so that you can start working immediately and add countries without the need for additional programming. The API is compatible with all major programming languages.

• Advanced validation, and correction of worldwide postal addresses, including address coverage for more than 240 countries:

  Oracle Data Quality Address Validation Server matches and corrects all address data, filters out superfluous information, assesses deliverability, and generates a detailed report with suggestions for possible sources of address problems.

• Parsing and standardization:

  Oracle Data Quality Address Validation Server parses both structured and unstructured data, identifies residues, and formats and standardizes the data (without the need for payment of special data license fees).

• Convenient updating:

  Postal reference tables in many countries change frequently. Oracle Data Quality Address Validation Server has arrangements with many local postal organizations (including Informatica Address Doctor) that allows you to receive monthly, quarterly, or biannual updates. Reference tables for each country are provided in a separate, operating system-independent database that is easy to update from a CD, DVD, or by downloading over the Internet.

The Universal Connector is integrated with the Oracle Data Quality Address Validation Server for data cleansing.

About Using the Oracle Data Quality Address Validation Server

You can use the Oracle Data Quality Address Validation Server to cleanse data on account, contact, and prospect data from the UI in your Siebel application, or by running a batch job in Siebel CRM. You can also cleanse the data in EAI mode by sending in the address data in Simple Object Access Protocol (SOAP) format.

When you enter a new address using the contact or account screen in your Siebel application, all address data is validated, cleansed, and standardized before being committed to the Siebel database. If the address cannot be validated, then the address is standardized by using the Upper, Lower, or Camel case (depending on Oracle Data Quality Address Validation Server configuration). In addition, the account name, contact name, and other attributes are standardized.

When new contacts, accounts, or addresses are entered into Siebel CRM through a batch job, address standardization is applied before committing any records to the Siebel database.

In all cases: 

• The Oracle Data Quality Address Validation Server evaluates and modifies the record according to configuration.

  Oracle Data Quality Address Validation Server returns an address validation flag and the validation status.

• The Siebel database is then updated with the cleansed data, which has been formatted and standardized with address validation.
• In the Siebel application, the updated cleansed record is displayed on the UI.

For more information about Oracle Data Quality Address Validation Server installation and configuration, see Process of Installing the Oracle Data Quality Address Validation Server and Configuring Siebel Business Applications for the Oracle Data Quality Address Validation Server.

For more information about Informatica Identity Resolution, see the relevant documentation included in Siebel Business Applications Third-Party Bookshelf in the product media pack on Oracle Software Delivery Cloud.