US 12,277,131 B2
Metadata driven automatic data integration
Ugandhar Dasi, Alpharetta, GA (US); and Ramanjaneya Reddy Thirupathi, Atlanta, GA (US)
Assigned to T-Mobile Innovations LLC, Overland Park, KS (US)
Filed by T-Mobile Innovations LLC, Overland Park, KS (US)
Filed on Oct. 29, 2021, as Appl. No. 17/515,361.
Prior Publication US 2023/0140109 A1, May 4, 2023
Int. Cl. G06F 16/25 (2019.01)
CPC G06F 16/254 (2019.01) 15 Claims
OG exemplary drawing
 
1. A method performed by a data integration server for automatically integrating data from a source database to a target database, wherein the method comprises:
receiving, from a user equipment via a server-to-user equipment application programming interface, a request to store a source file in a target database as a target file compatible with the target database, wherein the request comprises metadata describing the source file, a source database storing the source file, and the target database;
determining, by an integrator application of the data integration server, a source file format of the source file based on the metadata;
determining, by the integrator application, a target file format of the target file based on the metadata, wherein the target file format is compatible with the target database;
determining, by the integrator application, a data loading application selected from among a sequential data loading application and a parallel data loading application based on the target file format and the target database;
automatically generating, by the integrator application, an integrated script based on a plurality of pre-defined scripts, the metadata, the source file format, and the target file format, wherein the integrated script comprises a set of instructions that, when executed, obtain the source file from the source database, transform the source file from the source file format to the target file format to obtain the target file, and load the target file to the target database using the determined data loading application;
validating, by an audit, balance, and control application of the data integration server, data in the target file; and
executing, by the determined data loading application, the integrated script to cause the data loading application to load the target file to the target database only in response to the data in the target file being validated, wherein the metadata comprises at least a parameter related to the transformation and loading of the target file that indicates that the target file is to be archived into a local datastore before being loaded to the target database, and wherein the integrated script comprises pre-defined instructions that, when executed, archive the target file to the local datastore prior to loading the target file to the target database.