DTM Data Scrubber 1.10.00
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.
Data verification rule can be applied to View.
Added column reference in 'by SQL query' check.
New options and settings.
Better detailization for execution report.
Custom database connections for verification rule.
Added 'Value Library' support.
WHERE clause for cleaning rules.
Better detailization for execution report.
Custom database connections for verification rule.
Added 'Value Library' support.
WHERE clause for cleaning rules.
Better detailization for execution report.
Custom database connections for verification rule.
Added 'Value Library' support.
WHERE clause for cleaning rules.
New regular expression engine options.
Known Values for verification (URL,e-mail, IP address, phone number, etc).
GUI enhancements: new hot keys, "stop" tool bar button.
Custom SQL statement as "Cleaning action"
Trim spaces action for left, right and both sides
Value "In result set" check for verification and cleaning
Console mode and new command line parameters
Ignore case option for string comparisons
Logging enhancements
Logging enhancements
...problems with text data files: removes duplicated...most suitable for clearing data received from...helps to make data better before import...a few text data file formats. There...creates useful HTML clearing report with problems...and clearing operations descriptions. Optional,...required. To review clearing process the cleaner...
...Complete network audit can be handled...network environments. Network Audit Advisor ensures each...retrieved. You can audit your network agentlessly...Flash drive Computer Audit Our enterprise-level computer...audit software lets any...business audit the whole network...and detailed computer audit of every node...
...Audit automatically and transparently...tracks changes to data in any column...Audit does everything for...Audit captures changes regardless...Audit catches it all...and records what data was changed and...Audit not only captures...Audit automatically generates triggers...to maintain an audit trail of all...
...The ApexSQL Audit viewer is a...pack of ApexSQL Audit Viewer is only...and management team.ApexSQL Audit Viewer is an...Audit Trail generation and...2005 or 2008.ApexSQL Audit Viewer includes powerful...can extract the audit data into meaningful...
...Windows is an audit software tool for...to identify unusual data distributions, procedures for...processes. Using this audit software, the auditor...and analyze the data population being tested...