O'Reilly logo
  • James Martin thinks this is interesting:

However, there are several reasons that using an ETL tool is an industry standard best practice:

  • Self-documentation that comes from using a graphical tool. A hand-coded system is usually an impenetrable mess of staging tables, SQL scripts, stored procedures, and operating system scripts.
  • Metadata foundation for all steps of the ETL process.
  • Version control for multi-developer environments and for backing out and restoring consistent versions.
  • Advanced transformation logic, such as fuzzy matching algorithms, integrated access to name and address deduplication routines, and data mining algorithms.
  • Improved system performance at a lower level of expertise. Rela...


These are right in line with the reasons I gave for the question "Why an ETL Tool?"