ERP system and the PDM system interface solution
Active Interface
PDM to ERP required information directly into ERP system database. This approach requires detailed understanding of the internal ERP system, database structure, and the ERP system allows PDM system, look inside to write data (ie write permission). In general, the active interface, the form generally used in custom development or self-developed ERP system. This case, ERP system, the database structure is very clear in the ERP system, data entry validation to conduct what data is also very clear that, when the PDM system to write data to the ERP system, we also follow the ERP system, data validation specifications will be the materials they need information, product information, processing information 11 is written ERP system, to ensure data accuracy and effectiveness.
Active interface, the form used in the PDM system and ERP system, a better synchronization of the information; but there are certain problems in terms of security, such as write data conflicts arise, the PDM system to write data to the ERP system at the same time, ERP systems are being look inside to write data. In general for large ERP systems such as BAAN, ORACLE, SAP and other proposed not to adopt this approach.
Passive Interface
Passive interface, ERP system from the PDM system to read the data needed to write their own database. For the passive there are two ways: (1) full passive: the PDM system is fully open its expression and storage of information in the database structure. ERP system, read the information on their own to determine what information is to increase and which are modified and which have been deleted. (2) semi-passive type: the PDM system, except to disclose their database structure, but also to provide some handshake signals deposited in a separate handshake signals in the table, shaking hands information shows what information was updated, so read the ERP system in the PDM system information (such as Parts of a process to change the version information, a product structure, product changes in the node information), in accordance with the table to read handshake signals PDM system has been changed some of the information, do not need all the time again, so that treatment can improve the interface speed.
The use of passive interfaces form, PDM systems and ERP systems has done a better synchronization, security, also stronger than the active. Generally ERP software provider to complete the interface to work more appropriate for self-developed ERP system. |
