Compare a database table with CSV file
SelectCompare can be very useful to simplify the mundane task of comparing data stored in CSV files. The CSV format is very often used to exchange data between various applications...Read more
DSN-less ODBC data sources
SelectCompare allows the user to configure a data source using the built-in operating system dialog windows. These windows look dated and sometimes can be a bit confusing. While it is possible to create a connection without a DSN, it can be quite cumbersome. Configuring connections to data sources is very easy with SelectCompare.Read more
Installation of Postgres ODBC driver
The post provides information about the installation process of the PostgreSQL ODBC driver that can be used to connect SelectCompare to the Postgres database.Read more
SelectCompare version 1.5.0 released!
We are happy to announce that a new version of SelectCompare has been released. The version has several improvements and bug fixes and should help you to compare the data providing an even better user experience.Read more
Assisted data comparison
Data comparison is an often overlooked problem that many IT professionals have to approach in their daily work. Without even realizing it, they spend a significant portion of their time comparing the data. In many cases the data comparisons are implemented ad-hoc: developers, QA testers, or DBAs write SQL queries that return rows with differences between data sets. Often the data to compare do not reside in the same data store - they have to be pulled into a location where it is possible to execute a query. This takes time. This takes mental effort. This creates an opportunity for mistakes.Read more
On Data Quality
Data quality is one of the most important values that an enterprise builds its success on. Without trust in the data, any decisions made by the enterprise are associated with risk and uncertainty. One of the ways to improve and ensure data quality in the processes within an organization is to have effective data testing procedures, which involve information flow controls, data comparison, and governance policies.Read more
Create comparison report with command line client
Following the previous post "Command line data comparison - how does it work?", I would like to show how to create a report containing the results of the data comparison.
The whole process is very simple. The command line client of SelectCompare offers you an easy way to export data to an Excel spreadsheet - the same format as the original version of SelectCompare creates.
Command line data comparison - how does it work?
Data comparison using command line interface of SelectCompare. The CLI allows for quick listing of defined connections and data comparison projects as well as for comparison of the defined data project by their ID or by name. The CLI can also export data to Excel, so that you can automate the report generation.Read more