Need to verify US address with zipcode

Infosphere's Quality Product

Moderators: chulett, rschirm

Post Reply
spuli
Participant
Posts: 40
Joined: Thu Apr 09, 2015 12:13 pm

Need to verify US address with zipcode

Post by spuli »

Hi All,

I have some data in a dimension table which contains address fields like Address lin1, address line 2, state, city, zip code and zip code extension.

All the addresses are US based addresses.

I have to validate all these addresses and identify which are invalid.

Is there any webservice to validate the address? I can not use WAVES stage since WAVES DB is not purchased by our client.

I am looking forward to your valuable inputs.

Thanks in advance.
Thanks,
Sai
chulett
Charter Member
Charter Member
Posts: 43085
Joined: Tue Nov 12, 2002 4:34 pm
Location: Denver, CO

Post by chulett »

So, help me out here. You say your client did not purchase the "WAVES DB", by that do you mean they did not purchase QualityStage?
-craig

"You can never have too many knives" -- Logan Nine Fingers
asorrell
Posts: 1707
Joined: Fri Apr 04, 2003 2:00 pm
Location: Colleyville, Texas

Post by asorrell »

WAVES (Worldwide Address Verification and Enhancement System) is really intended for International address validation.

The CASS stage is typically used for USA address validation and works with the database that is certified, provided and licensed by the U.S. Postal Service. In both cases the databases involved are chargeable because its expensive to keep the databases updated with new addresses. I know CASS won't let you use an out-of-date database, it requires quarterly, licensed updates to function.

There are web-based applications like SmartyStreets that provide external API's, but those are also chargeable, and process addresses much slower due to the inherent internet latency. They might be good for very low volumes, but you'll have to build the interface yourself (which also has a cost attached to it).

I'm not aware of any "free" alternatives that are reputable, high performance and dependable.
Andy Sorrell
Certified DataStage Consultant
IBM Analytics Champion 2009 - 2020
chulett
Charter Member
Charter Member
Posts: 43085
Joined: Tue Nov 12, 2002 4:34 pm
Location: Denver, CO

Post by chulett »

Thanks Andy. My two second search for "WAVES DB" only turned up Oceanography sites, that or sites about sound wave and decibels or women in the Naval Reserve during WW2. :wink:
-craig

"You can never have too many knives" -- Logan Nine Fingers
rjdickson
Participant
Posts: 378
Joined: Mon Jun 16, 2003 5:28 am
Location: Chicago, USA
Contact:

Post by rjdickson »

Hi all,


WAVES functionality was replaced by Address Verification Interface (AVI). It does international address validation (240+ countries/territories) , and is subscription based.
Regards,
Robert
asorrell
Posts: 1707
Joined: Fri Apr 04, 2003 2:00 pm
Location: Colleyville, Texas

Post by asorrell »

WAVES functionality was replaced by Address Verification Interface (AVI)
I understand, but he indicated that he was on Rev 8, so I figured he'd still have to get WAVES for that release
Andy Sorrell
Certified DataStage Consultant
IBM Analytics Champion 2009 - 2020
rjdickson
Participant
Posts: 378
Joined: Mon Jun 16, 2003 5:28 am
Location: Chicago, USA
Contact:

Post by rjdickson »

Good point!. But WAVES went 'out of service' back in 2011... (http://www-01.ibm.com/software/support/ ... 2X64600D42)
Regards,
Robert
qt_ky
Premium Member
Premium Member
Posts: 2895
Joined: Wed Aug 03, 2011 6:16 am
Location: USA

Post by qt_ky »

To validate US address only you would need a QualityStage license, and licenses for either the IBM InfoSphere QualityStage Module for U.S. Address Certification or the IBM InfoSphere QualityStage Address Verification Interface.

The USAC subscription updates are provided monthly. The USAC subscription is good for US addresses only.

The AVI subscription updates are provided quarterly. The AVI data subscription can be licensed for all of North America or a broader set of countries/continents.

With those licenses you could validate US address records using DataStage and QualityStage jobs.

If you also want to provide address the validation logic via a web service to other parts of your organization, then you would need an Information Services Director license as well.
Choose a job you love, and you will never have to work a day in your life. - Confucius
Post Reply