Based On The Design Of The Data Acquisition System For ETL Technology Corporate Finance

With the growing number of enterprise in huaian city and the enlargement of enterprises in scale or amplifying enterprise financial system, This is a rapid increase in enterprise using financial softwares, enterprise taxation declare in network is a master way of tax declaration, if taxpayers financial data can be processed by techonoly and produce report files needed by tax authorities directly and reported to tax authorities in electronic form thoughout safe network,it can save a lot time in tax declaration and improve the veracity of tax data.This reseach project is based on local taxation bureau of huaian's enterprise financial report Data Acquisition software development process as the background,in order to improve software utility, safety, Advancement,reliability and expansibility,analysis and designing is key to project,In this paper, it analysis enterprise using kinds of financial software and Heterostructure Data Resources be confronted with by ETL techonoly and extracte or use Common financial data by model Accounting Standards as the system-based workIn this paper,it analysis data forms using by nearly 100 kinds of financial software, builds common data model,creat related data flow diagram,design needed data structure, describe data acquisition process of using ETL techonoly and financial report process based on InforSuite Report middleware, introduce in detail system frame building process and data engineering handle logic in programming and presente creation method of safe transferring tunnel based on PKI. Finally do the unit testing, function testing and safe transferring testing. At present the system has been put into use, get the majority of taxpayers praise and get huaian Scientific and Technological Progress Award second class.