SQL Power DQguru is a handy and comprehensive application will easily clean your data, identify or remove duplicates and validate addresses.
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 "SQL Power DQguru":
· 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
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
· JRE 6.0 or later
· Screen Resolution 1280 x 800
· Minimum memory SQL Power DQguru (without Address Correction) - 512 MB
· Minimum memory SQL Power DQguru (with Address Correction) - 2 GB
What's New in This Release: [ read full changelog ]
· Updated the bundled SQL Server driver so that it supports SQL Server 2008 out of the box