Comparison of distributed technologies for defining a distributable and interoperable ETL framework

• Main Authors: Abdullah, Mohd Syazwan, Awad, Mohammed M I, Saleh, Abdul Razak, Mat Ali, Abdul Bashah, Ahmad, Azizah
• Format: Conference or Workshop Item
• Language: English
• Published: 2012
• Subjects: TK Electrical engineering. Electronics Nuclear engineering
• Online Access: http://repo.uum.edu.my/7300/1/667-2474-2-PB.pdf; http://repo.uum.edu.my/7300/; http://www.world-education-center.org/index.php/P-ITCS/article/view/667

Extraction, Transformation and Loading (ETL) are major functionalities in data warehousing. Lack of component distribution and interoperability are the main problems in the ETL area, because ETL components are tightly-coupled in the traditional ETL framework. This paper explores and discusses five popular distributed technologies for the purpose of highlighting the best technology that is capable of overcoming the distribution and interoperability gaps of the traditional ETL framework. Based on the comparison of distributed technologies discussed in this paper, several benefits can be obtained when SOA is used in redefining the ETL framework such as: distribution, interoperability, reusability, portability, and compatibility with legacy systems. These advantages and other SOA specifications are discussed in this paper.