Take the Strategic View on Data Integration Projects

Loraine Lawson

There are a number of technological factors driving data-integration projects within organizations right now. Service-oriented architecture, modernizing or replacing legacy systems, Master Data Management and adding complex or data exchange projects all require data integration.


So, it's easy to view data integration as one technical component of an overall technology initiative. On the face of it, it's about making data accessible from one system or application to another. Technology can do that -- whether you choose to hand-code point-to-point or publish data in a data services layer, it's technology.


Yes, but ... it turns out when IT divisions take this approach to data integration, it creates unforeseen problems and misses opportunities to add business value.


I think part of the consternation about Master Data Management is that, possibly more than any other data-integration technology, MDM requires you to think beyond the technology -- a point well made in recent blog posts by Forrester's Rob Karel and Informatica's Rick Sherman, who writes:

"My contention has always been that MDM is not a product solution, but a process with the key ingredients being people and politics."

It's a point you'll see made time and time again with MDM: You simply can't do it without involving the business and answering some serious business questions about who owns the data and who's responsible for quality.


MDM makes it impossible to take a technology-only approach to data integration, but the fact remains it was always a bad approach -- as this column, "Ten common mistakes companies make in data integration," demonstrates.


It's written by Marcia Kaufman, a partner at the research and consulting firm Hurwitz & Associates. Kaufman does identify 10 common mistakes, but I would say that most of the 10 mistakes amount to one big mistake: Taking a technical, rather than strategic, approach to data integration.


Kaufman's list isn't about blaming IT or preaching about IT/business alignment. In fact, Kaufman points out in mistake number 9 -- "Business owners are reluctant to give up ownership of data" -- the business users can be just as guilty of ignoring the big pictures as IT.


No, the point isn't to cast blame for creating the problem. The point is to figure out how you can contribute to finding a better solution. And Kaufman's list is a good starting point for doing that.


If you're involved in B2B data exchange or dealing with complex and unstructured data, you should also check out this recent The Data Warehousing Institute (TDWI) whitepaper, "Complex Data: A New Challenge for Data Integration."


This 12-page paper takes an in-depth look at why organizations need to expand data warehouses to include complex data, which essentially includes all forms of data not contained in your typical tabular structure. This means both unstructured data, such as e-mails and text files; semi-structured data, which contains some metdata; and complex-structued data, such as the data found in XML structures.


This paper does an excellent job of addressing both the technical and the business challenges you'll encounter in a data integration project.

Subscribe to our Newsletters

Sign up now and get the best business technology insights direct to your inbox.


Add Comment      Leave a comment on this blog post
Jan 22, 2008 10:07 AM Francis Carden Francis Carden  says:
Thanks Loraine for finding such great info and giving us great insights.I've just posted over on the Article on 10 common mistakes.... my theme is this..Strategic on it's own *IS* the mistake. Tactical solutions as part of a strategic solution equals success. Tactical on it's own can work where time/money/lead is critical but put Strategic together, driven in parallel with tactical - you can't fail. IMHO. Reply
May 8, 2008 12:55 PM B2B Data UK B2B Data UK  says:
Great read, interesting information. Reply
Jul 16, 2010 5:36 PM Business Data Business Data  says: in response to B2B Data UK

Some really good points on B2B Data there.

Feb 23, 2011 5:19 PM Computer Servers Computer Servers  says: in response to Business Data

Yeah, It's all about taking a strategic view towards end objections and goals. We take a similar approach in regards to computer servers and fulfilling our customers IT objectives.

Mar 8, 2011 5:04 PM B2B Data B2B Data  says:

Hi Lorraine

What a great blog, really interesting

Apr 5, 2011 1:38 PM seo seo  says: in response to Francis Carden

to tell you the truth, i can't understand the difference between strategic and tactical. What's the difference?


Post a comment





(Maximum characters: 1200). You have 1200 characters left.




Subscribe Daily Edge Newsletters

Sign up now and get the best business technology insights direct to your inbox.

Subscribe Daily Edge Newsletters

Sign up now and get the best business technology insights direct to your inbox.