|
|
|
DTM Data Scrubber, features list
Environment
| Additional client side software required |
ODBC, OLE DB or Oracle Call Interface. |
| What kind of unified database interfaces are supported? |
ODBC (32 bit), OLE DB or Oracle Call Interface. |
| 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 verification 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 |
|
|
|
|
|
See also
|
|
Articles
|
|
|
|
|
|
Related Products
|
|
|
|
|
|
|
|
|
|
|
|
• On-line