Back to results
US 11,308,120 B2Granted
Automated performing of replication tasks in a multiple database system
AssigneeSap SE
InventorHeshang Majmudar
Life of this patent
Estimating the term…
Abstract
Disclosed herein are system, method, and computer program product embodiments for the performing of a replication task in a multi-database system, by a replication agent, for replicating a location range of columns in a table in a source repository data object, to a location range of columns in a target table in a target repository data object. An embodiment operates by using a data provisioning agent, remote source connection, and replication task controller in sequence to set up a replication task for execution.
Claims20
A computer implemented method for generating and performing a replication task, comprising:
- receiving, by at least one processor, a signal to start the generation of a replication task and a list of parameters;
- configuring, by the at least one processor, a data provisioning agent to allot replication tasks to be processed to a plurality of computing resources based on a subset of the list of parameters;
- configuring, by the at least one processor, a remote source connection using an adapter included with the data provisioning agent, for obtaining a source data table from an external database in a source repository via the remote source connection;
- configuring, by the at least one processor and responsive to the signal, the replication task to at least partially replicate a source data table from an external database in a source repository, to a target data table of a data object in a target repository, based on the list of parameters and a generated template comprising a source structure corresponding to the source repository and a target structure corresponding to the target repository, and mapping information, wherein source columns in the source repository are replicated into in target columns of the target repository based on the mapping information;
- determining, by the at least one processor, a first column of the source columns and a second column of the target columns share a same modifier formula, wherein the generated template lacks a mapping for the first column and the second column, and wherein data is populated in the second column based on a modifier formula and references to one or more different target columns in the target repository;
- based on said configuring, designating, by the at least one processor, the replication task as generated, and pushing the generated replication task for execution;
- and
- executing, by the at least one processor, the generated replication task.
5 more elements
A system for generating and performing a replication task, comprising:
- a memory;
- and
- at least one processor coupled to the memory and configured to:
- receive, a signal to start the generation of a replication task and a list of parameters;
- configure a data provisioning agent to allot replication tasks to be processed to a plurality of computing resources based on a subset of the list of parameters;
- configure a remote source connection using an adapter included with the data provisioning agent, for obtaining a source data table from an external database in a source repository via the remote source connection;
- configure the replication task to at least partially replicate a source data table of an external database in a source repository, to a target data table of a data object in a target repository, based on the list of parameters, and a generated template comprising a source structure corresponding to the source repository and a target structure corresponding to the target repository, and mapping information, wherein source columns in the source repository are replicated into in target columns of the target repository based on the mapping information;
- determine a first column of the source columns and a second column of the target columns share a same modifier formula, wherein the generated template lacks a mapping for the first column and the second column, and wherein data is populated in the second column based on a modifier formula and references to one or more different target columns in the target repository;
- based on said configuring, designate the replication task as generated, and push the generated replication task for execution;
- and
- execute the generated replication task.
8 more elements
A non-transitory computer-readable device for generating and performing a replication task, having instructions stored thereon that, when executed by at least one computing device, causes the at least one computing device to perform operations comprising:
- receiving, a signal to start the generation of a replication task and a list of parameters;
- configuring a data provisioning agent to allot replication tasks to be processed to a plurality of computing resources based on the list of parameters;
- configuring a remote source connection using an adapter included with the data provisioning agent, for obtaining a source data table from an external database in a source repository via the remote source connection;
- configuring the replication task to at least partially replicate a source data table of a data object from an external database in a source repository, to a target data table of a target repository, based on the list of parameters and a generated template comprising a source structure corresponding to the source repository and a target structure corresponding to the target repository, and mapping information, wherein source columns in the source repository are replicated into in target columns of the target repository based on the mapping information;
- determining a first column of the source columns and a second column of the target columns share a same modifier formula, wherein the generated template lacks a mapping for the first column and the second column, and wherein data is populated in the second column based on a modifier formula and references to one or more different target columns in the target repository;
- based on said configuring, designating the replication task as generated, and pushing the generated replication task for execution;
- and
- executing the replication task.
5 more elements
Dependencies are inferred from the claim text.