Research And Design Of ETL In Data Integration Platform

Most design of enterprise system which is used for different specialty does not take into account the sharing and exchange of data among various systems. Hardware,software and protocol of these systems are not the same as each other and they have notable distribution and different construction which become some information islands . The enterprise imminently need set up data warehouse through date integration platform to share information and support decision.Based on the research of data integration platform, this paper analyzs ETL system and ETL solution of the platform foundation frame, including the ETL tool structure, the characteristic, data extract, data transform and the data loading. Then I set up a general, flexile ETL model by JAVA program, the JDBC interface and XML which can run multi-threading,support increment update and ignore the difference of software and hardware.