A framework for interoperable distributed ETL components based on SOA

Extraction, Transformation and Loading (ETL) are major functionalities in data warehousing solutions. Lack of component distribution and interoperability are considered as main problems in the ETL because these ETL components are tightly-coupled in the current ETL framework. This paper discusses how to distribute the Extraction, Transformation and Loading components so as to achieve loose-coupling. Furthermore, it also shows how interoperability can be applied to these distributed ETL components. Service Oriented Architecture (SOA) is capable of addressing the mentioned missing features of distribution and interoperability by restructuring the current ETL framework. SOA standards are used in restructuring the ETL processes. The result of this work is the tested interoperable distributed components of the ETL framework.