Research And Design On Integration Of SSIS And Application System Based On SSH2

With the quick development and application of information technology, enterprise application systems have accumulated a large amount of historical data. In order to fully mine and utilize these massive data and to help enterprises get the information which are beneficial to operation management, application systems need to be integrated. Integration is not only a technical work, meanwhile it will influence on various business areas of enterprises. At present, the existing solutions cannot adapt to the change of business needs, what's more, the information provided by many solutions are out of date, and it is difficult to obtain accurate data analysis results. Therefore,effective integration of existing and future enterprise application systems has become an urgent problem.Based on a comprehensive study of business intelligence and the characteristics of enterprise application systems,combining the data analysis needs of enterprises,this paper puts forward an integration program of SSIS(SQL Server Integration Services) and application systems based on SSH2(Struts2,Spring and Hibernate) framework. The paper presents the overall structure of the program and elaborates the design and the realization process of the program in detail. The first step is to achieve the ETL (Extraction,Transformation and Loading) of a variety of data sources through SSIS. The next step is to build the data warehouse by using SSIS and establish multidimensional cube data model according to the corresponding topic to meet the needs of multi-dimensional analysis. Based on the needs of decision analysis, the program presents the data query and analysis results through reports. The last step is to integrate data analysis results and application system through the intelligent interfaces. In the program, according to the development process and characteristics of the SSH2 framework, this paper puts forward an integration method of application systems and reports which are used for data analysis innovatively. Through configuring authentication mode, increasing the intelligent interface and designing the layout of new pages of the systems, it achieves that the users of the application system can access the reports through one-stop work style.This study is based on the historical data in the enterprise's database, and it is capable of extracting and filtering data from multiple data sources in real time. Thus, relevant analysis person can analyze the operation of the enterprises in an interactive and multi-level way. The program could find a better way to get the information which are hidden in the large amount of data; in addition,it helps business managers make decisions. At last,the article takes integration implementation of the existing membership management as an example to validate the feasibility of the integration program. The results display that the program has reached validity and rationality of decision effect and has strong reusability and practical value.