Methodology for real-time data transmission for interoperability services between systems

Currently, there are many information systems developed in different programming languages, as well as the use of a variety of databases, which leads us to have a variety of developed information systems. If we add the working environment in which they operate, the situation becomes more complicated, such as client-server configurations, web environments, mobile environments, all of which have many services running locally and in the cloud. This complicates the need to share information between systems, especially when it is necessary to implement interoperability services, which are in high demand due to the need to concentrate information in centralised services to help provide information to users. Interoperability services are understood to be the way in which information systems communicate to share information. In this paper, we develop a methodology for implementing real-time interoperability services through broker services, which allows the transformation of the request into an information protocol based on an SQL statement that can be interpreted by the client server, which interprets the statement and allows insertion into the client system database, thus demonstrating that the proposal can be replicated and scaled according to needs.