Extracting data from heterogeneous data sources and transferring data into the data warehouse system is one of the most cost intensive tasks in setting up and operating a data warehouse. Special tools may be used to connect different sources and target systems. In this paper, we propose an architecture which enables the flexible integration of data sources into any target database system. The approach is based on the idea of splitting the classical wrapping module into a source specific and a target specific part and establishing the communication between these components based on Web Service technology. We describe the general architecture, the use of Web Service technology to describe and dynamically integrate participating data sources and the deployment within a specific database system.
['Lutz Schlesinger', 'Florian Irmert', 'Wolfgang Lehner']
Supporting the ETL-process by Web Service technologies