Easing Into Master Data Management
MDM Insights
Information Management Online, November 26, 2008
In my blog, I‘ve outlined the five essential elements of master data management (MDM):
- An MDM hub of some type,
- Data integration or middleware,
- Data quality capabilities,
- External content and
- Data governance.
One of the challenges of MDM is trying to make progress in all five of these areas at once, while simultaneously working across the spectrum of people, process, technology and information.
Advertisement
Think of it as the “big bang” approach to MDM. You evaluate and select an MDM hub, and in the process, you discover that your organization doesn’t have adequate data integration or data quality tools available. And while working with the business on what internal source systems and external content providers need to be integrated with the new hub, you realize that your organization finally needs to get serious about data governance as well. It can be a little overwhelming.
In the current economic climate, some companies won’t have much appetite for spending large amounts of money on multiyear MDM projects, and I’ve heard people argue that MDM should always be phased in gradually. Every company’s situation is different, and MDM projects are sometimes so strategic that they are immune to short-term economic ups and downs.
However, what if your company wants the benefits of MDM, but can’t commit to large strategic initiative all at once? Does that mean that there’s no hope and the visionary data champions who work at those companies are out of luck? Thankfully, no. Start with data governance. Build a small data governance program around existing source systems, people and technology. It may be a far cry from the high-impact data governance organization you’d ultimately like to build, but it will get you started and allow you to socialize data governance as a concept, get the business owners involved and show some results that will hopefully make the rest of the process a little easier.
You’ll need to find the people currently working with critical master data and bring them together, changing their roles to include active data stewardship. You’ll need a small data governance council to make corporate policy on ownership questions and to make decisions on business rules and other issues. You’ll also need at least some support from the C-suite, so people don’t think you’ve started building a data governance fiefdom without active executive support.
On the data integration question, spend some time investigating your current integration capabilities. Hopefully, your company has evolved beyond the “custom code for everything” stage and at least has some extract, transform and load (ETL), metadata management tools or publishes and subscribes tools. If you’re lucky, you’ll find out that you’ve already got a robust data integration tool in-house and ready to go. If not, you’ll be better informed about past struggles with data integration at your company and better prepared to fold that into your MDM initiative at the proper time.
A similar approach to data quality is worthwhile. Figure out what data quality tools your company has and uses, and look into whether it would make sense to use them in your MDM plans. A surprising number of companies still have no data quality tools, and they rely on handwritten SQL programs or “eyeballing” thousands of rows of data in Excel to find and fix data quality issues. If that’s the case at your company, you may find that you’re not ready for MDM anyway, and that you’ve got to resolve one or more of these issues before tackling MDM.
Page 1 of 2.
