DataCleaner

DataCleaner is a software application that supports a long list of databases and provides users with a simple means of creating new databases, analyzing them and creating reports based on the information gathered.

This tool is portable, which means that the installation process can be bypasses. As a result, unlike installers, it is not going to update the Windows registry and hard drive with new entries without your permission and no leftovers will remain on the disk after its removal.

Another noteworthy aspect is that you can easily copy the program files to an external storage unit, such as a USB thumb drive and thus, take DataCleaner anywhere with you and run it on any PC you come in contact with.

Multiple instances of this utility can be launched, a feature which helps you multi-task with more ease. It supports quite a wide range of databases, including CSV, XLS(X), MDB, DBF, TXT, XML, ODB, MongoDB, MySQL and H2, and enables you to analyze them all in regards to certain aspects, such as date gap, month distribution, Boolean, patterns, strings and character sets.

In addition to that, you can lookup synonyms, convert databases to Boolean, date, number and string, build key/value maps or lists, view metadata, generate IDs and timestamps, capture changed records and use dictionary matcher.

Projects can be saved to the hard drive using an XML file extension, so that you can resume it at a later date. Synonym catalogs, dictionaries and string patterns are provided, yet you can also upload new ones

In conclusion, DataCleaner proves to be a pretty efficient piece of software when it comes to opening and analyzing almost any database. It does not hinder the computer’s performance, the response time is good, the interface is accessible to all users and there are sufficient options incorporated to keep you busy for quite a while.