Global Verify Component for SQL Server
Standardize, verify and cleanse addresses from all over the world
The Global Verify Component for SQL Services Integration Services (SSIS) provides users with the ability to capture, parse, standardize, verify, cleanse, transliterate, and format addresses for more than 240 countries and territories around the world. The component also enables a latitude-longitude coordinate to be added to international postal addresses for precise geocoding.
Benefits:
- One solution for all countries
- Ensure dependable information for ERP & CRM systems
- Reduce online fraud
- Speed deliveries for enhanced customer service
- Make searching for duplicate records easier
- Puts address in standardized mailing format for each specific country
- Supports data in any UTF8 language
- Standardizes to the local format of the country
- Add missing components such as postal codes, region etc.
- Transliteration works with many major character sets and enables output to be displayed in either native or Latin characters
- Adds a lat-long coordinate to international postal addresses
- Provides input to new location based services (LBS) applications
- Enables locations to be displayed on a map or passed to GIS or routing applications
| Input | Global Output | |
|
18 avenue de Quebec Courtaboeuf 91957 cedex France |
Street number: 18 Street name: avenue de Quebec Locality: Villebon Sur Yvette Cedex Postal code: 91957 Country: France Verification level: AV24 |
System Requirements
Data Quality Components for SSIS are 32/64 bit tools available for Windows XP/2003/2008/Vista/7 and Microsoft SQL Server 2005/2008
Minimum Requirements (Not Recommended)
- 32-Bit Windows XP/2003/2008/Vista/7
- Microsoft SQL Server 2005/2008/2012
- 6 GB hard-disk space
- 64-Bit Windows XP/2003/2008/Vista/7
- Microsoft SQL Server 2008 R2
- Microsoft SQL Server 2012
- 6 GB hard-disk space
