Skip to main content

Posts

Showing posts from February, 2010

Open Source tool for Data cleansing and Master Data Management

Last weekend SQL Power released an improved version of SQL Power DQguru (formerly known as SQL Power MatchMaker), one of the few open source tools for data cleansing and master data management (MDM) available. Version 0.96 brings a new feature that allows you to run SQL Power DQguru from command line. This allows you to integrate it into batch scripts and your ETL jobs.

As a BI consultant for SQL Power I have used SQL Power DQguru in different projects and it has made my job a lot easier. Some of the features I like the most are:

Easy connection to any database with JDBC drivers, incl. SQL Server, Oracle, MySQL, PostgresLets you create complex merge rules so your dependent data will always be updated when you merge records.You can combine over 25 steps to find possible duplicate data with a match rule, for example:Word CountRegular ExpressionsSubstringsRetain certain charactersTranslate Words, you can create your own translation rules.You can preview how your data will look like when y…