Getting Started
- 1. Introduction
- 2.0 - matchIT SQL System Requirements
- 2.1 - Installation Overview
- 2.2 - Installing matchIT SQL (With Screenshots!)
- 2.3 - Adding the SSIS Components to the Toolbox (SQL 2005 and 2008 only)
- 2.4 - Power BI Installation
- 2.5 - matchIT SQL and Microsoft Azure or AWS
- 3. Running through the Demo
- 4. Next Steps
Knowledge Base
- matchIT SQL Useful Demo/Training Videos & Links
- S1.1 - matchIT SQL Component Overview
- SSIS Tutorial for matchIT SQL
- S2.1 SSIS Tasks
- S2.2.1 - SSIS Tutorial - Setting up UK Address Validation
- S2.2.2 - SSIS Tutorial - Setting up US Address Validation
- S2.2.3 - SSIS Tutorial - Using Multiple Region Addressing
- S2.2.4 - SSIS Tutorial - Addressing - understanding the outputs
- S2.2.5 - SSIS Tutorial - Addressing - understanding the result table
- S2.3.1 - SSIS Tutorial - Setting a template
- S2.3.2 - SSIS Tutorial - Setting up Key Generation
- S2.4.1 - SSIS Tutorial - setting up a basic matching process
- S2.4.2 - SSIS Tutorial - incorporating exact matching
- S2.4.3 - SSIS Tutorial - Understanding Output Tables From A Matching Process
- S2.4.4 - SSIS Tutorial - findoverlap vs findmatches
- S2.5.1 - SSIS Tutorial - setting up a findoverlap
- S2.5.2 - SSIS Tutorial - Incorporating Exact Overlap
- S2.5.3 - SSIS Tutorial - matchIT SQL Overlap Output Tables
- S2.5.4 - SSIS Tutorial - Find Matches/findoverlap more in depth, weights and constraints
- S2.6.1 - SSIS Tutorial - Understanding Matching - Why did this score 85 on Individual Level?
- S2.6.2 - SSIS Tutorial - Understanding Matching - Why did this score 97 on Business Level
- S2.6.3 - SSIS Tutorial - Tight Business Matching
- S2.6.4 - SSIS Tutorial - Considerations for Company only / Name only matching
- S2.7.1 - SSIS Tutorial - What are all these key fields?
- S2.7.2 - SSIS Tutorial - Output Tables, Filtering and Quality Scoring
- S2.8.1 - SSIS Tutorial - moving a matching process from SSIS to Stored Procedures
- S2.9.1 - SSIS Tutorial - Suppression Processing
- S2.9.2 - SSIS Tutorial - Hosted Service Processing
- S2.10.1 - SSIS Tutorial - Mail Sortation
- S2.10.2 - SSIS Tutorial - Mail Sortation Options
- S2.10.3 - SSIS Tutorial - Carrier Account Options
- S2.10.4 - SSIS Tutorial - Mail Sortation Reports and Outputs
- S2.10.5 - SSIS Tutorial - Mailmark Controller
- S2.11.1 - SSIS Tutorial - Power BI Reporting
- S2.11.2 - SSIS Tutorial - Output Task
- S2.12.1 - SSIS Tutorial - Datatools
- S3.0 - Overview of an XML Configuration file
- S3.1 - Configuring an XML - Match Keys
- S3.2 - Configuring an XML - General Settings and Output Settings
- S3.3 - Configuring an XML - Datasources and field mappings
- S3.4 - Configuring an XML - matchIT API Settings
- S3.5 - Configuring an XML - Running the application configured to your data
- S3.6 - Table Triggers and Passive Mode
- S4.0 - Stored Procedures in Depth
- S4.1.1 - msp_GenerateCorrectedAddresses - UK Addressing Settings, Inputs, and Outputs
- S4.1.2 - msp_GenerateCorrectedAddresses - International Addressing Settings, Inputs and Outputs
- S4.1.3 - msp_GenerateCorrectedAddresses - US Addressing Settings, Inputs and Outputs
- S4.2- msp_GenerateCorrectedAddresses - US Addressing 48 MONTH NCOA Inputs and outputs and Reports
- S4.3 - msp_BulkGenerateKeys
- S4.4.1 - msp_FindExactMatches
- S4.4.2 - msp_FindExactOverlap
- S4.5.1 - msp_GroupExactMatches
- S4.5.2 - msp_GroupExactOverlap
- S4.6.1.1 - msp_FindMatches
- S4.6.1.2 - msp_FindMatches - Matches and Large_clusters Tables
- S4.6.2.1 - msp_FindOverlap
- S4.6.2.2 - msp_FindOverlap - Overlap Matches and Large_clusters Table
- S4.7.1 - msp_GroupMatches
- S4.7.2 - msp_GroupOverlap2
- S4.8.1 - matching output SP's
- S4.8.2 - Overlap output SP's
- S4.9 - Table Triggers and CreateUniqueRefField
- S4.10 - Deprecated Stored Procedures
- S4.11 - Suppression Stored Procedures
- S4.12 - Power BI Stored Procedures
- S5 - TVF's in matchIT SQL
- S6 - matchIT SQL and Microsoft Azure or AWS
- S7 - matchIT SQL Reporting outputs
- S8 - Deployment Strategies for a clustered environment
- S9 - Using Stored Procedures With A Local Or Remote Instance
- S10 - Suppression Flag Definitions
Troubleshooting:
- Common Errors: Suppression Processing: Invalid object name 'dbo.__SuppressionHolding__keys__
- Common Issues: Version mismatch! error after upgrading
- Upgrading an SSIS package to a newer version of SQL Server:
- Configuring SQL Server Security
- Configuring SQL Server for Remote Access
- Common Errors: Failure in Addressing module; exit code was 1
- Reactivating or upgrading matchIT SQL
- Troubleshooting Stored Procedures
- Troubleshooting Addressing