Enterprise ETL - Keep It Simple Stupid

May 28, 2008

enterprise-etl I wish I had a dollar for every time I see a consultancy roll in with a development framework of one sort or another that is the answer to all our problems. More often than not these cobbled-together code-bundles are merely a foot in the door for bringing in legions of more consultants to utilise the framework to build the solution. It’s all a big con. The value added by these frameworks is often less than the value of building the solution from scratch.

Personally I always apply the KISS principle. Keep It Simple (Stupid!). If the solution isn’t lean and straight-forward then it is likely to be more trouble than it’s worth.

Generally a simple ETL design can be applied for the majority of development. Ensuring that adequate coding standards are developed in conjunction with templates, can help with code consistency, simplicity and maintainability.

Comments

Got something to say?