SQL Power DQguru 0.9.7

Data Cleansing & MDM Tool
SQL Power DQguru
  2 Screenshots
SQL Power DQguru is a database software which helps you cleanse your data, validate and correct addresses, identify and remove duplicates, and build cross-references between source and target tables. This provides business users with complete and accurate data, and a single 360-degree view of all business entities, such as customer, product, representative, employee, supplier or business unit.

Address Validation & Correction

SQL Power DQguru Enterprise Edition includes access to Canada Post national address data verification. (Support for US Postal Service validation is also planned.)

Validating against Canada Post-approved standards significantly reduces mailing costs by eliminating wasted postage from undeliverable or duplicate mailings.

- Generates cross reference tables to link source system identifiers to target database identifiers
- Extensive support for transformation and matching functions:

 * Concatenation
 * Double Metaphone, Metaphone, Refined Soundex, Soundex phonetic coding
 * Alphabet case conversion
 * String substitution
 * Substring and substring by word
 * Word substitution through the translation of words or groups of words
 * Merge rules for column, table and related table merges

- Varying levels of data transformation are also supported to help manage the development and execution of data cleansing processes:

 * The Match Engine identifies duplicates, storing the results in a target table, without modifying the source data
 * The Merge Engine removes duplicate records from your source data according to the rules you have defined
 * The Cleansing Engine replaces records in your source data with reformatted data as per your rules

- Extensive support for many databases as for source and target data

Main features:

  • Intuitive GUI allows for quick adoption and use by data analysts
  • Intuitive 'transform' process interface allows you to rapidly build and deploy data conversion work flows
  • Users can define their own data matching criteria
  • Duplicate verification via SQL Power's innovative interface
  • Merge duplicates and their related data
  • Can be used for initial or periodic data clean-up

last updated on:
March 4th, 2010, 9:24 GMT
price:
FREE!
homepage:
www.sqlpower.ca
license type:
GPL v3 
developed by:
SQL Power Group Inc.
category:
ROOT \ Database \ Administrative frontents
SQL Power DQguru
Download Button

In a hurry? Add it to your Download Basket!

user rating

UNRATED
0.0/5
 

0/5

Rate it!
2 Screenshots
SQL Power DQguru
What's New in This Release:
  • Updated the bundled SQL Server driver so that it supports SQL Server 2008 out of the box
  • Fixed an issue on OS X where the log file chooser on the Engine Settings screen didn't allow you to choose a new file
read full changelog

Add your review!

SUBMIT