How to deal with unique and consecutive IDs during integration

June 18, 2021


Table of contents

Quick Access

![enter image description here](https://cms.rootstack.comhttps://cms.rootstack.com/sites/default/files/blog/img/middleware.jpg) As mentioned previously a **Middleware** is part of a set of techniques capable of interconnecting different systems regardless of the technology in which it was developed or the final function of each tool. The middleware has multiple advantages that can be applied to your type of business in a personalized way, among the advantages we can highlight: - **Easy to implement** - **Improves query response times** - **Save investment resources** - **Secure interconnectivity** **But, How do we deal with unique and consecutive ids during the integration of two or more platforms?** A middleware acts as a communication bridge between systems an /or platforms, it must always have an entity within its structure that identifies (translates) each unique key within the involved (systems and/or platforms). In this way, each time an action that requires a "key" is executed, the middleware will be able to identify or map it on each of the other platforms, providing the required response in the shortest time possible and without complications. For example, system1 key name rupe rupertino system 2 key name cleo reutilia middleware key system s_key f_key 1 1 rupe cleo 2 2 cleo rupe As you can see, what exists in system 1 and 2 has a key identified in the middleware but with different names. At the moment that system 1 asks the middleware for the name of the key rupe in system 2 and when passing through the middleware will see that the s_key = rupe in system 1 and will take the key f_key = cleo asking the system2 for the key = cleo and system 2 will respond with the name = reuses what it will return to the middleware and the middleware will send it to system1 so that the communication is done **quickly, effectively and securely.** We can conclude that to achieve a **successful implementation** of your applications with the middleware you will be able to determine unique keys for each system, providing an optimal translation when inquiring with your users.