Business Intelligence Network
business intelligence resources

Blog: Dan E. Linstedt

« Profitability in all business cycles - part 2 | Main | Profitability in all business cycles - part 3 »

ETL /ELT Scorecarding

I'm happy to see that Doug Laney has joined us here in the blog space. Not to take anything away from his valuable services, but I also would like to say that we are offering a free ETL score-carding mechanism. This is a very short entry to show you where the score-card lives. The downloadable score-card is free/empty. and has no vendors.

The free ETL/ELT scorecard is downloadable at: www.MyersHolum.com

My thoughts on the ETL/ELT scorecard are as follows: ETL and ELT are two different utilities and really shouldn't be compared except in areas of metadata, GUI development (no-code environment during development), flexibility, connectivity. Unfortunately comparing ETL to ELT in the transformation areas is unfair, but necessary. It is important to evaluate which transformations are provided to you by the RDBMS vendors, and which you have to add to the RDBMS (UDF - User Defined Functions) yourself.

However, the true nature of this scorecard looks at sourcing, targeting, metadata, transformations, market stability, cost, number of outside consulting firms, cost of available consulting knowledge, and a few other key metrics. Please feel free to download, and post your comments, questions, remarks or improvements here.

Thanks,
Dan Linstedt
CTO, Myers-Holum, Inc.
daniel.Linstedt@myersHolum.com

  Posted by Dan Linstedt on May 27, 2005 4:29 AM |

Comments

Hi Dan - great blog!

I am the Group Program Manager for SQL Server Integration Services at Microsoft. Given your interest in the ETL and Data Integration space, I wonder if you would be interested in seeing some of what we are doing over LiveMeeting. If so, mail me back and we can set something up.

Meanwhile, I would certainly be interested in looking at the scorecard. Should I just register, or perhaps you would rather mail me?

Anyway, great blog, and if you're interested in following up, let me know.

Donald Farmer

PS - the URL I entered for this comment is my own blog. _Very_ unofficial. Marketing most certainly do not endorse me!

Posted by: Donald Farmer | May 27, 2005 9:25 PM

Hello,

I am not able to download the scorecard form the website. Is any other link available?

Thanks
Jose

Posted by: jose | June 3, 2005 2:23 AM

This has been fixed, and is now operational.

Cheers,
Dan L

Posted by: Dan Linstedt | June 8, 2005 1:16 PM

Post a comment