mSQL

mSQL’s matching engine is unlike any other data matching logic you have seen! Unlike conventional data quality solutions – mSQL doesn’t require data standardization, correction or manipulation prior to matching! 360Science uses a blend of probabilistic analysis with deterministic logic – separate from the matching process – to SCORE/GRADE entire records – using ‘all’ available data to determine potential matches. Matching, Merging, Combining, List Intersection or Suppression – The results speak for themselves!

While mSQL’s doesn’t ‘require’ extraction, transformation, standardization, correction or manipulation prior to matching – mSQL does provide amazing data cleansing capabilities. mSQL incorporates the capability to parse, case, correct, extract, transform and standardize, detect profanity, identify gender, and much more – turning your most awful inputs into clean usable data.

Don’t confuse the mSQL’s decision logic with simple counts and values of conventional ‘data profiling’ solutions. mSQL – is wildly different. mSQL not only gives you in-depth counts and values – it performs deeper ‘qualitative’ analysis to measure the quality of your contact data and the trustworthiness of each record. With our Power BI integration, we bring that data to life with data analytics and rich interactive visualizations!

More than just an address verification API for Microsoft SQL Server – mSQL delivers US CASS Certified DPV Address Verification, Global Address Validation for 240+ Countries, Geocoding (Rooftop and Census) and NCOA processes “fully integrated” into mSQL’s stored procedures and SSIS tasks. Not only are the results written directly to SQL Server – but the results from the address validation are seamlessly integrated into mSQL’s other processes, to ensure you can match and action the best possible data.

Data quality and MDM are highly interrelated, and achieving a “Single Customer View” requires powerful built-in capabilities for harmonizing data. mSQL’s sophisticated AI looks at patterns in the data, the nature and position of words, classifies word types, creates word associations, and identifies where there is poorly formatted, incomplete or uncertain information. This analysis of your data, feeds the logic that intelligently defines the Master Record.

360Science’s technology has been deployed in over 30 different countries and as many use cases (including Financial services) providing Global Data Matching, Global Address Validation, and Data Cleansing. mSQL has amazing tolerance for phonetic errors, keying and reading mistakes – and copes extremely well with poorly structured address data where postal standards are non-existent. It also the ability to transliterate native character sets such as Cyrillic Россия, KANJI 日本, Simplified Chinese 中国, Arabic العربية, (and many more). It’s a small world after all!