SQL Power DQguruData Cleansing & MDM Tool | |
Download |
SQL Power DQguru Ranking & Summary
Advertisement
- License:
- GPL v3
- Price:
- FREE
- Publisher Name:
- SQL Power Group Inc.
- Publisher web site:
- http://www.sqlpower.ca/
SQL Power DQguru Tags
SQL Power DQguru 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 & CorrectionSQL 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: · 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
SQL Power DQguru Related Software