DataQualityApps produces separately available tools that assist DB personnel in the cleansing of their data; especially in the removal of duplicate entries in address tables. Among their current offerings:
- The DeduplicationWizard is a program for the deduplication of address tables. Deduplication can be done using the telephone number, the E-mail address and the postal address. When the deduplication is based on the postal address--i.e. name, street, postal code and city--the program then also considers typos, inverted words and additions. It is then a fuzzy / error-tolerant deduplication. And with the deduplication between two files, black lists can also be considered.
Features and capabilities include: Largely automated; Standard Edition includes support deduplication between two files; results of the comparison can be transformed so that the duplicate records are deleted directly in the source file, or can be saved in the form of a results or an archive file; deletion log can be used to print the results of the comparison or save them as a PDF file.
The vendor notes that not all functions described above are available in the Entry Edition (USD 149).
- DataQualityTools is a collection of tools to help businesses improve the quality of their databases. The central components are a series of functions that help to find duplicate records and, a function for error-tolerant doublet search based on postal addresses.
Features and capabilities include: Largely automated; postal address (error-tolerant matching), telephone number, E-mail address, address or customer number and tax number can all serve as matching criteria; option to compare with blacklists and the enhancement of an address database using the comparison results with data from a second address database; user-defined universal matching, that the vendor states can be used for any form of data; options for the further processing of the matching results, including direct deletion in the source file, flag results in source file, process further using a stored procedure, or duplicate-, results-, or archive-file; project history; various functions for the preparation of address- and other databases, such as case correction, a function to replace terms, and a function to delete individual records systematically; more.
The vendor notes that not all functions described above are available in the Professional Edition, which has pricing starting at $498.