mSQL is a high-performance fully integrated data quality platform for Microsoft SQL Server. Specifically developed to run in Microsoft SQL Server Data Tools (SSDT) using SSIS – or SQL Server Management Studio (SSMS) utilizing .NET stored procedures.
What if cleaning Customer Data didn’t require a toolbox of regular expressions – and matching didn’t mean performing data gymnastics to extract, transform or standardize your data in order to prepare your data for matching?
To fully appreciate how 360Science matching engine works, you almost need to set aside everything you’ve been taught about contact data matching! It’s insane!
mSQL gives us the confidence that our numbers are right. There’s never a question of; have we matched it up, has everything been deduped, is the data up-to-date and accurate. There’s no confusion about that any longer. There is no question.
HumanN – VP of Operations
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!
In Private Beta
Visualise your data quality with Power BI
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 data insights into your ‘contact data’ – 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!
360Science’s logic is far more intelligent than conventional data quality platforms that provide you a toolbox of regular expressions. mSQL provides an engine – purposely built for contact data – intelligently applying all forms of data matching to the entire contact record.
“To fully appreciate how mSQL’s Matching Engine works – you almost need to set aside everything you’ve been taught about data matching!” It’s insane!
To accurately match contact data, a matching engine must have robust score logic to assess the similarity of the entire contact record. mSQL’s scoring logic maximizes legitimate matches, minimizes false matches and gives you greater control of the matching process.
To quote one of our customers – “360Science’s Matching Engine achieves results that are like human perception”.
What if matching contact data didn’t require time consuming process to extract, transform or standardize your data – and what if you didn’t need a toolbox of regular expressions to prepare your data for matching?
Unlike competing applications – mSQL doesn’t require data extraction, transformation, standardization, correction or manipulation prior to matching – and it doesn’t even require two different data sources to be normalized into a common format or a target database!
Say hello to 360Science – and say no to #DataGymnastics and #RegExHell
Persistence – With 360Science you’re NOT locked into your “MatchCode”! Finding matches, grouping and scoring are completely independent of match keys. This is a real #GameChanger!
Performance & Security – Analyze data directly within your SQL Server database. mSQL is built from the ground up for high performance and optimized for Microsoft SQL Server – taking advantage of all of SQL Server’s inherent performance and security characteristics.