Development of a data exchange service between software systems

This article presents the development of a service information model for data exchange between ERP and MES systems used for planning and control of production processes. The purpose of the service is the efficient transfer and structuring of information between databases in the production process, as well as control of operations through the user interface. This approach allows for the integration of various external software systems, which is an urgent task in the field of automation and control of production processes. The service was implemented in Python using SQLAlchemy to work with PostgreSQL databases. The graphical interface of the service allows you to edit the required JSON template, used for working with databases. Testing was carried out on two databases for a system for monitoring the movement of parts during the production process, confirming the functionality and reliability of the service.