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
Requirements:
· Java 2 Standard Edition Runtime Environment
What's New in This Release: [ read full changelog ]
· SQL Power MatchMaker renamed to SQL Power DQGuru
· New command-line engine runner tool for improved batch processing functionality
· Improved reliability for Google Address Lookup transformer
· Improved reliability for Address Correction Engine
