Try it now for free! Download now!

( Release date: 12/12/2018 )

DataQualityTools 6 - The software that helps you make the most out of your data.

DataQualityTools 6

Dedupe Excel, ACCESS, SQL

 

 

 

 

More dedupe software:

 

Reduce advertising costs by avoiding double solicitations? Manage your addresses more efficiently through better databases, because they are free of duplicates / dupes? Take account of lists of those who do not wish to receive marketing mailings? Transfer information from a second external database to your own addresses?

DataQualityTools is a collection of tools to help businesses improve the data quality of their databases by data cleansing. The central components involve a series of functions which help to find duplicats (deduplication software / dedupe software) and, above all, a function for error-tolerant deduplication (fuzzy matching) based on the postal address. 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 / Robinson lists / MPS 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 (dedupe software). 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 (dupes).
  • User-defined universal matching, that can be used for any kind of data.
  • Option to dedupe between two tables, for example to process blacklists.
  • Option to combine multiple tables into a single deduplication operation.
  • Option to merge columns from two records using the matching results.
  • Numerous options for the further processing of the matching results: in addition to deleting the duplicates directly in the source table, it is also possible to flag the results in the source table, or to process it further using a stored procedure, a duplicates-, a results- or an archive-file.
  • 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.
  • Almost any type of data source can be processed, such as ACCESS (mdb / accdb), VistaDB (vdb5), EXCEL (xls / xlsx / xlsm), dBase (dbf), OpenOffice / LibreOffice Calc (ods), CSV files and text files, but also database servers such as MS SQL Server, Azure SQLMySQLMariaDB, PostgreSQL, IBM DB2 and ORACLE.
  • Large amounts of data can also be processed. Parallel, and therefore particularly fast, processing on systems with several processor cores.
  • Support for high-resolution displays (4k).
  • Language (user interface): English, German, French, Italian, Spanish, Turkish
  • Tested and run compatible using Windows 10 (32Bit / 64Bit), Windows 8 (32Bit / 64Bit) and Windows 7 (32Bit / 64Bit).

 

 

  DataQualityTools
Professional
DataQualityTools
Performance Plus
Maximum number of records per table 250.000 unlimited
Extensive speed optimisation [++]  
MySQL
PostgreSQL
MS SQL-Server
Azure SQL
ORACLE
IBM DB2
Excel (xls / xlsx / xlsm)
OpenOffice / LibreOffice (ods)
CSV/Text
ACCESS (mdb / accdb)
VistaDB (vdb5)
dBase (dbf)
Matching within one File/Table
 [++]
Universal matching within one File/Table
[++]
Matching Using the Postal Address (one Table)
[++]
Matching Using the Telephone Number (one Table)
[++]
Matching Using the Email Address (one Table)
[++]
All-in-One Deduplication within one File/Table
[++]
Matching Using the Customer No. (one Table)
[++]
Matching Using the Tax Number (one Table)
[++]
Matching Using a Date (one Table)
[++]
Matching between two Files/Tables
 [++]
Universal matching between two Files/Tables
[++]
Matching Using the Postal Address (two Tables)
[++]
Matching Using the Telephone Number (two Tables)
[++]
Matching Using the Email Address (two Tables)
[++]
All-in-One Deduplication between two Files/Tables
[++]
Matching Using the Customer No. (two Tables)
[++]
Matching Using the Tax Number (two Tables)
[++]
Matching Using a Date (two Tables)
[++]
Multiple Deduplication  
 [++]
Multiple Deduplication Using the Postal Address  
[++]
Multiple Deduplication Using the Telephone Number  
[++]
Multiple Deduplication Using the Email Address  
[++]
Multiple All-in-One Deduplication  
[++]
Multiple Deduplication Using the Customer No.  
[++]
Multiple Deduplication Using the Tax Number  
[++]
Multiple Deduplication Using a Date  
[++]
Merging Tables
[++]
Select data
[++]
Select data (2 Tables)
[++]
Select company addresses
[++]
Selective Deleting of Addresses
[++]
Enrich data (2 Tables)
[++]
Faulty Addresses List
[++]
Check salutation
[++]
Verify IBAN
[++]
Verify EAN
[++]
Correct the postal code format
[++]
Formating Addresses
[++]
Formating Data Fields
[++]
Determining the Salutation for Letters
[++]
Determining the salutation / sex
[++]
Determining Sectors
[++]
Supplementing Data Fields
[++]
Fill column
[++]
Replacing Characters
[++]
Replacing Terms / Words
[++]
Creating a Standard Address File
CSV-to-Excel-Converter
Splitting Data Fields
[++]
Merging Data Fields
[++]
Splitting Telephone and Fax Numbers
[++]
Splitting Email Addresses
[++]
Extracting Salutations
[++]
Extracting Titles
[++]
Splitting Names
[++]
Splitting Streets
[++]
Overseas Summary List
[++]
State Summary List
[++]
Postal Code Summary List
[++]
Legal Form Summary List
[++]
Salutatory Address Summary List
[++]
Word Frequency Summary List
[++]
Email Summary List
[++]
Telephone Summary List
[++]
Project Management
Project History  
Manual Post-Editing
Deletion Log
Results Log
Deleting in the Source Table
Results File
Archive File
Duplicates File
Flagging in the Source Table
Deleting Using a Stored Procedure  
Option to merge columns using the matching results
Language (user interface):
English, German, French, Italian, Spanish, Turkish

 

 

[++] Extensive speed optimisation, which makes the result available even faster. Among other things, the full performance of the system on which the program is running is exploited by processing the data in parallel.