US 12,475,103 B1
Managing a file transfer process for automatic database update
Randy Borth, Charlotte, NC (US); WeiJen Lu, Raleigh, NC (US); Sandeep Bodireddy, Charlotte, NC (US); Ramesh Namireddy, Charlotte, NC (US); Dhruval Patel, Atlanta, GA (US); Padmaja Challa, Charlotte, NC (US); and Rajashekara Yellari, Charlotte, NC (US)
Assigned to Truist Bank, Charlotte, NC (US)
Filed by Truist Bank, Charlotte, NC (US)
Filed on May 17, 2024, as Appl. No. 18/666,941.
Int. Cl. G06F 16/23 (2019.01); G06F 16/182 (2019.01); G06F 21/60 (2013.01)
CPC G06F 16/2365 (2019.01) [G06F 16/183 (2019.01); G06F 21/602 (2013.01)] 20 Claims
OG exemplary drawing
 
1. A system comprising:
a processor device; and
a non-transitory computer-readable medium having instructions stored thereon that are executable by the processor device to cause the processor device to perform operations comprising:
tracking, by a monitoring tool, a transfer of a file comprising interaction data corresponding to one or more interactions, the file being transferred from a mainframe database to a cloud database via one or more intermediary systems to enrich the file at the cloud database, the monitoring tool configured to log one or more tracked parameters of the file prior to the file leaving the mainframe database and each intermediary system, wherein the monitoring tool is communicatively coupled with the mainframe database, the one or more intermediary systems, and the cloud database;
detecting, by the monitoring tool, that the file has stopped at a particular intermediary system of the one or more intermediary systems prior to being transferred to the cloud database;
in response to detecting that the file has stopped at the particular intermediary system, comparing, by the monitoring tool, a checksum of the file to an expected value to determine whether the file has a discrepancy, the checksum configured to verify data integrity of the file subsequent to transferring the file to the particular intermediary system;
determining, by the monitoring tool, an action to perform at the particular intermediary system to continue transferring the file to the cloud database; and
controlling, by the monitoring tool, the particular intermediary system by transmitting a command to cause the particular intermediary system to perform the action, the monitoring tool configured to automatically output the command in response to determining that the comparison of the checksum and the expected value indicates that the discrepancy has been introduced in the file subsequent to transferring the file to the particular intermediary system.