Address Standardization

[S V Ramakrishna]

Hi,
I'm required to implement address standardization in my data warehouse.
Daily a SQL Server 2005 SSIS package processes a excel file which has
customers information. I'm looking for a web service which would provide
standard addresses. I really dont know if using web service is the correct
way to cleanse address data. Please help me how we can standardise addresses
before inserting them into database. Any help is highly appreciable. Also
please let me know if there is any industry standard way to achieve this.

Thanks,
RK

[Russell Fields]

RK,

There is software that you can buy that will do this for you. If you GOOGLE
for "address standardization software" you will find quite a few companies
offering APIs, services, et cetera in this area. I would suggest that you
check out some of those to determine features and prices.

We use the following product, but there are others. You can write a web
service to call the APIs for PostalSoft or you can batch the data and run it
through a batch process before inserting into your DW.
http://www.businessobjects.com/product/catalog/postalsoft_solutions/

Note: I am not recommending that you buy this product, just saying that it
works for us.

RLF

"S V Ramakrishna" <vsee...@jnetechnologies.com> wrote in message
news:OxTRBrPD...@TK2MSFTNGP05.phx.gbl...

[S V Ramakrishna]

Thank you RLF.
--
"Russell Fields" <russel...@nomail.com> wrote in message
news:uuMd1SRD...@TK2MSFTNGP06.phx.gbl...

[S V Ramakrishna]

Hi,
Daily I need to process a very large collection of customer address data. So
I'm wondering if integrating web service with SSIS package is the best way
or not. Please let me know if there are other ways of doing this.
Thanks,
RK

"S V Ramakrishna" <vsee...@jnetechnologies.com> wrote in message

news:upeuA5mD...@TK2MSFTNGP02.phx.gbl...

[Russell Fields]

RK,

Since you have a very large collection of customer addresses to standardize,
I would advise that you prepare them before importing them into your data
warehouse. The PostalSoft offering (and probably many others do as well)
has a batch engine.

I would think that the ideal is to run a collection of addresses through
your Address Standardization engine of choice, then pick up the output from
that and import it into your data warehouse. I expect that to run faster
than integrating a web service into the SSIS package. (At least, if I
understand the web service idea correctly.)

SSIS does have an Execute Process task that you could use to run a OS
command or .bat file, etc.

RLF

"S V Ramakrishna" <vsee...@jnetechnologies.com> wrote in message

news:%23UcFmNo...@TK2MSFTNGP05.phx.gbl...