基于ETL技术的企业信息集成研究

Research on ETL- based Manufacture Enterprise Information Integration

本文研究了数据仓库ETL技术,并将ETL技术运用在企业信息集成过程中。本文以PDM和ERP系统为研究对象,阐述了ETL用于数据集成的方法、过程和集成架构。开发了可视化集成开发ETL工具,利用该工具从PDM系统中获取产品结构数据,实现PDM和ERP系统的数据集成。运用ETL技术能够简化企业信息集成开发,具有低耦合性、易于扩展的特点。

Data warehouse and ETL is discussed in this article. ETL is applied on enterprise information system integration, such as PDM and ERP system. The methodology, process and integration architecture of ETL are presented. A visual ETL tool is developed, aiming at integration data between PDM and ERP system. An integration example is given and demonstrates that the integration architecture, which is low-coupled, can he used to simplify development and increase the cxtensihility.