Database Data Replication Tool

Abstract

Data replication between databases is provided. The method comprises receiving, through an API integrated into a data replication tool, a request from a system of record (SoR) application for a replication setup and initialization. A number of data instances are imported through the API from a source database associated with the SoR. A manager engine integrated into the data replication tool initiates a separate replication process for each data instance. The manager engine is configured to support multiple data instances on a single virtual machine instance. If a difference between a data description language (DDL) of the replicated data instances and a DDL of a target database is detected, the DDL of the replicated data instances is automatically changed to the DDL of the target database. The replicated data instances are then exported to the target database.

What is claimed is: 
     
         1 . A computer-implemented method of data replication between databases, the method comprising:
 using a number of processors and random access memory allocation to perform the steps of:   receiving, through an application programming interface (API) integrated into a data replication tool, a request from a system of record (SoR) application for a replication setup and initialization;   importing, through the API, a number of data instances from a source database associated with the SoR;   initiating, by a manager engine integrated into the data replication tool, a separate replication process for each data instance imported through the API, wherein the manager engine is configured to support multiple data instances on a single virtual machine instance;   if a difference between a data description language (DDL) of the replicated data instances and a DDL of a target database is detected, automatically changing the DDL of the replicated data instances to the DDL of the target database; and   exporting the replicated data instances to the target database.   
     
     
         2 . The method of  claim 1 , wherein the replicated data instances comprise JavaScript Object Notation files. 
     
     
         3 . The method of  claim 1 , further comprising persisting, through the API, database configuration information on a non-relational database. 
     
     
         4 . The method of  claim 1 , further comprising forwarding a data replication log in real-time from the manager engine to a data analytics service. 
     
     
         5 . The method of  claim 1 , further comprising forwarding a data replication log in real-time from a user interface integrated into the data replication tool to a data analytics service. 
     
     
         6 . The method of  claim 1 , wherein the API runs on a container. 
     
     
         7 . The method of  claim 1 , further comprising receiving a replication start or stop request from the SoR through the API. 
     
     
         8 . The method of  claim 1 , further comprising receiving a request for real-time status from the SoR through the API. 
     
     
         9 . The method of  claim 1 , further comprising detecting, by the manager engine, if a table in the replicated data instances requires a load. 
     
     
         10 . The method of  claim 1 , further comprising automatically translating, by the manager engine, a table in the replicated data instance to a new structure. 
     
     
         11 . The method of  claim 1 , wherein a system administrator communicates with the API through a user interface integrated into the data replication system. 
     
     
         12 . The method of  claim 1 , wherein the manager engine is one of a number of manager engines in a load balancing cluster. 
     
     
         13 . The method of  claim 1 , wherein the data replication tool is integrated with a live stream chat system. 
     
     
         14 . The method of  claim 1 , wherein an orchestrator integrated into the data replication system executes a specified list of actions by the manager engine under specified conditions. 
     
     
         15 . A system for data replication between databases, the system comprising:
 a storage device configured to store program instructions; and   one or more processors operably connected to the storage device and configured to execute the program instructions to cause the system to:   receive, through an application programming interface (API) integrated into a data replication tool, a request from a system of record (SoR) application for a replication setup and initialization;   import, through the API, a number of data instances from a source database associated with the SoR;   initiate, by a manager engine integrated into the data replication tool, a separate replication process for each data instance imported through the API, wherein the manager engine is configured to support multiple data instances on a single virtual machine instance;   if a difference between a data description language (DDL) of the replicated data instances and a DDL of a target database is detected, automatically change the DDL of the replicated data instances to the DDL of the target database; and   export the replicated data instances to the target database.   
     
     
         16 . The system of  claim 15 , wherein the replicated data instances comprise JavaScript Object Notation files. 
     
     
         17 . The system of  claim 15 , wherein the processors further execute instructions to persist, through the API, database configuration information on a non-relational database. 
     
     
         18 . The system of  claim 15 , wherein the processors further execute instructions to forward a data replication log in real-time from the manager engine to a data analytics service. 
     
     
         19 . The system of  claim 15 , wherein the processors further execute instructions to forward a data replication log in real-time from a user interface integrated into the data replication tool to a data analytics service. 
     
     
         20 . The system of  claim 15 , wherein the API runs on a container. 
     
     
         21 . The system of  claim 15 , wherein the processors further execute instructions to receive a replication start or stop request from the SoR through the API. 
     
     
         22 . The system of  claim 15 , wherein the processors further execute instructions to receive a request for real-time status from the SoR through the API. 
     
     
         23 . The system of  claim 15 , wherein the processors further execute instructions to detect, by the manager engine, if a table in the replicated data instances requires a load. 
     
     
         24 . The system of  claim 15 , wherein the processors further execute instructions to automatically translate, by the manager engine, a table in the replicated data instance to a new structure. 
     
     
         25 . The system of  claim 15 , wherein a system administrator communicates with the API through a user interface integrated into the data replication system. 
     
     
         26 . The system of  claim 15 , wherein the manager engine is one of a number of manager engines in a load balancing cluster. 
     
     
         27 . The system of  claim 15 , wherein the data replication tool is integrated with a live stream chat system. 
     
     
         28 . The system of  claim 15 , wherein an orchestrator integrated into the data replication system executes a specified list of actions by the manager engine under specified conditions. 
     
     
         29 . A computer program product for data replication between databases, the computer program product comprising:
 a computer-readable storage medium having program instructions embodied thereon to perform the steps of:
 receiving, through an application programming interface (API) integrated into a data replication tool, a request from a system of record (SoR) application for a replication setup and initialization; 
 importing, through the API, a number of data instances from a source database associated with the SoR; 
 initiating, by a manager engine integrated into the data replication tool, a separate replication process for each data instance imported through the API, wherein the manager engine is configured to support multiple data instances on a single virtual machine instance; 
 if a difference between a data description language (DDL) of the replicated data instances and a DDL of a target database is detected, automatically changing the DDL of the replicated data instances to the DDL of the target database; and 
 exporting the replicated data instances to the target database. 
   
     
     
         30 . The computer program product of  claim 29 , wherein the replicated data instances comprise JavaScript Object Notation files. 
     
     
         31 . The computer program product of  claim 29 , further comprising instructions for persisting, through the API, database configuration information on a non-relational database. 
     
     
         32 . The computer program product of  claim 29 , further comprising instructions for forwarding a data replication log in real-time from the manager engine to a data analytics service. 
     
     
         33 . The computer program product of  claim 29 , further comprising instructions for forwarding a data replication log in real-time from a user interface integrated into the data replication tool to a data analytics service. 
     
     
         34 . The computer program product of  claim 29 , wherein the API runs on a container. 
     
     
         35 . The computer program product of  claim 29 , further comprising instructions for receiving a replication start or stop request from the SoR through the API. 
     
     
         36 . The computer program product of  claim 29 , further comprising instructions for receiving a request for real-time status from the SoR through the API. 
     
     
         37 . The computer program product of  claim 29 , further comprising instructions for detecting, by the manager engine, if a table in the replicated data instances requires a load. 
     
     
         38 . The computer program product of  claim 29 , further comprising instructions for automatically translating, by the manager engine, a table in the replicated data instance to a new structure. 
     
     
         39 . The computer program product of  claim 29 , wherein a system administrator communicates with the API through a user interface integrated into the data replication system. 
     
     
         40 . The computer program product of  claim 29 , wherein the manager engine is one of a number of manager engines in a load balancing cluster. 
     
     
         41 . The computer program product of  claim 29 , wherein the data replication tool is integrated with a live stream chat system. 
     
     
         42 . The computer program product of  claim 29 , wherein an orchestrator integrated into the data replication system executes a specified list of actions by the manager engine under specified conditions.