In my blog, Ive 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.
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 doesnt 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 wont have much appetite for spending large amounts of money on multiyear MDM projects, and Ive heard people argue that MDM should always be phased in gradually. Every companys 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 cant commit to large strategic initiative all at once? Does that mean that theres 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 youd 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.
Youll need to find the people currently working with critical master data and bring them together, changing their roles to include active data stewardship. Youll need a small data governance council to make corporate policy on ownership questions and to make decisions on business rules and other issues. Youll also need at least some support from the C-suite, so people dont think youve 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 youre lucky, youll find out that youve already got a robust data integration tool in-house and ready to go. If not, youll 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 thats the case at your company, you may find that youre not ready for MDM anyway, and that youve got to resolve one or more of these issues before tackling MDM.