PDM and ERP integration mode analysis
The principle of integration is to achieve the exchange of visits between different systems. From the above four kinds of integration patterns can be seen:
(1) The application package integration is the integration of the efficiency of the best programs, but requires developers to jointly develop the two sides, and the software upgrade will affect the realization of the interface functions, development of the heavy workload of staff;
(2) Direct database access, the structure of the database requires a better understanding of the need for enterprise software developers open software, the underlying database structure;
(3) Indirect integration model is PDM data into the middle of the document, ERP to extract data from the intermediate file, data transfer, integration, low cost, easy to implement and quick, but it must be both ERP and PDM systems support , the data interface to import and export functionality to the middle of document processing tools development;
(4) tool-based integration model, you can use the two systems use different databases available to the other appropriate database access tool that can extract data from the two systems, through the interface between data processing, to achieve a simple data processing technique can be implemented CAPP, but the exported data is only PDM product design information, there is no Process information, unable to meet the requirements of ERP systems.
ERP and PDM information integration technology
The four integration patterns described above the implementation of the workload, ease of integration is different enterprises should be based on their individual needs and capabilities, to choose their own integration patterns. Therefore, we will study the following three kinds of integration technology for enterprises to implement and use for reference.
Based on COM-ERP / PDM Integration
(1) Based on COM integrated ERP / PDM integration architecture. To achieve the integration of PDM and application systems, the key is to achieve system integration tool, in the realization of system integration tool, you can use COM as a supporting technology. For the PDM / ERP integration can be used as shown in Figure 3 architecture.
It consists of ERP with the synchronization server and the ERP with the adapters pose. Adapter and the ERP systems, there is a specific connection agreements, which are generally shared by the completion of ERP and PDM vendors. PDM system design of new products or modify old products, while the information reached the PDM database, mapped to the ERP with the synchronization server, and through the synchronization server to other ERP systems. Users can use the adapters for a variety of ERP systems, directly extract the synchronization information from the synchronization server, of course, these adapters can be easily carried out with the respective ERP data communications. Based on COM technology is a multi-platform, and language-independent, reusable "middleware" technology, which is in the COM, the component will be packaged software as COM objects, and interfaces described in the client access to the object's method, the client can access the object through the interface of services provided. Can be taken to "disperse" the architecture, that is involved in the system integration services to provide interface components and other systems require service, simply call these components can be achieved. The use of COM technology, interface and database operations to achieve a specific separation, so that real-time dynamic information processing, not only to share information, and the sharing of interfaces and functions, improve the integration interface reusability and scalability, reduce integration costs.
(2) Based on COM integrated ERP / PDM integration technique. Is divided into in-process COM component (DLL) process (EXE) and ActiveX controls in three ways. The first two are not the user interface the final control provides the user with a visual interface. Development of ERP and PDM data exchange components, must understand the structure of the table data storage, ERP of the BOM table is a table describing the relationship between father and son product, whose main field is material number, the parent parts and the corresponding quantity. Generating COM component, the COM component and its components as a component in COM class objects are given access to these objects methods and properties, the final in accordance with the form of DLL or EXE, will compile the generated COM server components. On the client, as long as the call to the interface component is given, we can realize the operation of the BOM table. Figure to complete the PDM integrated user interface MBOM structure data extraction, update and storage operations. |
