matchIT Cortex offers a drag and drop workflow environment for deduplication. It does this through a range of tools that make accessing, cleaning, and outputting data faster and easier. Data preparation tools that include Matching and Normalization functionality. This allows you to find matches in and across any combination of data sources including SQL Server, Excel, & delimited files.
Activation
The first time you run matchIT Cortex, you will be prompted to enter an activation code.
Main Window
Run matchIT Cortex. The main window is divided into 5 main areas.
Menu Bar
The menu bar contains various application command buttons and a progress bar.
| Buttons | Commands | Description | |
|---|---|---|---|
 |
New, Open, Save, Save As | Used to clear the workflow canvas, open a previously saved workflow, save the current workflow, and save the current workflow with a different name. | |
 |
Unlock | Used to enter or update an activation code. | |
 |
Config | Application settings like, log file and log severity. | |
 |
About | Opens an “About” dialog with version information. | |
|
Paste Cut, Copy, Delete | Used to edit workflow canvas tools and connections. | |
 |
Start, Stop | Start the current workflow running and abort a running job. |
Console
The console shows messages. Configuration options let you choose which severity of messages to see, from:
- Debug
- Information
- Warning
- Error
- Fatal
Toolbox
The toolbox contains all the tools you can drag onto the workflow canvas divided into the categories: Input, Process, and Output.
Input
The input category has tools to load data from:
- Databases. The following database types are supported:
- Microsoft SQL Server
- Snowflake
- MongoDB
- Salesforce
- If you would like another database connector, please let us know by contacting our support team and we will introduce additional connectors according to demand.
- Delimited files (Tab delimited, comma delimited, etc);
- Spreadsheets.
Process
The process category has tools for
- Matching – dedupe single table or overlap two tables;
- Normalization – produce normalized version of input data;
- Grouping – group previously matched pairs for multiple runs;
- Union – union two data source with the same layout;
- Select – select a subset of the input columns to pass through to downstream components;
- Sample Groups – filter the Matching groups output to produce a sample of groups for each score.
Output
The output category has tools to output data to:
- Databases. The following database types are supported:
- SQL Server
- Snowflake
- MongoDB
- Delimited files (Tab delimited, comma delimited, etc)
- Spreadsheets
Workflow Canvas
Tools are dragged from the toolbox onto the workflow canvas, where they can be connected together:
