US 12,292,877 B2
File enrichment for automatic database update
Lenin Kumar Pagidipala, Atlanta, GA (US); Jonathan Topp, Montpelier, VA (US); and Omganesh Teekaramsingh, Johns Creek, GA (US)
Assigned to Truist Bank, Charlotte, NC (US)
Filed by Truist Bank, Charlotte, NC (US)
Filed on Jun. 9, 2023, as Appl. No. 18/207,740.
Prior Publication US 2024/0411745 A1, Dec. 12, 2024
Int. Cl. G06F 16/23 (2019.01); G06F 16/11 (2019.01); G06F 16/14 (2019.01)
CPC G06F 16/2365 (2019.01) [G06F 16/116 (2019.01); G06F 16/148 (2019.01)] 14 Claims
OG exemplary drawing
 
1. A system comprising:
a processor; and
a non-transitory computer-readable medium comprising instructions that are executable by the processor to cause the processor to perform operations comprising:
receiving a set of input files from an initial database that comprises data in a first format;
determining that the set of input files is nonconforming to a standard associated with a second format that is different than the first format, wherein a target database is configured to store files in the second format;
in response to determining that the set of input files is nonconforming, enriching the set of input files to generate a set of enriched files that has the second format by:
generating a set of entity functions, a set of user functions, and a set of direct updates based on the set of input files, wherein each user function of the set of user functions comprises user parameters including a user name or number of a corresponding user, a user rule set or access level of the corresponding user, a location associated with the corresponding user, and an indication of whether the corresponding user is a single-sign-on (SSO) user or a non-SSO user; and
generating one or more simple object access protocol (SOAP) requests and one or more structured query language (SQL) queries based on the set of entity functions, the set of user functions, and the set of direct updates, wherein a first SOAP request includes the set of entity functions and a second SOAP request includes the set of user functions, and wherein the one or more SQL queries are based at least in part on the set of direct updates;
generating a validated set of enriched files by:
determining that a subset of the set of enriched files has an error; and
removing the subset from the set of enriched files to generate the validated set of enriched files; and
initiating an automatic update of a target database by transmitting the validated set of enriched files to the target database that is compatible with the second format.