Building ETL processes, Childsplay ?!?

From Information to Knowledge … Connecting the dots

This morning I was listening to my favorite dutch radio station BNR (Business News Radio). They were talking about the statement of president Obama on the terrorist act on .

Twitter is HACKED !!!

This morning I was trying to start my micro blogging and found out that it did not work… Could be the customers network I thought, but … on the phone there was n.

Modelling Business Data the Vault Way

In my post about modelling the RECORD SOURCE in a data-vault-like way, in 2007 (See POST), I got a reaction by Rob Mol (see Comments on the POST). I reacted by posting my a.

Datavault and Coffee machines

Every day at my customers site, I start with the question; “Anyone coffee?!?!?”. You might think what this questions has to do with datavault modelling.The answe.

Browse: Home → Ab Initio → Building ETL processes, Childsplay ?!?

Building ETL processes, Childsplay ?!?

05 January 2008
Ab Initio, Informatica, Microsoft, SAS, Wisdom Tools
8 Comments

In 1996 Building ETL Processes is ChildsplayI started building ETL processes in the SAS System for a customer. This Customer needed a metadata driven approach for their Data Warehouse solution.

We build a nice collection of datasets / tables which contained the metadata about the source, the target and the transformations. This was my very first encounter with metadata drive ETL processes. There was no tool at that time like Informatica PowerCenter, Microsoft SSAS and SAS Data Integrator. All was built in pure macro code which accessed the metadata and created code on the fly.

Now 12 years later, I am again involved in building a metadata drive ETL factory, which can be configured and driven by non-technical people. We now-a-days have nice tools that can help these people in their job of building and configuring ETL processes. The only problem is that the out-of-the-box solutions which are provide never are suffient for the person needs.

For me this behaviour of the people and market has led to a first attempt to write an article about how child toys can be used to visualise the needs for ETL processes. You might call me the LEGO / DUPLO man, because multiple customers already heard my story about these childrens toys and how this affects their ETL processes they are building.

I hope I will be able to show the article on this BLOG soon (I will be starting an ARTICLE WRITING COURSE this month), until that time enjoy the YOUTUBE video below. This is an other visualisation of what can be done with LEGO !!!

Dutch JUMP Style