Frequently Asked Questions

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.

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.

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.

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

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.

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

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

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.

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

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

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.

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.

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.

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.

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

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

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

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.

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

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

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

It uses both for what we believe delivers realistic matching.

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

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

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.

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

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

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.

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.

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.

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

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.

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

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.

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.

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.

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.

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.

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

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

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.

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.

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.

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 support@dqglobal.com as your license may have expired.