Data Quality Technologies on your MDM Roadmap: ETL, SOA and ESB
Posted by 
Share this Post
Larry Dubov describes why a variety of data quality tools are helpful on your MDM roadmap
We write a lot about data quality, as do several other bloggers and thought leaders. Data quality is so very important to the success of MDM and other initiatives that it deserves a second mention on our MDM roadmap.
A few weeks ago, we talked about the importance of master data quality, and why processes and metrics must be implemented to help improve and maintain data quality.
But as you’re assembling your roadmap, you must also consider the tools and methods used to improve and maintain this data quality.
If MDM requires real-time or near real-time integration with operational systems, the state of service-orientated technologies (SOA infrastructure, Enterprise Service Bus (ESB) is important. (My colleague Marty Moseley has written about the relationship between SOA and MDM.)
These technologies can significantly facilitate an MDM implementation from the integration perspective. The absence of real-time integration infrastructure can become a considerable impediment for an MDM program.
Similar considerations apply to data quality technologies and ETL. Most companies embarking on MDM had previously acquired ETL and some data quality software. If this assumption does not hold, it is important to consider these technologies and their integration in the scope of MDM.
What other tools would you consider? When you’ve implemented MDM, have you seen this trend? Which tools are most likely to already exist in an organization?
This is part of a series, Building an MDM Roadmap. For other posts and a complete index, view the Table of Contents.
3 Responses »
Trackbacks
- Tweets that mention Data Quality Technologies on your MDM Roadmap: ETL, SOA and ESB | Mastering Data Management -- Topsy.com
- Tweets that mention Data Quality Technologies on your MDM Roadmap: ETL, SOA and ESB | Mastering Data Management -- Topsy.com
Leave a Response
Entries(RSS)
I think nne of the key technologies to include here is federation, the ability to synchronise an item of information across disparate systems increasingly plays a vital role in data quality and MDM.
In regards to ETL. I've found in the past that the relative simplicity of using ETL tools to plumb in ever larger, more complex information chains can actually lead to a degradation of data quality particularly where the new processes do not fall under stewardship or governance. ETL processes can often move defective data quickly around the organisation and in many cases process failures are not picked up resulting in further defects.
Interesting discussion Larry, thanks for posting.