DataQualityTools

Reduce advertising costs by avoiding double solicitations? Manage your addresses more efficiently through better databases, because they are free of duplicates? Take account of lists of those who do not wish to receive marketing mailings? Transfer information from an external database to your own addresses? DataQualityTools help you to optimize your data and thereby your marketing. A central component are the functions for finding duplicate records. Differences in spelling, as in the case of postal addresses, are not a problem. In the case of direct marketing, this helps you to avoid double solicitations and the redundant maintenance of customer addresses and other records. Of course, this leads to significantly savings in your expenses. But it also improves the outward image of your company. And through the consideration of opt-out lists, you can also avoid trouble with people who do not wish to receive marketing mailings. Here is a brief overview of the features of DataQualityTools: - Fast, largely automated and user-friendly deduplication functions for address databases. The postal address (error-tolerant / fuzzy matching), telephone number, email address, address or customer number and tax number can all serve as matching criteria to find and remove duplicates. - Exact hits, where every character is matched, are not the only results found: so too are near-duplicates and duplicated addresses. In this, the following are taken into account, in particular: Typos, Spelling variations, Omissions and additions, Misplaced words, Abbreviations and Pet names / nicknames. - User-defined universal matching, that can be used for any kind of data. - Option to dedupe between two tables, for example, to consider blacklists or to synchronize address lists. - Option to combine multiple tables into a single deduplication operation. - The result can be used to enrich data. For example, a telephone number from a second table could be transferred to the first table using the matching result. - Numerous options for the further processing of the matching results: in addition to deleting directly in the source table, it is also possible to flag the results in the source table, to process it further using a stored procedure, to create a duplicates file or to export the results. - A project history, which provides information about what was done when with a given project. - A deletion and results log that includes comments and your own logo, which can be saved as a PDF file, among others. - 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. - A range of functions for splitting or merging data fields, among others to split telephone numbers and email addresses. - Various summary lists, that help one gain a quick overview of an address database. - Local processing of data, no need to transfer data to an external service provider. This simplifies compliance with the General Data Protection Regulation (GDPR). - Almost any type of data source can be processed, such as Access, Excel, dBase (dbf), OpenOffice / LibreOffice Calc (ods), CSV files and text files, but also database servers such as MS SQL Server, Azure SQL, MySQL, MariaDB, PostgreSQL and Oracle. - Large amounts of data can also be processed. Parallel, and therefore particularly fast, processing on systems with several processor cores. In order to be able to use our software without any restrictions, you can, directly from the respective program, request a trial activation for one week. A corresponding option is presented when you open the program for the first time. The activation key will be sent to you per email. Free mail addresses such as Yahoo.com or gmail.com are not admissible for this purpose. Thank you for your understanding.