DQ Now AUDIT fills gap in ETL & data cleansing software

Reduces risk & rework by providing a clear view of every change.

North Andover, MA -- December 3, 2002 -- DQ Now is pleased to announce a new data quality product, DQ Now AUDIT™. The first release of AUDIT compares data before and after a transformation or correction process to identify and categorize every changed value. AUDIT features interactive HTML reports that provide several views of the data and multiple levels of summary, allowing data analysts to validate the data in record time. By validating changes before applying to a production system or storing in a data warehouse, customers reduce the risk that unexpected results will lead to costly and time-consuming rework.

Market Need

With technology spending under tight scrutiny, the current priority of most IT departments is to increase the return from existing investments. Whether a data transformation project uses commercial data quality software, an ETL (Extract, Transform, Load) product, or in-house code, AUDIT's interactive reports reduce the time required to understand transformation results by a factor of 3.

"We've worked hard to organize and present the relevant data for maximum productivity," said Scott Lawton, President & CEO of DQ Now. "AUDIT fills a major gap in ETL and cleansing products. It can even be useful while evaluating these products, showing how each modified sample data and finding exact differences between any pair of results."


AUDIT is written in Java using J2EE technology wrapped around a bundled SQL database. AUDIT's Web-based interface provides intranet access to data analysts, end users, and management with no additional fees.


A software license costs $25,000. The price includes 2 days of professional services and free upgrades for 12 months. Several major additions are already underway.

Fixed-Price Services

The benefits of AUDIT are also available as a fixed-price service. $1,000 for a maximum of 10,000 records; $2,000 up to 100,000 records; $5,000 up to 1 million records. A free trial for a sample of up to 1,000 records is available to qualified companies.

Technical Background

Effective data transformation requires iterative refinement. Adjust parameters that drive the process; run it; review results to identify modifications that are not appropriate and to find any remaining problems -- then adjust parameters to address these issues and run again. AUDIT supports this process by providing a clear view of changes, with drill-down from high-level summaries to exact differences highlighted at the character level.

# # #

DQ Now, a division of PreFab Software, Inc., was created to bring data quality solutions to more projects at more companies. Since 1993, PreFab has been delivering innovative solutions as products and professional services, improving company productivity and individual job satisfaction by simplifying and automating tasks and workflows.

DQ Now, DQ Now AUDIT, DQ Now ETL Audit, DQ Now Cleansing Audit, and the DQ Now logo are trademarks of DQ Now.

Press contact: Scott Lawton, email2006@DQNow.com, 815-301-1907.