DTM Data Scrubber is a set of intelligent tools for data verification (audit) and scrubbing (cleaning). Depending on user-defined rules and data properties, the program either creates a report about the actual state of affairs or performs database data correction.
The program supports two sets of rules - for verification and for cleaning. The rules of the first type describe what the correct data must look like. The rules of the second type describe the types of problems that can happen to data values. Together with this type you can specify the action, the program should perform for problem correction. There can be several rules of this type for each field and the program will perform the action corresponding to the detected conditions.
The program generates a report based on the results of verification or scrubbing. Current version of the tool supports HTML, Excel or tab-delimited text report formats.
DTM Data Scrubber is a Win32 application that compatible with the following operating systems: Windows XP, Windows 2003/2008/2012 Server family and Windows Vista, 7, 8/10 (desktop). The 64-bit edition is also available.