DTM Data Scrubber is a set of intelligent tools for data verification and scrubbing
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 should look like so each table field can have only one rule of this type. 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.

Keywords: data cleaning, data scrubbing, data clearing, data audit

Recent Changes: Better diagnostics for date and time format.
Report design and data presentation improvements.
Better support for SQLite and MySQL databases.
Pattern engine and RegExp engine updates.

Install Support: Install and Uninstall

Supported Languages: English

Additional Requirements: ODBC, IDAPI, OLE DB or Oracle Call Interface