DataQualityTools 8

Dedupe Excel, ACCESS, SQL

 

 

 

 

More dedupe software:

 

DataQualityTools help you to improve your data and therefore your marketing. A key component are the functions for finding duplicate records. Spelling variations, such as those in postal addresses, are no problem. These functions can also be used to consider blacklists, to synchronise tables or to enrich data.

Match data, eliminate duplicates

  • Fast, largely automated and user-friendly deduplication functions for address and other databases.
  • Option to dedupe between two tables, for example, to consider blacklists (opt-out lists / Robinson lists / MPS lists), to synchronize address lists or to enrich data.
  • The criteria used to search for duplicates / dupes can be the postal address (error-tolerant / fuzzy matching), telephone number, email address, address or customer numbertax number or any other criterion.
  • Not only are exact matches found, where every single character matches, but also fuzzy duplicates and duplicate addresses. 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 combine multiple tables into a single deduplication operation.

Other functions for quality improvement

Numerous ways to use the result

  • 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.
  • In addition to deleting directly in the source table, it is also possible to mark the results in the source table, to process it further using a stored procedure, to create a duplicates file or to export the results to a new file.
  • And deletion and result logs can be created, to print the deduplication results or save them as a PDF file.
  • further information ...

Fast, flexible and safe

  • 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 (accdb), Excel (xls / xlsx / xlsm / xlsb), dBase (dbf), OpenOffice / LibreOffice Calc (ods), CSV files and text files, but also database servers such as MS SQL Server, Azure SQLMySQLMariaDB, PostgreSQL and Oracle.
  • Large amounts of data can also be processed. On systems with multiple processor cores, the data is processed in parallel and therefore particularly quickly.
  • Support for high-resolution displays (4k).
  • Language of the user interface: English, German, French, Italian, Spanish, Turkish
  • Tested and run compatible using Windows 10 / Windows 11.

Try now for 7 days free of charge

In order to be able to test our software without any restrictions, you can 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.

 

 DataQualityTools
Professional
DataQualityTools
Performance Plus
Maximum number of records per table 250.000 unlimited
Extensive speed optimisation [++]  
Data sources:    
MySQL
PostgreSQL
MS SQL-Server
Azure SQL
Oracle
Excel (xls / xlsx / xlsm)
OpenOffice / LibreOffice (ods)
CSV/Text
Access (accdb)
dBase (dbf)
Matching functions:    
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  
[++]
Merge / Split Tables:    
Merging Tables
Split table
Select data:    
Select data
[++]
Select data (2 Tables)
[++]
Select company addresses
[++]
Select addresses
[++]
Error-tolerant Search for Data [++]
Enrich data (2 Tables)
[++]
Determine difference (2 Tables) [++]
Verify data:    
Verify Addresses
[++]
Correct salutation
[++]
Verify data field
[++]
Verify phone number
[++]
Verify email address
[++]
Verify URL
[++]
Verify IBAN
[++]
Verify EAN
[++]
Format / Correct Data:    
Correct the postal code format
[++]
Formating phone numbers
[++]
Formating Addresses
[++]
Formating Data Fields
[++]
Correct first name/last name mapping
[++]
Add data:    
Determining the Salutation for Letters
[++]
Determining the salutation / sex
[++]
Determining Sectors
[++]
Determine Country Name [++]
Supplementing Data Fields
[++]
Fill column
[++]
Create hash value
[++]
Replace Data:    
Replacing Terms / Words
[++]
Replacing Characters
[++]
Replacing Html Characters
[++]
Deleting unwanted characters [++]
Other Functions:    
Creating a Standard Address File
Deleting records
CSV-to-Excel-Converter
Split / Merge Data:    
Splitting Data Fields
[++]
Merging Data Fields
[++]
Splitting Telephone Numbers
[++]
Splitting Email Addresses
[++]
Extracting Salutations
[++]
Extracting Titles
[++]
Splitting Names
[++]
Splitting Streets
[++]
Separate postcode and city
[++]
Reports:    
Analyze table content
[++]
Country 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
[++]
Ways to use the result:    
Manual Post-Editing
Deletion Log
Results Log
Deleting in the Source Table
Export results
Duplicates File
Flagging Records
Deleting Using a Stored Procedure  
Enriching a database using the matching results
Completing Records
Merging Records
Other:    
Project Management
Project History  

 

 

[++] 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.