Data Load Process

Abstract

A source data file can be loaded into a database by extracting data from the source data file at a computing device, validating the data from the source data file at the computing device, transforming the data from the source data file at the computing device, requesting the data to be transferred to a first database at a first message processor module, delivering the data to the first database, and responding that the data has been transferred to the first database at the first message processor module to acknowledge receipt of the data in the database at the computing device.

We claim: 
     
         1 . An apparatus comprising:
 a processor; and   memory storing computer readable instructions that, when executed by the processor, cause the apparatus to:
 receive, from a source system, a request to deliver data from a source data file; 
 apply validation rules to data from the source data file; 
 transform the data from the source data file to generate transformed data; 
 deliver the transformed data to a first database and a second database; 
 generate a response that the transformed data has been delivered to the first database and the second database; and 
 based on the response that the transformed data has been delivered to the first database and the second database, generate an acknowledgement indicating that the first database and the second database received the transformed data. 
   
     
     
         2 . The apparatus of  claim 1 , wherein the apparatus comprises a server. 
     
     
         3 . The apparatus of  claim 1 , wherein delivering the transformed data comprises:
 causing a first message processor to deliver the transformed data to the first database; and   causing a second message process to deliver the transformed data to the second database.   
     
     
         4 . The apparatus of  claim 1 , wherein the memory stores computer readable instructions that, when executed by the processor, cause the apparatus to update control records based on the acknowledgement. 
     
     
         5 . The apparatus of  claim 1 , wherein the memory stores computer readable instructions that, when executed by the processor, cause the apparatus to route the acknowledgement to the source system. 
     
     
         6 . The apparatus of  claim 1 , wherein the memory stores computer readable instructions that, when executed by the processor, cause the apparatus to send the acknowledgement to a check system monitoring facility. 
     
     
         7 . The apparatus of  claim 1 , wherein the memory stores computer readable instructions that, when executed by the processor, cause the apparatus to send the acknowledgement to a business activity monitoring module. 
     
     
         8 . One or more non-transitory computer-readable media having instructions stored thereon that, when executed, cause at least one computing device to:
 receive, from a source system, a request to deliver a source data file to a first database and a second database;   extract data from the source data file;   validate the data from the data source file;   transform the data from the data source file to generate transformed data;   send a request for the transformed data to be transferred to the first database and the second database;   in response to the request for the transformed data to be transferred, deliver the transformed data to the first database and the second database in a delivery process; and   generate a response that the transformed data has been transferred to the first database and the second database; and   based on the response that the transformed data has been transferred to the first database and the second database, generate an acknowledgement indicating that the first database and the second database received the transformed data.   
     
     
         9 . The one or more non-transitory computer-readable media of  claim 8 , wherein the at least one computing device comprises a server. 
     
     
         10 . The one or more non-transitory computer-readable media of  claim 8 , wherein delivering the transformed data comprises:
 causing a first message processor to deliver the transformed data to the first database; and   causing a second message process to deliver the transformed data to the second database.   
     
     
         11 . The one or more non-transitory computer-readable media of  claim 8 , having instructions stored thereon that, when executed, cause the at least one computing device to update control records based on the acknowledgement. 
     
     
         12 . The one or more non-transitory computer-readable media of  claim 8 , having instructions stored thereon that, when executed, cause the at least one computing device to route the acknowledgement to the source system. 
     
     
         13 . The one or more non-transitory computer-readable media of  claim 8 , wherein the delivery process is monitored by a check system monitoring facility. 
     
     
         14 . The one or more non-transitory computer-readable media of  claim 8 , wherein the delivery process is monitored by a business activity monitoring module. 
     
     
         15 . A method comprising:
 receiving, from a source system, a request to deliver data from a source data file;   applying validation rules to data from the source data file;   transforming the data from the source data file to generate transformed data;   delivering the transformed data to a first database and a second database;   generating a response that the transformed data has been delivered to the first database and the second database; and   based on the response that the transformed data has been delivered to the first database and the second database, generating an acknowledgement indicating that the first database and the second database received the transformed data.   
     
     
         16 . The method of  claim 15 , wherein delivering the transformed data comprises:
 causing a first message processor to deliver the transformed data to the first database; and   causing a second message process to deliver the transformed data to the second database.   
     
     
         17 . The method of  claim 15 , further comprising:
 updating control records based on the acknowledgement.   
     
     
         18 . The method of  claim 15 , further comprising:
 routing the acknowledgement to the source system.   
     
     
         19 . The method of  claim 15 , further comprising:
 sending the acknowledgement to a check system monitoring facility.   
     
     
         20 . The method of  claim 15 , further comprising:
 sending the acknowledgement to a business activity monitoring module.