While Centerprise Data Integrator offers many sophisticated capabilities to enable users to integrate and manage the most complex of hierarchical data challenges, sometimes simple data integration capabilities deliver value of equal importance.
One of the more basic yet valuable features of Centerprise is its name and address parsing and cleansing functionality. Some data files do not follow specific patterns and may contain hybrid data, for instance, incoming data inconsistencies such as variations in address formats, use of abbreviations, misspellings, outdated information, or transposed names. The Centerprise Name and Address Parsing and Cleansing feature provides sophisticated name parsing, address parsing, address cleansing, and gender determination capabilities that save money on postage, virtually eliminate undeliverable addresses, and save manual keying time.
Name Parsing and Gender Determination
The Centerprise integrated name component accepts free-form names and automatically splits them into standard components such as Prefix, First, Middle, Last, and Suffix, no matter what the original format. It then determines gender using a built-in name dictionary. All styles of names can be processed, including inverse, natural order, hyphenated, and multi-part last names. Centerprise accurately verifies whether a particular field contains a valid individual or company. It uses an extensive, ethnically diverse first and last name dictionary in combination with an equally extensive company name dictionary to ensure precise gender determination.
The component starts by carefully inspecting the input name property, removing redundant punctuation, identifying companies and pre-conditioning the name for parsing. Next, based on the Name_Style you’ve selected, intuitive algorithms identify and parse each individual name element into the appropriate component: prefix, first, middle, last or suffix.
The gender is now determined using the built-in dictionaries and user supplements and the Name_Quality flag is set to indicate how complete and correct the name appears to be. Finally, the user-specified prefix/suffix abbreviations and capitalization preferences are applied and the standardized name components are returned to your application along with a complete composite name.
The Centerprise name component can process all styles of names including inverse, natural order, hyphenated and multi-part last names. Multiple names in the same field and companies can be easily separated, giving you powerful formatting control. It also uses a unique gender percentage factor. This factor is based on the proportion of males to females for a particular name, allowing you to set the point at which certain names will be returned with a neutral gender.
Address Parsing and Cleansing
The Centerprise address-parsing feature quickly and easily parses free-form United States addresses into individual components. The US Postal Service-compliant address lookup capability corrects, completes, and normalizes incoming addresses. The component performs all the operations locally and does not need a connection to a service. The Centerprise address parsing and cleansing architecture delivers high performance and is capable of handling large data volumes. There is no limit for data volumes or a per unit charge.
Centerprise address parsing follows the US Postal Service “one component failure rule” to find a correct address match. This rule permits an address match if no more than one address component mismatch exists. This rule permits an address match if no more than one address component mismatch exists, where a “component” is defined as a predirectional, street name, street suffix, or a postdirectional.
For example, suppose an address has all four components. If one of the components has to be added, changed, or deleted to achieve a unique match, Centerprise corrects the address and returns the ZIP+4. Under current USPS address matching rules, if more than one component is incorrect, no match is allowed. If adding, changing, or deleting a component results in multiple matches, Centerprise returns a list of all matching addresses. The priority is to add a suffix first, before adding a directional. If there is no match, then the suffix is changed or deleted. Finally, the directional is changed or deleted.
If there is no exact address match within the city, Centerprise applies the “one component failure rule” within the input ZIP Code. If there is still no match, then the “one component failure rule” is applied to all addresses within the postal finance number. If there is still no match, the address is rejected.
An array of flags is returned for each address, delivering important information about the status of the matching process such as why the matching failed or what corrections were necessary in order to achieve a match. The Address Type is also returned, allowing you to identify Street, Military, PO Box, Rural Route, Highway Contract or General Delivery addresses and process them accordingly.
Enterprise Integration for Everyone
Whether you need Centerprise to overcome the challenges of complex hierarchical structures or simply to ensure the quality of your contact data, the many features within the software provide you with the functionality you need to integrate and manage your data at a price you can afford.