System and method for implementing an extract transform and load (etl) migration tool
OwnerJagmohan SINGH, Ravikanth H. CUTTAMBAKAMinventors
Life of this patent
Estimating the term…
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.
Claims20
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.
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.
Dependencies are inferred from the claim text.