About Site Map Submit Contact Us Log in | Create an account
Create an account Log In
Average Rating
User Rating:
Visitors Rating:
My rating:

Write review
See full specifications

linux default iconSQL Power DQguru Publisher's description

Data Cleansing & MDM Tool

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

Here are some key features of "SQL Power DQguru":

В· 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

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

System Requirements:

В· Java 2 Standard Edition Runtime Environment
Program Release Status: Minor Update
Program Install Support: Install and Uninstall

SQL Power DQguru Tags:

Click on a tag to find related softwares

Is SQL Power DQguru your software?

Manage your software

Most Popular

linux default icon A2Billing 1.6.0
A2Billing is a billing system interactive with Asterisk to give any Telecom company traditional offering VOIP... Read more
linux default icon FrontAccounting 2.3.10
FrontAccounting is free and released under the GNU General Public License.
linux default icon PgAdmin III for Linux 1.14.1
pgAdmin is the most popular and feature rich Open Source administration and development platform for... Read more
linux default icon RazorSQL for Linux 5.6.3
RazorSQL is an SQL query tool, database browser, SQL editor,....
linux default icon Salat Book 1.00
Salat / Namaz prayer database and tracking application