Data replication between databases with heterogenious data platforms

A computer implemented method of data replication, the method comprising:

• selecting a first extraction utility from a plurality of extraction utilities based on a data format used on a source database, wherein selecting the first extraction utility is based at least in part on a second extraction utility being unavailable, and wherein the second extraction utility is unavailable because there are no available slots on the source database for the second extraction utility;
• extracting an incremental from the source database and loading the incremental onto a server using the first extraction utility;
• selecting a first loading utility from a plurality of loading utilities based on a data format used on a target database;
• loading the incremental from the server to the target database using the first loading utility;
• and
• causing the target database to update a data table on the target database with the incremental, the updating comprising repeatedly attempting to update the data table with the incremental using an unattempted application utility from a plurality of application utilities until the data table is updated or there are no more unattempted application utilities, wherein the unattempted application utility is chosen based on a cost of using the unattempted application utility.

A system for data replication comprising:

• a source database storing a first data table having first information received prior to a time point and second information received after the time point, the source database configured to create an incremental based on the second information;
• a target database storing a second data table having the first information, the target database configured to update the second data table with the incremental when the incremental is loaded in the target database such that the second data table contains both the first and second information, the updating including repeatedly attempting to update the second data table with the incremental using an unattempted application utility from a plurality of application utilities until the second data table is updated or there are no more unattempted application utilities;
• and
• a server including one or more hardware processors configured to execute instructions to cause the server to perform operations comprising:
• extracting the incremental from the source database and loading the incremental onto a non-transitory memory;
• selecting the target database from a plurality of databases based on a cost of using the target database;
• and
• loading the incremental from the non-transitory memory onto the target database.