# US 2019/0171648 A1 · System and method for implementing an extract transform and load (etl) migration tool

> Agents: this data is available as JSON from the patentgrep API and MCP server — see https://patentgrep.com/llms.txt

- Number: US 2019/0171648 A1
- Document ID: US20190171648A1
- Status: Published application
- Kind: A1
- Application number: 16/207,406
- Filed: 2018-12-03
- Published: 2019-06-06
- Earliest claimed: 2017-12-01
- Applicants: JPMorgan Chase Bank, N.A.
- Inventors: Jagmohan SINGH; Ravikanth H. CUTTAMBAKAM
- Web page: https://patentgrep.com/patent/US20190171648A1

## CPC

- G06F 16/254: {Extract, transform and load [ETL] procedures, e.g. ETL data flows in data warehouses}
- G06F 8/51: Source to source
- G06F 16/258: {Data format conversion from or to a database}
- G06F 40/154: Tree transformation for tree-structured or markup documents, e.g. XSLT, XSL-FO or stylesheets
- G06F: ELECTRIC DIGITAL DATA PROCESSING (computer systems based on specific computational models G06N)

## Abstract

An embodiment of the present invention is directed to creating an automated system that reads a source data structure (in DML) and creates a target data structure (in XML). An embodiment of the present invention provides automated conversion of data structure metadata from a source data structure to a target data structure. The features of the various embodiments of the present invention may apply to any automated conversion system.

## Claims

### Claim 1

A system that implements extract, transform and load migration from a source data structure in a first language to a target data structure in a second language, the system comprising:
a memory component that stores data relating to the source data structure and the target data structure; and
a computer server coupled to the memory, the computer server comprising a programmed computer processor configured to perform the steps of:
storing source data structure files in a first programming language in a designated folder;
executing a conversion job from a source data structure to target data structure on a file by file basis;
automatically converting files from the source data structure to the target data structure in a second programming language;
storing the converted files in the same designated folder; and
importing a target data structure schema.

### Claim 2 (depends on 1)

The system of claim 1, wherein the first programming language comprises DML.

### Claim 3 (depends on 1)

The system of claim 1, wherein the second programming language comprises XML.

### Claim 4 (depends on 1)

The system of claim 1, wherein the first programming language comprises DML and the second programming language comprises XML.

### Claim 5 (depends on 1)

The system of claim 1, wherein the conversion job further comprises iterating a list of files one by one in a loop operation.

### Claim 6 (depends on 1)

The system of claim 1, wherein the conversion job comprises a DML to XML job.

### Claim 7 (depends on 1)

The system of claim 1, wherein the source data structure comprises a number of attributes and attribute characters.

### Claim 8 (depends on 1)

The system of claim 1, wherein the source data structure is in Abinitio.

### Claim 9 (depends on 1)

The system of claim 1, wherein the target data structure is in Talend.

### Claim 10 (depends on 1)

The system of claim 1, wherein automatically converting files from a source data structure to a target data structure in a second programming language is performed by a parser.

### Claim 11

A method that implements extract, transform and load migration from a source data structure in a first language to a target data structure in a second language, the method comprising the steps of:
storing source data structure files in a first programming language in a designated folder;
executing a conversion job from a source data structure to target data structure on a file by file basis;
automatically converting files from the source data structure to the target data structure in a second programming language;
storing the converted files in the same designated folder; and
importing a target data structure schema.

### Claim 12 (depends on 11)

The method of claim 11, wherein the first programming language comprises DML.

### Claim 13 (depends on 11)

The method of claim 11, wherein the second programming language comprises XML.

### Claim 14 (depends on 11)

The method of claim 11, wherein the first programming language comprises DML and the second programming language comprises XML.

### Claim 15 (depends on 11)

The method of claim 11, wherein the conversion job further comprises iterating a list of files one by one in a loop operation.

### Claim 16 (depends on 11)

The method of claim 11, wherein the conversion job comprises a DML to XML job.

### Claim 17 (depends on 11)

The method of claim 11, wherein the source data structure comprises a number of attributes and attribute characters.

### Claim 18 (depends on 11)

The method of claim 11, wherein the source data structure is in Abinitio.

### Claim 19 (depends on 11)

The method of claim 11, wherein the target data structure is in Talend.

### Claim 20 (depends on 11)

The method of claim 11, wherein automatically converting files from a source data structure to a target data structure in a second programming language is performed by a parser.
