Dashboard > DATA QUALITY SERVICE GUIDES > DATA QUALITY SERVICE GUIDES > StrikeIron US Address Verification
  DATA QUALITY SERVICE GUIDES Log In | Sign Up   View a printable version of the current page.  
  StrikeIron US Address Verification
Added by Alex Khizhnyak, last edited by Alex Khizhnyak on Apr 30, 2008  (view change)
Labels: 
(None)

The StrikeIron U.S. Address Verification Web Service uses the United States Postal Service certified technology and the USPS to verify, correct, and enhance any address in the U.S. with live data provided by DataFlux. This service corrects addresses, adds ZIP+4 data, gives congressional districts, carrier routes, and much more. The following guide will help you learn how to access and configure this feature using Apatar.

To start validating US addresses using StrikeIron US Address Verification Web service,

  1. Drag-and-drop the StrikeIron US Address Verification node to Apatar's work panel.
  2. Drag-and-drop and configure the source connector related to a database you want to extract addresses from.
  3. You also need two more connectors for output data. The former one will contain the records with valid or corrected addresses, while the latter one will contain the records with unvalidated addresses. Configure them, as well.



  4. If the names of the fields differ in the source and output tables, place two Transform operations between the StrikeIron US Address Verification node and the output connectors.



  5. Map the connectors according to the picture bellow.



  6. Double-click on the StrikeIron US Address Verification node to configure it.



  7. Provide your StrikeIron Web Services authentication details.
  8. After that, StrikeIron US Address Verification work panel should occur. Drag-and-drop the field(-s) containing addresses to the work panel. Map it with the Verify US Address function.



    Note that if you place the cursor over the StrikeIron node's connection points, you will get tooltips with hints on what data should be mapped here.

    You can use one of the functions in the right column, either Verify US Address, or Verify US Address (StrikeIron Format). StrikeIron's format requires City, State, and ZIP fields to be concatenated into one, with a single space between the fields.



  9. Click Ok.
  10. To save your money and not waste it on the same addresses again and again, Apatar uses temporary storage containing the results of each validation. You can also adjust the life time of this accessory database. To do so, clik the Clear Addresses button and set the necessary frequence of the storage updates.



  11. Finally, configure the Transform nodes preceding the output connectors.

Now you can launch the transformation.

Site running on a free Atlassian Confluence Open Source Project License granted to Apatar Data Integration (ETL). Evaluate Confluence today.
Contact Administrators