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?

Share

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

Featured Articles

Cybersecurity in 2024: Priorities and challenges for Canadian organizations 

By Derek Manky As predictions for 2024 point to the continued expansion...

Survey shows generative AI is a top priority for Canadian corporate leaders.

Leaders are devoting significant budget to generative AI for 2024 Canadian corporate...

Related Tech News

Tech Jobs

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.

Tech Companies Hiring Right Now