Defining ETL worfklows using BPMN and BPEL

Decisional systems are crucial for enterprise improvement. They allow the consolidation of heterogeneous data from distributed enterprise data stores into strategic indicators. An essential component of this data consolidation is the Extract, Transform, and Load (ETL) process. In the research literature there has been very few work defining conceptual models for ETL processes. At the same time, there are currently many tools that manage such processes. However, each tool uses its own model, which is not necessarily able to communicate with the models of other tools. In this paper, we propose a platform-independent conceptual model of ETL processes based on the Business Process Model Notation (BPMN) standard. We also show how such a conceptual model can be implemented using Business Process Execution Language (BPEL), a standard executable language for specifying interactions with web services.

• Type: Conference
• Year: 2009
• Where: DOLAP
• Authors: Zineb El Akkaoui, Esteban Zimányi
• Keywords: Conceptual Model, DOLAP 2009, ETL Processes, Information Management, Platform-independent Conceptual Model