CLEAN_Address®

Global Address Verification For Oracle® Database

CLEAN_Address is a development component for easily verifying and standardizing U.S., Canadian, and global addresses for over 240 countries and territories through Oracle database applications.

It validates and standardizes addresses, emails, phone numbers, and names in real-time or batch using a simple PL/SQL procedure call. This saves data entry time, protects against fraud, reduces costs of re-shipping, and allows duplicate address detection.

Designed specifically for Oracle databases, CLEAN_Address easily integrates into any Oracle platform with natively compiled daemon code for Windows, Linux, Solaris, AIX, & HP-UX.

Benefits:

  • Verify addresses for every country in the world (Web service option)
  • Easiest address verification product to integrate into Oracle database applications
  • Complete solution for all entry points: Client-Server; Web site; and batch processing
  • Subscription services keep postal data up-to-date on bimonthly, monthly, and/or quarterly terms
  • Hassle-free - no client software to install

Features:

  • Integrated batch processing in the database without exporting/importing
  • Customizable business rules and data standards
  • Address errors are recorded in the database for easy reporting
  • Telephone number checking in real-time and batch
  • Enterprise Service Oriented Architecture (SOA) - one installation serves all databases
  • Free unlimited technical support. Learn more.
  • Available within Oracle's JD Edwards EnterpriseOne, E-Business Suite, and PeopleSoft Enterprise systems

CLEAN_Address  Verify and Standize Data

Global Address Verification and Standardization

  • Verifies and standardizes Company, Street, City, State, Postal Code, ZIP+4™, County, MSA, and more.

Name Parsing and Genderizing

  • Parses names into 5 components (Prefix, Suffix, First, Middle, Last) and appends a gender code.

Telephone Area Code and Prefix

  • Verifies and updates area codes based on the ZIP Code and corrects split area codes and data entry errors.

Email Address Parsing and Verification

  • Checks syntax, parses email address, and validates domain names

Geocoding

  • Returns latitude and longitude for U.S. addresses

CLEAN_Address was designed specifically for Oracle databases and is easily integrated into several development platforms, including:

  • The Web
  • Oracle Forms
  • PL/SQL
  • C++
  • Visual Basic
  • Java/JSP
  • Oracle Warehouse Builder (OWB)

There are also pre-built interfaces for Banner, Advance, Oracle Applications, and PeopleSoft.

CLEAN_Address® For Oracle E-Business Suite
Verify, correct, and standardize, global addresses at point-of-entry or batch with multiplatform API. Geocodes & more.

CLEAN_Address For Oracle's JD Edwards EnterpriseOne
Reduce returned mail by 99% with verified and corrected address data in real time with global capabilities, geocoding, and more.

CLEAN_Address For Oracle's PeopleSoft Enterprise
Save keystrokes with real-time, auto-completion global address correction & validation (API or batch) with geocoding capabilities.

CLEAN Address is a development component for easily verifying and standardizing U.S., Canadian and global addresses for over 240 countries and territories through Oracle database applications. Upload a sample of your data for a free analysis