Product Home
DTM Data Scrabber Online Documentation Prev Page Prev Page
General Information
Product Profile
Data Verification
Data Scrubbing
Connect
Quick Start
Direct Connection
Connect to Desktop File
Data Sources
DSN File
OLE DB Connection
Connection Profile
Connection Information
Troubleshooting Guide
Types of Data Checks
Column to column
Expressions
Regular Expressions
Actions
Cleaning Script
Execution Console
Report Viewer
Project Properties
Project Report
Command Line
Console Mode
Log Viewer
How to...
Settings
Hot keys
SQL Console
Additional Information
License
Demo and Full versions
Support
Install
Uninstall
Upgrade
Trademark Information
Database Tools
Glossary

Product Profile

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: data verification rule list

DTM Data Scrubber is a true Win32 application, known to be compatible with the following operating systems: Windows XP, Windows 2003/2008 Server family and Windows Vista/7.