DQguruData Cleansing & MDM Tool | |
Download |
DQguru Ranking & Summary
Advertisement
- License:
- GPL v3
- Price:
- FREE
- Publisher Name:
- SQL Power
- Publisher web site:
- http://www.sqlpower.ca/page/architect
DQguru Tags
DQguru Description
Data Cleansing & MDM Tool The DQguru application was created to clean data by validating and correcting addresses, detecting duplicates and build cross-references. 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. Here are some key features of "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 · Validates and corrects address information · With the optional add-on, meets the verification requirements for the Canadian Postal Services, with support planned for the US Postal Service · 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 · Can be used for initial or periodic data clean-up · Extensive support for many databases as for source and target data Requirements: · Java 2 Standard Edition Runtime Environment
DQguru Related Software