Getting Started
- 1. Introduction
- 2.0 - MSQL System Requirements
- 2.1 - Installation Overview
- 2.2 - Installing mSQL (With Screenshots!)
- 2.3 - Adding the SSIS Components to the Toolbox (SQL 2005 and 2008 only)
- 2.4 - Power BI Installation
- 3. Running through the Demo
- 4. Next Steps
Knowledge Base
- mSQL 1.1 - mSQL Component Overview
- SSIS Tutorial for mSQL
- mSQL 2.1 SSIS Tasks
- mSQL 2.2.1 - SSIS Tutorial - Setting up US Address Validation
- mSQL - SSIS Tutorial - Using Multiple Region Addressing
- mSQL 2.2.2 - SSIS Tutorial - Addressing - understanding the outputs
- mSQL 2.2.3 - SSIS Tutorial - Addressing - understanding the result table
- mSQL 2.3.1 - SSIS Tutorial - Setting up Generate Keys - Setting a template
- mSQL 2.3.2 - SSIS Tutorial - Setting up Key Generation
- mSQL 2.4.1 - SSIS Tutorial - setting up a basic matching process
- mSQL 2.4.2 - SSIS Tutorial - incorporating exact matching
- mSQL 2.4.3 - SSIS Tutorial - Understanding Output Tables From A Matching Process
- mSQL 2.4.4 - SSIS Tutorial - findoverlap vs findmatches
- mSQL 2.5.1 - SSIS Tutorial - setting up a findoverlap
- mSQL 2.5.2 - SSIS Tutorial - Incorporating Exact Overlap
- mSQL 2.5.3 - SSIS Tutorial - mSQL Overlap Output Tables
- mSQL 2.5.4 - SSIS Tutorial - Find Matches/findoverlap more in depth, weights and constraints
- mSQL 2.6.1 - SSIS Tutorial - Understanding Matching - Why did this score 85 on Individual Level?
- mSQL 2.6.2 - SSIS Tutorial - Understanding Matching - Why did this score 85 on Business Level
- mSQL 2.6.3 - SSIS Tutorial - Tight Business Matching
- mSQL 2.7.1 - SSIS Tutorial - What are all these key fields?
- mSQL 2.7.2 - SSIS Tutorial - Output Tables, Filtering and Quality Scoring
- mSQL 2.8.1 - SSIS Tutorial - moving a matching process from SSIS to Stored Procedures
- mSQL 2.9 - SSIS Tutorial - Power BI Reporting
- mSQL 3.0 - Overview of an XML Configuration file
- mSQL 3.1 - Configuring an XML - Match Keys
- mSQL 3.2 - Configuring an XML - General Settings and Output Settings
- mSQL 3.3 - Configuring an XML - Datasources and field mappings
- mSQL 3.4 - Configuring an XML - mAPI Settings
- mSQL 3.5 - Configuring an XML - Running the application configured to your data
- mSQL 3.6 - Table Triggers and Passive Mode
- mSQL 4.0 - Stored Procedures in Depth
- mSQL 4.1.1 - msp_GenerateCorrectedAddresses - US Addressing Settings, Inputs and Outputs
- mSQL 4.1.2 - msp_GenerateCorrectedAddresses - International Addressing Settings, Inputs and Outputs
- mSQL 4.1.3 - msp_GenerateCorrectedAddresses - UK Addressing Settings, Inputs, and Outputs
- mSQL 4.2.1 - msp_GenerateNCOAAddresses
- mSQL 4.2.2 - 7.1.2 msp_GenerateNCOAAddresses - Inputs, Outputs and Reports
- mSQL 4.2.3 - msp_GenerateNCOAAddresses -Security
- mSQL 4.3 - msp_BulkGenerateKeys
- mSQL 4.4.1 - msp_FindExactMatches
- mSQL 4.4.2 - msp_FindExactOverlap
- mSQL 4.5.1 - msp_GroupExactMatches
- mSQL 4.5.2 - msp_GroupExactOverlap
- mSQL 4.6.1.1 - msp_FindMatches
- mSQL 4.6.1.2 - msp_FindMatches - output tables
- mSQL 4.6.2.1 - msp_FindOverlap
- mSQL 4.6.2.2 - msp_FindOverlap - output tables
- mSQL 4.7.1 - msp_GroupMatches
- mSQL 4.7.2 - msp_GroupOverlap
- mSQL 4.8.1 - matching output SP's
- mSQL 4.8.2 - Overlap output SP's
- mSQL 4.9 - Table Triggers and CreateUniqueRefField
- mSQL 4.10 Deprecated Stored Procedures
- mSQL 4.11 - Power BI Stored Procedures
- mSQL 5 - TVF's in mSQL
- mSQL 6 - Overview of the UI
- mSQL 7 - mSQL Reporting outputs
- mSQL 8 - Deployment Strategies for a clustered environment
- mSQL 9 - Using Stored Procedures With A Local Or Remote Instance
Troubleshooting:
- Error when initializing the matchIT API
- Error initialising US Addressing national database
- Reactivating or upgrading mSQL
- Common errors: Error processing data through NCOA: SetNCOAUserInfo failure
- Troubleshooting Stored Procedures
- Troubleshooting Addressing
- Getting Set Up for NCOA
- Downgrading a Project, or The contact information for this task is ""
- Helpful Tips if you're having issues with US addressing after an update
- Dealing with Address1 being longer than 72 characters
- How to disable summary reporting after installation