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, ODBC, Excel, & delimited files.
The first time you run Cortex, you will be prompted to enter an activation code.
Run Cortex. The main window is divided into 5 main areas.
The menu bar contains various application command buttons and a progress bar.
|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.|
The console shows messages. Configuration options let you choose which severity of messages to see, from:
The toolbox contains all the tools you can drag onto the workflow canvas divided into the categories: Input, Process, and Output.
The input category has tools to load data from:
- Databases (Access, ODBC, SQL Server, Oracle);
- Delimited files (Tab delimited, comma delimited, etc);
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;
- Group Sample – filter the Matching groups output to produce a sample of groups for each score.
The output category has tools to output data to:
- Databases (Access, ODBC, SQL Server, Oracle)
- Delimited files (Tab delimited, comma delimited, etc)
Tools are dragged from the toolbox onto the workflow canvas, where they can be connected together: