Data blog — Manual RSS




Activation of Cherry City Software OLEDB Provider for MySQL

If you read my previous post, How to install MySQL Connection Provider, you know that installation of the provider is just the first step. Yes, you can test the connection, but any attempt to run a query against your MySQL database will result with error saying "MySQL OLE DB provider has not been activated".  I was stuck for a while with this error - it doesn't direct exactly to a resolution of the issue. I analyzed the code of SelectCompare and found nothing wrong with it. I googled for some information pertaining to the error message. I found some old pages that referenced the message, but no solutions.  This made me thinking - after all, if Google doesn't show relevant results, there must...

Continue reading



How to install MySQL Connection Provider

SelectCompare can connect to without any problems. 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 you wish. OLEDB Data provider installation There is a number of different OLEDB providers for MySQL. In this example I will use one older, but still popular provider implemented by Cherry City Software. You can download the MySQL data provider from the download page. After you download the archive, extract its contents to a folder and run the setup. This is a pretty standard installation wizard. Follow the installation wizard until the installation is complete. You will have to have...

Continue reading



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