Application Of ETL Key Technology In Power System Integrated Data Platform

In Current period, application of secondary power system became very Development and mature, number of various professional subsystem increase as soon as quickly. these systems plays an indispensable role in power grid security operation and management. with the basic framework of secondary power system security solutions and more applications of Security division, Power System Integrated Data Platform aggregated useful information of every secondary power system.data exchange, Completed data exchange in application of these system. Power System Integrated Data Platform became the existing data to usefull information of power production and management with the data Consolidation technology and data mining technology and so on.In current practical application, data exchanging usually take point-to-point gateway transmission mode. Extraction-Transformation-Loading usually used ORACAL storage process, this method has many faults like big workload, low expansibility, low reusability, can not be managed, it is not be satisfied in data management requirements of simultaneously based on multiple business system . This paper discusses Application of ETL key technology in Power System Integrated Data Platform. After Application of ETL key technology in Power System Integrated Data Platform, we meet the needs of the flexible data sharing, meet the needs of different kinds of data integration in secondary power system.we also increased file data, E language file data. The settings of daata Extraction-Transformation-Loading is flexible, the data flow management is more convenient.Power System Integrated Data Platform became the enterprise data warehouse with some important technology like efficient data extraction/simple maintenance and easy management.The technology has been used in Inner Mongolia Power System Integrated Data Platform, so we achieved efficient data exchange in different power subsystems.We have achieved good results.