This resource is no longer available

What's the problem with hand-coding scripts for data integration?


Chances are, your company uses hand-coding for data integration somewhere in the organization. That's because hand-coding is the most common approach to data integration at most companies, according to analysts and user surveys. Many people hand-code data integration scripts successfully, delivering large projects with no problems at all.

Yet, some experts say hand-coding for data integration is a bad idea. They cite potential problems with repeatability, audibility and human errors. Instead, many suggest using data integration software, which requires additional time, training and money, but offers some measurable benefits. But, is it really worth it to invest in data integration software -- when hand-coding works perfectly well for so many? called on expert Rick Sherman to ask, 'what's the problem with hand-coding scripts for data integration, anyway?' Sherman, who's hand-coded data integration scripts himself, offers his frank insight and advice in this 20-minute podcast, appropriate for technical and business professionals.

Listeners will:

  • Find out why hand-coding is still the most prevalent method for data integration and learn its benefits and drawbacks
  • Learn more about alternatives to hand-coding -- data integration software tools and platforms, which span a wide range of price-points and functionality
  • Hear how to make a business case for data integration software, which can be challenging if your organization is used to no-cost, hand-coded approaches


Richard Sherman Athena IT Solutions founder Richard Sherman is the founder of Athena IT Solutions (, a Boston-based consulting firm that provides data warehouse and business intelligence consulting, training and vendor services. Sherman has almost 20 years of data warehousing and decision support systems experience, having built his first data warehouse and data mart in 1987. He has been designing and implementing relational database for decision support systems for years and has worked on over 50 data warehouse and data mart implementations across many industry groups, sourcing data from a variety of business applications. Sherman writes about data management topics for a variety of publications, speaks at industry events and serves as a judge for industry awards. He is a frequent contributor and data management expert at He can be found blogging at The Data Doghouse ( and can be reached at Read all of Sherman's contributions to here:,295582,sid91_gci1250429,00.html.
09 Apr 2008
Apr 9, 2008, 09:00 EDT (13:00 GMT)

This resource is no longer available.