Match FAQ

  • License Error in DQ Match

    Please try the below steps to try to overcome the License Error you have received:


    • Please try to ‘Run as Administrator’ and then apply the license.
    • Please make sure you have full read/write access to the folders and sub folders of ‘C:DQGlobal’ and ‘C:Program FilesDQ GlobalMatch’ (Windows XP) or ‘C:Program Files (x86)DQ GlobalMatch’ (Above Windows XP

    If none of the above solves your issue, then please contact as your license may have expired.”

    Can I identify relationships rather than duplicates?

    “Can it detect and link a subsidiary to a parent? I believe so if the names are similar of the relationships have been defined in the application

    Can I merge data to a parent? Yes.

    Can I use a third party source, such as Brooks & Dunn or Hoovers, to help me? Yes.”

    How do I merge child (foreign key) relationships?

    We have a re-assign orphan’s wizard in DQ Match. Using this on your database will correctly re-assign all foreign key child table data. However, if referential integrity is maintained by the application, as is often the case with CRM, all changes should be posted through the relevant application API’s or Web services.

    How do I merge duplicates and how do I choose what data to merge?

    Whilst we have a solution for this problem every customer has different needs. As such we have created an add on for DQ Match called the One:One data manager. We are extending this to have a rules editor to define which of the colliding pieces of 1:1 data should survive.

    Will it catch and categorize the non identical duplicates (Positive Match, Ambiguous Match and No Match)?

    Yes, DQ Match Software allows you to define the matching rules as well as % similarity thresholds ranges:

    • Positive – Above the upper % threshold are considered duplicate
    • Ambiguous – Between the upper and lower % threshold are considered ambiguous

    No Match – Below the lower % threshold are considered non duplicates

    How do I modify the rule(s) for exceptions?

    “Through an intuitive interface within DQ Match. This interface allows for:


      1. Data standardizations (transformations)


      1. Data substrings (parts of columns may be used)


      1. Parsing of columns where multiple words may need breaking up


      1. Phonetic rules for similar sounding words (Zerox and Xerocks etc.)


      1. Custom rules if required may be executed in Visual Basic script for highly customized rules

    What rules do I make/select to look for duplicates?

    our DQ Match Software allows users to define rules at field (column) level. These can be very simple through to complex with the ability to define field level weightings so that matching is tuned for the purpose intended. i.e. Company level, premise level or individual level matching will need different rules and weightings, which we manage this with ease.

    How do I modify my inconsistent data so it becomes consistent?

    DQ Match has a data processor which will transform (standardize) data formats so (U.S., United States, America) can be abbreviated, elaborated or excluded as appropriate with ease.

    How do I view/manage a sub set of my database?

    DQ Match and DQ DedupeExpress can connect directly to database views, access queries, or you can apply SQL filters right inside Match to work with a sub-set of your whole database.

    Why use matching software instead of a bureau service?

    We offer a Bureau Service, however, it does not treat the root cause of bad data once as opposed to perpetually treating the effects by sending it to a bureau.

    Can B2B or B2C data be managed?

    Yes, DQ Match is data agnostic, you control the way the matching sessions are defined based upon the type of data. Every column (field) containing data can have different rules defined. As such any data structure can be catered for, regardless of Business Name, Person Name, Company or Personal Address, Telephone, eMail etc.

    Can I Suppress records?

    Yes, DQ Match may be used for suppression, simply cross match your database to the suppression file of your choice.

    Can I create my own data transformations data for lookup and correction?

    Yes, DQ Match allows you to create your own libraries of data standardizations, data conversions and data exclusions. This capability extends the capabilities outside of just name and address matching to parts, products or any domain attribute you can recognize.

    Are salacious words detected by DQ Match?

    DQ Match can be configured to recognize salacious words and either remove them or flag records where they are detected.

    How can I merge information from an identified duplicate record into a main record?

    In order to ensure you create the perfected record DQ Match has a sophisticated data processor which allows you to: Link, Group, Flag, Standardize, Merge and Format your data so you move data from any duplicate to its corresponding Master record.

    Do I need to import and export my data?

    There is no need for any error prone import and export routines. DQ Match connects to your chosen database and can either (1) Flag duplicate records (2) Group duplicated records or (3) Link by Unique Record ID any matching records (4) Delete matching records.

    How many disparate data sources can DQ Match work with?

    DQ Match currently works with a maximum of two databases or data sources. They can be of different structures and formats however. For matching multiple data sources to a master, we recommend creating and de-duplicating a master database and cross comparing all other databases to the master. This process creates a single record view and will assist in master data management projects.

    Can DQ Match work with misaligned data?

    Yes, DQ Match has a capability called intra-match which is designed to cater for misaligned data in records.

    What does DQ Match do other than matching and de-duplication?

    DQ Match has a comprehensive range of data-enhancing capabilities in five spoken languages:

    • Case management: upper, lower and correct
    • Gender determination
    • Data standardisation (or transformation)
    • Flagging
    • Grouping
    • Re-assignment of orphaned data
    • Merging of data


    Can I integrate DQ Match with other applications?

    DQ Match ships with a powerful VB Scripting language, which gives user access to exposed internal functions and the ability to integrate with third-party applications, for example:

    • CRM systems for data synchronisation and re-assignment.
    • ETL tools for data migration.
    • Data manipulation through VB Script exposed.
    Can I write my own match criteria?

    Yes, it allows users to write their own DQ Match types using VB Script.

    Can you apply weighting to the DQ Match candidate scores?

    Yes, DQ Match allows you to apply weightings to every field used in the matching process to modify the overall match score.

    Does DQ Match use deterministic or probabilistic logic for matching?

    It uses both for what we believe delivers realistic matching.

    Does DQ Match use phonetic match key generation techniques?

    Yes, it generates and uses phonetic match keys in conjunction with other techniques for data normalization.

    How many spoken languages does DQ Match support?

    Currently DQ Match supports: English, French, German, Italian and Spanish.

    Can I use DQ Match for Master Data Management (MDM) projects?

    Yes, DQ Match has been used to assist with identifying the associations required to deliver Master Data Management (MDM) projects.

    Can I use DQ Match with my CRM system?

    Yes, DQ Match has been designed to connect to your CRM systems and identify and flag records, so they may be merged through your CRM applications correctly and preserve data integrity.

    Can I use DQ Match for single customer view (SCV) projects?

    Yes, DQ Match has been used by many clients to help build a single customer view (SCV).

    Can I integrate DQ Match with other systems?

    Yes, DQ Match has Visual Basic scripting embedded inside. You benefit from all the capabilities of DQ Match in code.

    Can I Standardize and format my data?

    Yes, DQ Match has an inbuilt data processor which allows you to carry out numerous data processing functions with case.

    What kind of machine do I need to run DQ Match?

    “To install and run DQ Match you will need Intel or AMD CPU.

    Microsoft Windows 2000 or XP minimum 512mb.

    Vista and Windows 7 32bit minimum 1Gb.

    Vista and Windows 7 64bit minimum 2Gb.

    Can a de-duplication session be conducted on a user-defined record set within a database table?

    DQ Match has a selection ムfilterメ capability: you can select the appropriate group of records from your database using a simple SQL statement query. DQ Match can also process Access queries so you can pull back data in several different tables to deduplicate against.

    What happens to data linked to duplicated records that I have deleted?

    DQ Match has a facility for re-assigning ‘orphan’ data to the master when records are deleted: this will work for one-to-many related tables only.

    Can I control the deletion of duplicate records?

    DQ Match allows you to review and confirm the deletion of any records identified as duplicates. Data can also be edited from the duplicate record to enhance the master record by cutting and pasting the required information.

    Does DQ Match provide an export facility?

    Yes – it is possible to export selected data fields and/or a list reflecting the Master/Duplicate relationships to a CSV format file.

    How many data fields can be used in DQ Match search criteria?

    There is no limit to the number of fields which may be selected during the search process.

    How long does it take to perform a de-duplication session?

    DQ Match performance times vary according to the size of database(s) used, as well as the amount and type of search criteria selected. Network speed, processor speed, memory available will also affect your performance, typically between 1 to 1.5 million records an hour.

    Can DQ Match be set to run outside working hours?

    DQ Match has a built-in scheduling facility which allows users to set a predefined time for the de-duplication process to run.

    Can I run DQ Match without importing data from my database?

    There is no import, formatting or preparation of data required if your database type is supported.

    Can DQ Match process one database against another?

    DQ Match can search a single database table for duplicates or search between two tables regardless of their format or database type. For example it can search an MS Access table against a MS SQL Server table.

    Will DQ Match work with the database I already have?

    DQ Match is an ODBC-compliant application which connects to all popular database formats.

    What are the benefits of using DQ Match?

    DQ Match will increase your overall profitability and efficiency by identifying and allowing removal of replicated data from your database. Savings come from reduced postage, stationery and reduced database administration, while at the same time enhancing your company image.

    How easy is DQ Match to use?

    DQ Match is a Microsoft Windows application, with an intuitive point-and-click interface backed up by a context-sensitive online help facility and comprehensive user documentation.

    What is DQ Match?

    DQ Match is a powerful software utility which interrogates database tables in search of duplicate records. The search criteria are defined by the user, from a comprehensive range of advanced match operators which include phonetic, direct word match, telephone/fax number and name initials.


      Further Information

      Our Products

      Find out more about the full range of DQ Global’s data quality software
      > Click here


      Read some of the Frequently Asked Questions about our products
      > Click here


      Visit our YouTube channel to find out more about our products and how they can assist you
      > Click here

Share This: