Match [6.x Enterprise Edition, Single Licence, Upgrade from Professional Edition Win98/ME/2000/NT/XP]

• Overcomes the challenges of matching international data in the western world's five key languages: English, French, German, Italian and Spanish.
• Identifies duplicate records within a single database, or cross matches to other databases, mailing lists, suppression or enhancement data sets as required.
• Designed to be flexible, and no import of data, formatting or preparation is required: just connect to your database(s), define your match criteria and search!

Find duplicates fast!
Duplicate data destroys credibility, reduces loyalty and adversely impacts on your brand. Yet when you have millions of records to deal with, often poorly structured, spelt incorrectly and with data abbreviated or missing, the challenge is immense.
Once potential duplicates have been identified, you can process them with ease: you can review, enhance, flag, update or delete them as you choose. Designed to meet the needs of small and medium-sized enterprises (SMEs) through to multi-national organisations.

SureMatch 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.

• SureMatch’s powerful VB scripting functionality also enables developers to define and implement their own matching criteria.
• SureMatch is an ODBC-compliant application which connects to all popular database formats as laid out in the enclosed feature list.
• SureMatch 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.
• SureMatch has a built-in scheduling facility which allows users to set a predefined time for the de-duplication process to run.
• 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
• There is no limit to the number of fields which may be selected during the search process.
• It is possible to export selected data fields and/or a list reflecting the

Master/Duplicate relationships to a CSV format file.

• SureMatch 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.
• SureMatch 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.
• SureMatch has a selection 'filter' capability: you can select the appropriate group of records from your database using a simple SQL statement query. SureMatch can also process Access queries so you can pull back data in several different tables to deduplicate against.
• To install and run SureMatch you will need an IBM PC or 100% compatible, with a minimum of a Pentium processor, running Microsoft Windows or Windows NT and with at least 32Mb RAM.

• Avoid the error prone export and re-import process, through direct database connectivity.
• Standardize your data format and manage Case and Gender determination.
• Out performs SoundEX, Metaphone and NYSISS algorithms using our advanced Phonetic logic, coupled with our comprehensive multi-category, multi-lingual data transformations.
• Merge data between records and re-assign orphans to avoid critical information being lost.
• Match misaligned data using our amazing Intra-Match engine.
• Identify match relationships in a single or pair of databases.

It incorporates a full Visual Basic (VB) development environment which means the client benefits:

• Integrated data from disparate systems.
• Aggregation of multiple data sources for analysis and reporting.
• Data compliance to ensure CRM system integrity and synchronization.
• Connectivity to data sources of virtually any format.
• Match in Five major spoken languages (English, French, German, Italian & Spanish).

SureMatch is currently available in three versions:

• Professional.
• Enterprise.
• Corporate.

The following functions are included in the Professional, Enterprise and Corporate Editions:

• 32-bit Windows systems.
• Phonetic matching.
• Fuzzy non-phonetic matching.
• Intelligent set-up wizard.
• Matching a database against itself.
• Interactive duplicate review & editing.
• Summary of duplicates found.
• Print/report functions.
• Percentage scoring of matches.
• Data transformation libraries.
• Custom data transform.
• Keep/delete based on % match.
• Global deletion.**
• Security privileges and access rights.
• Effective matching of business data.
• Effective matching of consumer data.
• Flagging of suspected duplicates.
• Create columns in database.**
• Create unique reference number.
• Export duplicates to CSV format.
• Export clean records to CSV format.
• Filter records using SQL.
• Merge/purge using two files.
• Tuning of matching options.
• User control of grading of matches.
• User maintainable lexicon of names.
• Scripting of regular jobs.
• Job automation from command line.
• Intelligent casing.
• Intelligent salutation generation.
• Edit table data.
• Edit data comparisons.
• Export duplicate relationship keylist.
• Re-assign orphan records.
• Custom data transformations.
• Assign Group Numbers into CRM system or target database for internal duplicate detection.
• Deferred match process scheduling.
• VB Script execution.

The following functions are included in the Enterprise and Corporate Editions only:

• Cross matching of two databases.
• Data standardisation.
• Case management.
• Salacious word detection.
• Phonetic match keys into CRM system or target database for internal duplicate detection.
• Phonetic match key generation.
• Merge of duplicate/master data.

The following function are included in the Corporate Edition only:

• VB Script development.

• * Subject to target database authorising external changes.

SureMatch Database Connectivity for Professional, Enterprise, Corporate Editions:

• Excel 3.x, 4.x, 5.x, 97, 2000 **
• Lotus 1 2 3 (wk3) **
• MS Access 2.x, 95, 97, 2000
• Dbase III, IV, 5.0
• Foxpro 2.0, 2.5, 2.6
• Paradox 3.x, 4.x, 5.x
• Text (CSV)
• Text (Fixed Length)
• Foxpro 3.0 (only via 32 bit ODBC)
• Btrieve (only via 32 bit ODBC)
• ODBC (requires 32 bit drivers)

• * Records may only be flagged as no delection of records allowed by database.

To install and run SureMatch you will need an IBM PC or 100% compatible, with a minimum of a Pentium processor, running Microsoft Windows or Windows NT and with at least 32Mb RAM.