Data blog RSS



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 in to a location where it is possible to execute a query. This takes time. This takes mental effort. This creates opportunity for mistakes. It turns out that there are many data comparison tools, varying with their capabilities and price. These tools can...

Continue reading



On Data Quality

Every organization needs data. It is often said that the data is the new oil fuelling the economy. This is certainly true. Organizations spend significant portions of their money and efforts to acquire and manage data. But the quality of the data is paramount to their investments. If the data is of poor quality, or is stored and managed in an inefficient way, its value to the organization is diminished. Risks associated with poor data quality Data quality, as part of the data management programme in an enterprise should be a concern of both technology and the business organization. The quality of the data should be clearly defined and required by the business, while the technology should ensure that it...

Continue reading



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 results of the data comparison. The whole process is actually very simple. 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. When you run command sccmd help compare, the utility displays a list of options and parameters that you can use when you compare data. When you scroll down a bit, you will notice options that control the behavior of the export. --export-to-excel (Default: false) Export results to Excel--excel-file-name Excel file name, if export option enabled. If...

Continue reading



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.

Continue reading



SelectCompare 1.3.5 released!

SelectCompare 1.3.5 has a number of improvements and the most important one is the ability to compare data using a new command line utility. The functionality allows for automation of data comparisons and reporting.

Continue reading