Bidirectional Database Synchronization to the Cloud Computing Platform
Danijel Filipović, Danijel Sokač, Ruben Picek · 2020
Diversity of subsystems in the organization can lead towards bad business results. Many companies decide to patch their business system with multiple subsystems which are usually not interoperable. Along with that, organizations have the dilemma of deciding whether to implement best-of-breed or one vendor solution. There is no correct answer to the dilemma. The outcome of the dilemma depends on each organization individually based on their analysis and needs. This article analyzes how to overcome data inconsistency caused by patching the business system and presents an approach to the synchronization of different databases to the Cloud. Usage of database synchronization tools to unify data in the Cloud is practical for mature organizations which aim to establish data consistency. The goal of this article is to consider some tools for database synchronization and to choose one for the practical example considering the known constraints. In the approach, we used few different databases to verify its compliance with chosen synchronization tool. The approach is based on practical example where couple of databases are synchronized to the Cloud ensuring the data consistency and bidirectional data flow. The solution includes chosen tool and the recommendation on how to ensure flawless data integration in the Cloud. Tests of synchronization duration with chosen databases and row quantities are conducted and analyzed at the end of the article.