Abstract
Within Business Intelligence systems (BI systems), ETL (extract, transform and load) processes move numerous data from heterogeneous sources to a data warehouse and become more complex with growing enterprise size. To keep costs and expenditure of time for maintenance and evolution of those systems slight, ETL processes should be documented. A well-documented system also leads to higher transparency regarding the origin and processing of data, which increases the system’s acceptance by business users. However, the preparation of high-quality software documentation is sophisticated and therefore it usually only takes place in the design or development phase of BI systems. To ensure that the documentation is always updated, an automatic generation is advantageous. The paper at hand presents a conceptual framework for automated configurable ETL documentation generation. The presented framework creates benefits for BI systems developers as well as business users.
Recommended Citation
Jacobi, Frieder; Krawatzeck, Robert; and Hofmann, Marcus, "Meeting the Need for ETL Documentation: A Model-driven Framework for Customizable Documentation Generation" (2012). AMCIS 2012 Proceedings. 23.
https://aisel.aisnet.org/amcis2012/proceedings/EndUserIS/23
Meeting the Need for ETL Documentation: A Model-driven Framework for Customizable Documentation Generation
Within Business Intelligence systems (BI systems), ETL (extract, transform and load) processes move numerous data from heterogeneous sources to a data warehouse and become more complex with growing enterprise size. To keep costs and expenditure of time for maintenance and evolution of those systems slight, ETL processes should be documented. A well-documented system also leads to higher transparency regarding the origin and processing of data, which increases the system’s acceptance by business users. However, the preparation of high-quality software documentation is sophisticated and therefore it usually only takes place in the design or development phase of BI systems. To ensure that the documentation is always updated, an automatic generation is advantageous. The paper at hand presents a conceptual framework for automated configurable ETL documentation generation. The presented framework creates benefits for BI systems developers as well as business users.