• User friendly and cost effective

• Standalone (does not require the use of another application such as SAS or MS Access);

• High performance

• Links records from separate data sources or identifies duplicate records within a single data source

Data Sources

• Import data from a wide range of formats; Text Files, DBASE, FoxPro, MS Excel and MS Access;

• Import data from SQL Server, Oracle and other enterprise databases*

• UNIX text file conversion*

• Export data to Access, Text File, Excel and DBASE formats

Analysis

• Clerical Review

• Matched Pairs Analyzer

• Data Quality Analyzer

• Creation of Unique Identifier for Individuals or Businesses

• Clean and correct data quality issues

• Complete List of Data Cleansing  & Standardization Functions

• Address scrubbing & geocoding

Algorithms

• Probabilistic Data Matching algorithms;

• Phonetic name matching using NYSIIS and SOUNDEX algorithms;

• Advanced string comparator functions (ensures that special phonetic matches such as Joan/Jean or Marie/Mary etc are not matched);

• Automatic nick name translation;

• User definable linkage variables and linkage weights;

• Optionally use diagnostic fields as linkage fields (cancer registry and hospital customers);

• Value specific linkage weights - i.e. the family name 'Smith' receives a lower weight than 'Felligi';