BIAccelerator - A template-based approach for rapid ETL development

Abstract

Business Intelligence projects include a big variety of challenges for all involved parties. Due to individual and changeable customer requirements or lacking standardization, there is much legwork which BI developers or consultants have to spend time on. BIAccelerator's template-based ETL development approach tries to tackle this issue by providing developers with a flexibly extendable environment which helps to quickly set up prototypes and which allows simplified change management. The tool allows importing metadata from source or destination data storages, adding additional knowledge (e.g. source - destination mappings or definition of Slowly Changing Dimension attributes) and generating executable ETL packages based on custom templates and collected metadata. This way, any changes (e.g. modification of source/destination entities or changes in the ETL processes) can easily be deployed. © 2012 Springer-Verlag.