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:
- Data integration is a family of diverse but related techniques.
- Data integration practices reach across both analytics and operations.
- Data integration is an autonomous data management discipline.
- Data integration is the repurposing of data via transformation.
- Data integration is a value-adding process.
- Data integration is a green technology that makes data management more sustainable.
- A data integration solution should have architecture.
- A data integration solution should be the product of collaboration.
- Data integration must be coordinated with other data management disciplines.
- 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.
Valerie Valentine is senior editor for Information Management. You can follow her on Twitter @ValValentineIM.










Be the first to comment on this post using the section below.