It's a lazy Friday in my neck of the woods. The skies are overcast, you can feel the rain coming and I'm feeling pretty uninspired to do the things I should be doing.
So when I first read Rick Sherman's most recent post in his series on the People, Process and Politics of data integration, all I could think was, "Man, that sounds like a lot of tedious work."
In the first two posts, Sherman focused on building political support for an enterprise-wide - even, dare I say, holistic - approach to data integration. But at some point, you have to actually start doing the work of creating this enterprise-wide approach, and that means digging through a lot of old and existing projects to figure out where you stand. And that's where an integration portfolio comes into play, says Sherman.
Like I said-it seems like a lot of work. First, you've got to inventory all the data integration currently happening in your organization. This is trickier than it sounds, because as I'm sure you know, data integration hides in a ton of projects, most of which go by three-letter acronyms. He specifically suggests you peek into the following projects:
And then there are all those nasty little spreadsheets business users love to harbor. Don't forget those. It's an awesome task to contemplate. Why would you go to all this trouble, just to make a list of data integration projects?
Actually, Sherman gives a lost of compelling reasons for why creating an integration portfolio is worth the effort:
Portfolios are always a ton of work, but they're a best practice for a good reason. As Sherman points out, "Enterprise data is a key investment, so treat data integration projects like investment portfolios."
You might just find there's gold in them there data mines.