DQ Global

Match
Print
  • License Error in 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 Files\DQ Global\Match' (Windows XP) or 'C:\Program Files (x86)\DQ Global\Match' (Above Windows XP)

    If none of the above solves your issue, then please contact support@dqglobal.com 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 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 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, Match Software allows you to define the matching rules as well as % similarity thresholds ranges:

    1. Positive - Above the upper % threshold are considered duplicates
    2. Ambiguous - Between the upper and lower % threshold are considered ambiguous
    3. No Match - Below the lower % threshold are considered non duplicates
  • How do I modify the rule(s) for exceptions?

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

    1. Data standardizations (transformations)
    2. Data substrings (parts of columns may be used)
    3. Parsing of columns where multiple words may need breaking up
    4. Phonetic rules for similar sounding words (Zerox and Xerocks etc.)
    5. 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 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 deal with abbreviated names?

    Companies with abbreviations (International Business Machines, International Business Machines Limited which also abbreviate to IBM, are dealt with through our matching engine or data processor. Both use a vast library of standard transformations, however, custom transformation libraries may also be used to manage any form of standardization.

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

    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?

    Match and 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, 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, 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, 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 Match?

    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 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. 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 do you maintain a single view of your customers for marketing purposes?

    You can use Match to connect to your CRM or Marketing Automation systems to identify duplicates. Once identified and confirmed as duplicate records, they may be removed using match or through the CRM or Marketing applications delete duplicates capabilities.
  • How many disparate data sources can match work with?

    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 match work with misaligned data?

    Yes, Match has a capability called intra-match which is designed to cater for misaligned data in records. 
  • What does Match do other than matching and de-duplication?

    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 Match with other applications?

    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 match types using VB Script.

  • Can you apply weighting to the Match candidate scores?

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

  • Does Match use deterministic or probabilistic logic for matching?

    It uses both for what we believe delivers realistic matching.

  • Does 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 Match support?

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

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

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

  • Can I use Match with my CRM system?

    Yes, 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 Match for single customer view (SCV) projects?

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

  • Can I integrate Match with other systems?

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

  • Can I Standardize and format my data?

    Yes, 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 Match?

    To install and run 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?

    Match has a selection ‘filter’ capability: you can select the appropriate group of records from your database using a simple SQL statement query. 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?

    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?

    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 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 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?

    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 Match be set to run outside working hours?

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

  • Can I use Match in a Client Server environment?

    Match has been designed to work with databases irrespective of their environment.

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

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

  • Can Match process one database against another?

    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 Match work with the database I already have?

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

  • What are the benefits of using Match?

    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 Match to use?

    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 Match?

    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.