June 24, 2010 – A recent report from TDWI offers a checklist of 10 best practices that shows it’s time to raise the bar on integration expectations as the industry’s evolution has outpaced mindsets.

Philip Russom, senior manager for TDWI Research and author of the report, emphasizes that there's no silver bullet for "ideal" data integration. As the report explains, DI is a diverse discipline that makes use of a number of tools depending on one's business and technological requirements.

DI has undergone an expansion over the last decade and has reached a critical mass of multiple techniques used in diverse applications and business contexts. Vendor products have achieved maturity; users have grown their DI teams to epic proportions; competency centers regularly staff DI work; and DI as a discipline has earned its autonomy from related practices like data warehousing and database administration. Given all this change, it’s not surprising that many DI specialists and the colleagues who depend on them suffer misconceptions and out-of-date mindsets that need adjustment.

TDWI’s report explains a few things to understand about  DI:

  1. Data integration is a family of diverse but related techniques.
  2. Data integration practices reach across both analytics and operations.
  3. Data integration is an autonomous data management discipline.
  4. Data integration is the repurposing of data via transformation.
  5. Data integration is a value-adding process.
  6. Data integration is a green technology that makes data management more sustainable.
  7. A data integration solution should have architecture.
  8. A data integration solution should be the product of collaboration.
  9. Data integration must be coordinated with other data management disciplines.
  10. Data integration should be governed, but also contribute to governance.

"This report is an eye-opener, regardless of who the reader is," says Russom. "Many technical and business people are aware of data integration, but they’re not fully aware of all its capabilities and benefits." Russom explains that even DI specialists sometimes focus on specific tasks  for a deliverable and sometimes grope for meaningful ways to describe the goals of DI. "To help people voice these issues, the report reflects on DI’s true mission and altruistic goals. Hence, for any reader with an open mind, this report redefines data integration and its potential in modern, future-facing terms."
For more detail on these best practices, the report, Top Ten Best Practices for Data Integration, is available for free download.

Register or login for access to this item and much more

All Information Management content is archived after seven days.

Community members receive:
  • All recent and archived articles
  • Conference offers and updates
  • A full menu of enewsletter options
  • Web seminars, white papers, ebooks

Don't have an account? Register for Free Unlimited Access