ERP system integration methods

Abstract

This article investigates whether there is a standardized ERP integration model for synchronizing master data and transforming raw account data into a standardized, reusable structure and transferring it to a third-party ERP system. The ERP integrator component presented in this paper is an innovative approach because it is not purely based on database replication, it does not purely integrate business logic, but it also utilizes the event handling procedures for SQL databases. An important feature of the method is that it naturally supports the creation of unit tests. Thus, the operational specification can also be expressed by defining a series of test steps. The method can be sufficiently generalized, so that using the method recommended in this paper every SQL based ERP system can be integrated. Using the proposed integrator, architectural design does not need to know the internal structure of the third-party ERP database when developing the integration process. Furthermore, the third-party ERP developers do not need to know how the component works internally, only some of the predefined database views and some event management mechanisms required by the integrator to be applied.