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. Click this link to send me a note →

Jim Love, Chief Content Officer, IT World Canada