The SQL Power DQguru Data Cleansing & MDM Tool 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.
Features include:
- 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
- Generates cross reference tables to link source system identifiers to target database identifiers
- Extensive support for many databases as for source and target data
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.