Open source database cleaner unveiled

SQL Power Group Inc., a Toronto-based data warehousing vendor, has published the source code of Power Matchmaker, its open source data cleansing tool.

Designed to eliminate duplicates and build cross-references between sources and data tables, Power Matchmaker can be run against an entire database. It also validates and corrects address information. It builds cross reference tables for linking source system identifiers to target primary keys and merges duplicate data.

The vendor claims this is a low-cost alternative to SAS Institute’s Data Flux.

Last July, SQL Power Group published the source code to Power Architect, it’s data modelling tool.

See also BI Specialist takes data modelling tool open source

Would you recommend this article?


Thanks for taking the time to let us know what you think of this article!
We'd love to hear your opinion about this or any other story you read in our publication.

Jim Love, Chief Content Officer, IT World Canada

Featured Download

Related Tech News

Our experienced team of journalists and bloggers bring you engaging in-depth interviews, videos and content targeted to IT professionals and line-of-business executives.

Featured Reads