Hi, how can we help you?

Data Records Comparison System


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

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 desktop 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 Saves Valuable Software Development Time and Resources – and Eliminates Problems Caused by Bad Data

Request free access today to find out how.
Get Access


Features And Benefits
  • Easy To Use

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

  • 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 on your local machine. Nothing is transmitted or processed in the cloud.

  • Speed

    Compare automatically processes millions of records per minute and outputs the results to Excel, where more analysis can occur.

  • Support

    Dispatch Integration supports everything we build. We prioritize servicing your needs throughout the data integration and workflow development lifecycle.

Compare In 4 Easy Steps

  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.

  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 than one field can be selected.

  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.

  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).

Who Uses Compare

Compare Is For You!

Data Migration SpecialistsData 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.
Quality Assurance ProfessionalsCompare 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.
Business AnalystsBusiness Analysts use Compare to analyze datasets to find anomalies quickly. Cleaning datasets that have gotten out of sync is easier and faster using Compare. Differences can quickly be tagged for further review and correction or accepted as is. The output is in Excel format and can include both the original datasets plus a rich comparison sheet to conduct more analysis if required conveniently.
IT ProfessionalsIT professionals use Compare to help with regression testing during system upgrades. When applications are modified, reconfigured, upgraded, or replaced, Compare can save hours of time during testing to confirm system output is the same before and after any change. Simply take a “known-good” output file and compare it to a file generated by the changed system. Compare will flag any differences between the files in minutes.
DevelopersEnterprise Systems Developers use Compare to determine if their code is delivering the output they expect. Compare is a simple tool to use while doing unit tests to validate that output of systems in development matches legacy code and business requirements.
Engineers, Researchers, and many more professionsEngineers, Researchers, and many more professionals use Compare as a simple and fast tool to help them analyze data quickly.  Compare saves time and eliminates tedium, regardless of the type of data.
Data ScientistsData scientists use Compare to determine differences between datasets quickly. Data scientists typically have many analytical tools at their disposal, but Compare is the simplest and fastest way to look for quickly find differences between data files.


Need A Custom Solution?

Compare is very powerful as a standalone tool. It can also be integrated directly into your workflows to automatically compare datasets and notify you of any differences. Please contact us to discuss how we can build Compare directly into your business workflows.

Contact Us


  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
  Unlimited Access
  • Compare two comma-delimited files automatically
  • 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
  • Output to Excel
Download

Was this article helpful?

That’s Great!

Thank you for your feedback

Sorry! We couldn't be helpful

Thank you for your feedback

Let us know how can we improve this article!

Select atleast one of the reasons

Feedback sent

We appreciate your effort and will try to fix the article