Home > ETL Best Practices > ETL – ETL Tool versus Hand Coding

ETL – ETL Tool versus Hand Coding

The answer from the ETL Toolkit book is “It depends.”. I think the answer is still applicable today.

It’s unclear to me whether the author was referring Hand-Coded ETL solely to other scripting language methods, as apposed to database-stored procedures.

In my experience, many ETL teams in MS SQL Server shop are using a mixed approach that includes an SSIS ETL package for Extract and Delivery, and some hand coding/scripting in SQL mixed with an SSIS package for the middle steps of cleaning and conforming. Of cause all these steps are database-stored procedures. I haven’t seen any ETLs implemented in Object-oriented programming techniques or other scripting languages other than SQL.

The book focused on the advantages for ETL tool.

Tool-Based ETL Advantages

image

image

image

The only real advantage I can see from the book is:

image

Categories: ETL Best Practices
  1. No comments yet.
  1. No trackbacks yet.

Leave a Reply

Fill in your details below or click an icon to log in:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out /  Change )

Google+ photo

You are commenting using your Google+ account. Log Out /  Change )

Twitter picture

You are commenting using your Twitter account. Log Out /  Change )

Facebook photo

You are commenting using your Facebook account. Log Out /  Change )

w

Connecting to %s

%d bloggers like this: