Compare: A Powerful Data Comparison Tool

Dispatch Integration’s smart data comparison engine compares thousands of records in minutes.

Data Records Comparison System

Most enterprises have dozens or hundreds of datasets that need to be analyzed and validated whenever systems, processes, or populations change. Dataset analysis can be a tedious and repetitive job, even when using advanced Excel functions.

Dispatch Integration’s Compare is a fully automated, secure, and easy-to-use web application that rapidly compares .csv and other comma-delimited files to find differences between datasets. It is a smart, simple and fast data comparison solution that eliminates hours of work normally required to compare data within large files.

Compare Works In 4 Easy Steps

Step 1: Select Files to Compare

Select two comma-delimited files with the same column headers. The ID number of each file is used to match the records between the files.

Step 2: Select Key Fields

After selecting the files that need to be compared, select a key field by using the options available (column headers from the files). More that one field can be selected.

Step 3: Select Output Options

The output file will contain more columns than the original files being compared. This allows the user to filter files that have differences in datasets, and decide how to deal with the identified discrepancies.

Step 4: Compare Output In Excel

The output highlights the discrepancies between files and provides users with information such as the number of records in each file, the number of unique records between the two files, the number of differences detected, and the total number of warnings (e.g. records with identical ID numbers).

Compare has greatly reduced the amount of time I need to analyse “before” and “after” files for our semi-annual upgrade testing. It allows me to quickly focus on where the differences in data are and easily code them as “explainable” or “unexplainable”.

Lisa
Senior Business Analyst – Retail

Compare Saves Valuable Software Development Time and Resources – and Eliminates Problems Caused by Bad Data

Free Web App

Features And Benefits

,

Easy To Use

Compare is a powerful data comparison tool designed to be simple and easy to use.

m

Multiple Uses

Compare can be used by business analysts, data scientists, integration specialists, and other software professionals to quickly and accurately find the differences between datasets.



Powerful

Large files consisting of hundreds of columns and hundreds of thousands of rows can be processed in a matter of minutes.

~

Secure

Compare is secure. All data processing occurs in memory. No data is stored or saved in the cloud.

}

Fast

Compare can process millions of records in minutes and outputs the results to Excel for further analysis.

Compare Is For You!

Developers

Developers and Application Managers use Compare to ensure their code is delivering the output they expect. Use Compare during unit testing to validate the output of new enterprise systems matches legacy code and business requirements.

Engineers, Researchers, and many more professions

Professionals use Compare as a simple and fast tool to help them analyze data quickly, often in conjunction with more sophisticated data analytics systems. Compare saves time and eliminates tedium, regardless of data type.

Data Scientists

Data scientists use Compare to quickly determine differences between datasets. Compare complements more sophisticated analytical tools, and is the fastest way to quickly find differences between data files.

IT Professionals

IT professionals use Compare for regression testing and data validation during system upgrades. When applications are modified, reconfigured, upgraded, or replaced, Compare is an invaluable tool to confirm system output is consistent with any application change.

Simply export a “known-good” output file from the current system and compare it with a file generated by the new system. Compare will flag any differences between the files in minutes.

Business Analysts

Business Analysts use Compare to quickly analyze datasets from business systems to detect anomalies. Data quality often deteriorates across integrated business systems, and cleansing data can be tedious. Compare can detect data anomalies between systems in minutes, which can be tagged for further review, or accepted as is.

The output is in Excel format and can include both the original data plus a rich comparison sheet to facilitate more analysis if required.

Quality Assurance Professionals

Compare can help QA professionals quickly analyze datasets to pinpoint quality issues or anomalies. Whether you’re looking for temporal changes, piece-to-piece changes, within piece changes or population to population changes, Compare will help you quickly discover potential quality problems.

Data Migration Specialists

Data Migration Specialists move data between internal and external systems. Compare lets Data Migration Specialists compare data loads from different times or systems to ensure differences are understood and bad data doesn’t inadvertently pollute systems.

Differences can easily be flagged in the output file for further investigation or acceptance.

Get Compare Today

Free Download

Get Started Today

Compare two comma-delimited files automatically
Output to Excel
Selection of single or multiple keys
Choose to show all records or just differences
Secure – all data remains on your computer
Powerful – file size only limited to memory on your computer

DOWNLOAD NOW