DTM Data Scrubber Features

Environment

Operating systems support Windows XP, Vista, 7, Windows 8/10 (desktop), Server 2003, 2008, 2012.
Additional client side software required ODBC subsystem, OLE DB or Oracle Call Interface with driver for your database.
What kind of unified database interfaces are supported? ODBC, OLE DB or IDAPI.
Does the product support desktop database formats? Yes: Access, DBF, Excel, Paradox.
Does the product support any DBMS-specific features? Yes, for Microsoft SQL Server, Oracle, DB2, Sybase, MySQL, PostgreSQL and Interbase/Firebird.

Data Verification Options

Does the tool support regular expression as verification rule? Yes.
Can the verification rule be based on result of SQL query execution? Yes, against same database only.
Can the user define column to column dependencies? Yes, with reference or expression.
Has the tool predefined patterns for well known data formats? Yes, for URL, e-mail, phone no, etc.
Does the tool provide lists of popular data like country codes? Yes, it is value library.
What reporting options are available for data verification process? HTML, text or Excel compatible report.

Data Cleaning Process

What kind of data modifications are provided? Change value to constant or expression, to NULL value, value trimming, replace substring to specified value.
Does the tool support regular expressions in cleaning rule? Yes.
Can the tool drop 'wrong' data rows? Yes.
Can the validation tool execute user defined SQL statement for wrong data item? Yes.

Assistance/Help

Is help for the tool built into the product? Yes.
Is help for the tool available online? Yes, see online help