advanced database analyzer

DataCleaner is an advanced data analyzing tool that can help you analyze, clean and profile the content of your database tables. The program works with all popular database models, including SQL Server, mySQL, Firebird, Oracle, PostgreSQL, MS Access, Open Office and many others. You can use DataCleaner to conform date formats, standardize values, search for data patterns and frequency, parse and manipulate strings, use advanced filtering methods and much more.

The DataCleaner results can be output to a staging table, CSV or Excel file, or they can be applied directly to the table. You can combine various filters and analyzing functions into a single operation, which provides you with a great deal of flexibility and efficient processing times. Other features include integrated support for EasyDQ validation queries (these require registration and are not always free), phonetic similarity comparison (via plug-in), statistical graphs, an option to compare data with external reference data, and more.
 DOWNLOAD