Decision time: Automated data integration tools versus manual coding

August 30, 2012
95 Views

Automated-manualSearchDataManagement recently interviewed me about

Automated-manualSearchDataManagement recently interviewed me about automated data integration tools versus manual coding:

Data integration is often still done by hand, through SQL coding and stored procedures, according to Rick Sherman, founder of consultancy Athena IT Solutions in Stow, Mass. Writing SQL integration scripts can be straightforward and seemingly inexpensive — but data integration might be one case where handmade is no longer best, Sherman says in this interview with SearchDataManagement.com. He also discusses the different kinds of data integration tools now available and offers advice on how to evaluate them and choose the technology that best fits an organization’s needs.

How prevalent is manual coding for data integration these days? Is it still a common practice in a lot of organizations?

Rick Sherman: It’s very, very prevalent today, and I’ll say unfortunately. It’s still, I think, the most pervasive type of data integration that’s happening in companies, big and small…>>>read the rest of this answer and the other Q&A’s