DWauto­matic

The devel­op­ment and main­ten­ance of ETL pro­grams is the biggest cost driver of DWH pro­jects. For this reason, many com­pan­ies have decided to use an ETL tool such as Ab Ini­tio, IBM InfoSphere Data­Stage or Inform­at­ica Power­Cen­ter. The strength of such tools lies in their abil­ity to map com­plex busi­ness logic in trans­form­a­tion pro­grams (often a core task in data ware­house projects).


In addi­tion to these tasks, how­ever, we are increas­ingly find­ing in data integ­ra­tion pro­jects the require­ment to integ­rate new source sys­tems into the DWH, where the data struc­tures in the DWH are sim­ilar to the struc­tures of the source sys­tem, but delta detec­tion, versioning/historization and simple trans­form­a­tions are to be car­ried out; in addi­tion, auto­matic detec­tion of struc­tural changes and their propaga­tion is often required. The grow­ing import­ance of these desired func­tion­al­it­ies goes hand in hand with the increas­ing spread of the data vault approach. Some ETL tools are often not par­tic­u­larly suit­able for these tasks.