matchIT SQL Product Tour

Handle inconsistent & poorly formatted data

Inconsistent or poorly formatted datamatchIT SQL can connect to any SQL Server database utilising either tables or views and can work with any data challenges – no need to parse or standardise ahead of time.

Pre-built data quality processes for SSIS packages

SSIS data quality tasksEasily drag, drop and connect matchIT SQL data quality tasks from the SSIS toolbox to create and automate required data quality processes.


Customise match keys

Customise Match KeysIn matchIT SQL you have complete control to customise and tune match keys, weights, settings, constraints and score thresholds to allow effective automation of decisions for differing business objectives. Because all fuzzy matching happens in a single pass, it is highly efficient.

Perform address validation & suppression screening

SQL Address Validation screenshotClean address data results in better match rates and matching results that are easier to automate. matchIT SQL provides fully integrated address verification for UK and international address verification and geocoding for over 240 countries worldwide. For UK, matchIT SQL’s address verification is certified by Royal Mail.


Scoring of matches to streamline automation

Scoring of MatchesThe matchIT SQL proprietary scoring system allows you to set your threshold for matches and quickly automate processes, minimising manual review of the gray area.

Generate actionable results

Data Quality ResultsMatching pairs and groups are written to database tables which are created by matchIT SQL within the SQL Server database allowing you to easily create the output you require.

 


Schedule Your Proof of Concept

Whenever you’re ready to Test Drive matchIT SQL, click here and one of our knowledgeable Support Technicians will contact you within the hour to get you up and running. We’ll help you with set up, customization and then let you run with it to find what works best for you!

Speak with a Consultant Now +44 (0) 1372 225900