We are creatures of habit. It's not easy to stop doing something the
way we've always done it. Especially when we think we are right (but
actually we're not). Let's explain.

I have discussed (some might
say preached) in many posts, articles, webinars, podcasts, classes and
client discussions that for any recurring data integration tasks IT
should use an Extract, Transform and Load (ETL)  tool.

This
certainly has been the best practice for enterprise data warehousing
projects in the Fortune 1000. This is where I got my early experience
in data integration and got to use the ETL tools that annually rank in Gartner's Upper Magic Quadrant and Forrester's Top Wave.
These ETL tools enabled IT groups and SI (system integrator) project
teams to tackle data integration challenges too complex and extensive
for hand-coding.

>>>continue reading this post on The Data Doghouse