Data blog RSS

Compare Excel Spreadsheets

Comparing Excel Spreadsheets - Why? Business and Data analysts, Developers and QA testers often have to verify their data is correct. Microsoft Excel is used to create a snapshot of "good data". Reports are captured and copied into Excel, data is exported and distributed as the model to use. SelectCompare allows you to compare Excel spreadsheets in the same way as other data sources. This post is going to show you the process of creating data connections to Excel workbooks and comparing data between two spreadsheets. Hava a look at the Excel data comparison use cases - there is plenty more! Where do I start? First, you have to install appropriate driver to connect to the Excel workbooks. It is an easy...

Continue reading

SQL Data Comparison - User Manual

This blog post describes the process of creating and running of a data comparison project. Data comparison projects are containers that define the connections to the data sources and the SQL queries that retrieve data from these sources. The data comparison projects allow for definition of the key columns joining the data sets as well as other parameters.

Continue reading

Installing SelectCompare

After you download SelectCompare installer, when you try to run it, Windows may warn you about running the downloaded program. The warning dialog looks differently on various versions of Windows, but the way it works is similar. The default button cancels execution of the installer. Here's how it looks on Windows 10: In order to execute the downloaded installer, you have to click "More info" link.  The second dialog box shows information about the creator of the installer, in our case Maycove Studio Ltd, the creator of SelectCompare. In order to run the installer, you should click "Run anyway" button. The installation will proceed as usual. You may receive additional warning from UAC that the program is going to make...

Continue reading