| With the rapid development of information technology, Internet has become an important part in our life,study and work. Along with business growth, accumulated data of the sectors will subsequently become more and more. But the systems are indendent of eachother and the designs of their data table are not the same, which leads to formation of an information island by oneself. They does not take into account the sharing and exchange of data ,therefore most of the heterogeneous legacy systems are incompetent to meet these requirements that more and more companies and enterprises require data integration and data exchange now. Therefore,the enterprise imminently need set up data warehouse through date integration platform to share information and support decision.ETL tool for data integration is a solution to the establishment of data warehouse.Based on B/S architecture, this article analyzs ETL system and ETL solution of the platform foundation frame,including the ETL tool structure,the technology ,data extract,data transform and the data loading.Then I set up an online,friendly Comsys ETL system model by JAVA program,JavaScript,ExtJS,the JDBC interface ,XML and RBAC theory which can support seamless integration with other web services,support increment update and ignore the difference of software and hardware. |
PDF Full Text Request