« changing the rules of the game | Main | A practitioner's view on data integration worst practices »
November 24, 2009
A practitioner's view on data integration best practices
As part of last week's webinar on end-to-end data integration lifecycle managment, Phil Watt from Emunio Consulting spoke about best practices in managing a data integration lifecycle based on his experiences as a senior data integration consultant who has worked on many ETL/DI projects over the years.
Phil said that it is essential to have strong business sponsorship and involvement on any meaningful data integration project. He also emphasized the importance of strong governance and stated that one doesn't have to be overly bureaucratic when managing a project but felt that an appropriate level of governance is essential for every "successful" project. In this context, he also underscored the importance of understanding and communicating the roles and responsibilities throughout the team and making sure that the business understands their responsibilities as well.
He went on to say that data profiling and discovery are absolutely crucial and time and time again he has seen that companies forgo this step and then come to realize the problems in the data as they show their work to the business. He also referred to the need for strong metadata management and the need to adapt best practices design patterns. He also talked about the typical 80/20 rule where 80% of the data integration effort can often be accomplished in 20% of the time, so long as the project team focuses on the high value business requirements first and delivers on less important capabilities as time permits.
Click here to play back the entire archived webinar.
Michael Waclawiczek
VP, Marketing
Posted by expressor software at November 24, 2009 12:15 PM
Twitter 
LinkedIn 
YouTube