Design and Implementation of a Data Warehouse ETL Tray Program

This paper presents an ETL system for a data warehouse designed for a PVC profile manufacturing enterprise. The system implements the data extraction, data transformation and load from the data sources of ERP system, CRM system and production line operation data collection system. The ETL requirements are discussed. The system design and implementation methods, including system structure, functions, data processing methods as well as tray program implementation are addressed.