BIAccelerator: a template-based approach for rapid ETL development

  • Authors:
  • Reinhard Stumptner;Bernhard Freudenthaler;Markus Krenn

  • Affiliations:
  • BIA Business Intelligence Accelerator GmbH, Hagenberg, Austria;Software Competence Center Hagenberg GmbH, Hagenberg, Austria;BIA Business Intelligence Accelerator GmbH, Hagenberg, Austria

  • Venue:
  • ISMIS'12 Proceedings of the 20th international conference on Foundations of Intelligent Systems
  • Year:
  • 2012

Quantified Score

Hi-index 0.00

Visualization

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.