Data blog

Activation of Cherry City Software OLEDB Provider for MySQL

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...
Read more
Create OLE DB connection to MySQL - edit the connection string

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.
Read more
SelectCompare edit query screen used to write SELECT statements for Excel spreadsheets

Write Select Statements for Excel Spreadsheets

SelectCompare allows for data comparison of Excel spreadsheets, as well as other data sources with a simple, unified interface.

You may be initially anxious about writing an SQL statement to pull data from your Excel, but it is pretty easy!

This post will show you a few examples of writing queries against your spreadsheet that you will be able to use right away for your Excel data comparison.

If you want to find out how to connect to an Excel workbook, please read another post on this blog - Compare Excel Spreadsheets

You will see below how to query Excel spreadsheets, specify ranges of columns and rows, and write simple filters that make SQL so powerful.

Read more
Screenshot of SelectCompare Edit project configuration screen for data comparison.

How to compare database schema with baseline

It is easy to create a comparison project to compare the schema of tables in a database and a saved baseline stored in Excel. After all, the database schema is stored...
Read more
Create Excel baseline for your data

Create Excel baseline for your data

The post describes how to create an Excel spreadsheet containing a snapshot or baseline of the data that can subsequently be used in data comparison. A baseline can be used in data comparisons, eliminating the need of creating temporary tables in the database and improving the control over the testing environment.
Read more
Filter comparison results

Filter comparison results

Do you know that you can switch portions on and off of the comparison result data? All you need to do is to click one of the icons above the results...
Read more
SelectCompare screen showing how to compare Excel spreadsheets and display data comparison results

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!

Read more
SQL Data Comparison - User Manual

SQL Data Comparison - User Manual

This blog post describes the process of creating and running 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 the definition of the key columns joining the data sets as well as other parameters.
Read more