How to verify Oracle database with DTM Data Scrubber?
The data verification process is a set of data checks execution. Each check validates that database item like field, row or table corresponds to required properties. For example, all phone numbers have the same format, all first names have the same capitalization, birth date is less than hire date, etc.
DTM Data Scrubber is designed to verify Oracle databases by user defined rules. I.e. the user defines "right data" and the software test real data with these rules. If the user defines "correction action" the software can remove some kind of data problems. For example: change phone number format, capitalize string or replace garbage data to NULL value.
The DB validation tool generates HTML (sample), Excel or plain text report that contains wrong data items and problem description, is applicable.
Download free demo version (?).
Why DTM Data Scrubber is suitable for Oracle database verification?
- It supports native connection with Oracle Call Interface (OCI)
- It understands Oracle-specific data types including BLOB and CLOB data
- The tool generates HTML or Excel report with data problems
- it is ready to the multivendor environment. The user allowed verifying Oracle database as well as DB2 or Sybase data
- There are 32 and 64-bit versions those compatible with Windows XP/Vista/7, Windows 8/10 (desktop), Server 2003/2008/2012
See Also
- How does the data verification process work?
- How does the data cleaning process work?