DQguru An easy-to-use, highly intuitive tool created by data warehouse designers
Download

DQguru Ranking & Summary

DQguru Tags

identify clean detect data cleaner remove duplicates dupe detector

DQguru Description

An easy-to-use, highly intuitive tool created by data warehouse designers You need your data to be clean, complete, and reliable. DQguru will cleanse your data, validate and correct addresses, identify and remove duplicates, and build cross-references between source and target tables, providing you with complete and accurate data and a consolidated view of your customers, products, business units, and other essential information.Whether you are building a data warehouse, a CRM system or a data mart, DQguru helps you ensure the integrity of your data.Source and Target Databases Supported:· PostgreSQL Version 8.0 or later· MySQL Version 5.0 or later· SQL Server 2000 or later· Oracle Version 8i or later· HSQLDB Version 1.8 or later Other databases, such as DB2/UDB, Apache Derby, Infobright, and Eigenbase have been used by the community but have not been certified. 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 · Standard APIs to support incorporation of your transformation process within a data load process, or can be run independently · Generates cross reference tables to link source system identifiers to target database identifiers · Can be used for initial or periodic data clean-up · Extensive support for many databases as for source and target 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 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 Requirements: · JRE Version 5.0 or later

DQguru Related Software