Data blog

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...

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.

The post provides information about the installation process of the PostgreSQL ODBC driver that can be used to connect SelectCompare to the Postgres database.

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.

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.

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.

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.