Data blog
How to install MySQL Connection Provider
SelectCompare can connect any ODBC or OLEDB data source. You only need to install the data provider, and when it has been installed, you can use SelectCompare to connect to the respective database and compare its data with any other data set that you wish.
There are several different OLEDB providers for MySQL. In this example, I will use an older, but still popular provider implemented by Cherry City Software.Compare Excel Spreadsheets
Business and Data analysts, Developers, and QA testers often have to verify their data are 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. Have a look at the Excel data comparison use cases - there are plenty more!