Data integration and make it become the strategic decision news will be at technology trends after the post-ERP era of information. KDD Data Mining technology is the primary method in data analysis, the different characteristics will be analyzed between the ERP system and business intelligence BI system in this paper. the financial-cost analysis system KPI and material consumption analysis KPI will be developed by to using BI tools for implement base on the project of data integration of JinMaiLang drink company.
For this project researched, more mainly to solve the relevant problems Of operation and management analysis KPI on the sales，financial，production and other departments. there is that data caliber not uniform, Workload arduous by hand-pooled for analysis, providing for report lag every end month,the decision information is not sensitive and low efficiency.this paper attempts through the development process to Illustrates principles and methods and technical characteristics base data integration on ERP system and provide an idea of data analysis development for data mining. But also to explore that business intelligence BI would be used in the enterprise.
This paper mainly to studies and use the following methods:
ing EPM tools, combing analysis KPI, to determine data source and data range through analyse the principle of the ERP system business
2/ Use the UF NC5.6 system UAP development platform, development data interface to achieve the source data makeup. used EAI data integration tools to achieve DRP system and NC system based unification on data. 3/Build data warehouse,to finish data conversion through tools DI, complete data ETL process, to establish data warehouse DW and data memory area ODS.
4/Combined carded business indicators, analyze data relationships of relational database of ERP system,to identify dimension table and fact table and calculation index.
5/Using PowerDesigner data modeling to determine the logical relationships, and use of documents to illustrate for review.
6/According to the needs of business indicators , to build display models through the OLAP tools for consumer.
7/Using intelligent report development tool (web Intelligance) to complete report forms that user requirements.
8/ Presentation layer optimization and single sign-on integration (SS0) Through above of the technology and method, the KPI of system for sales and finance and production would be showed automatic, real-time.So that the whole company reports statistical reporting period increased from No.8 per month to No.2 per month , data accuracy, traceability has been greatly improved.Through systems integration to solve the inter-islands of information between systems, so that basic data standard, uniform;Through data warehouse of analyzing were be established that business data and analysis data have been separated, so different object-oriented applications without disturbing each other, but also lay the foundation for the OLAP analysis capabilities for the future and to reduce data collection costs.
In this thesis,to completed the data integration by implementation of the design and development , the overall description is based ERP system for business intelligence (BI) data integration,it's should include the analysis of business KPI were be combed, IT-based data integration framework, the source data discovery, data interface development, based on the business process for data relationships analysis, data warehouse modeling DW, ETL, OLAP analysis, data testing, data show and other key processes. it's a successful business intelligence analysis, is not simply a number tools of technical and methods were used, but also there's a set of business methods and the best practice.
关键词：Data Mining KDD；Business Intelligence BI；Enterprise Resource Planning ERP；Enterprise Application Integration EAI；,Enterprise Performance Management EPM；On Line Analytical Processing OLAP；Data Warehouse DW；Data Test。