Patent ID: 8880463

Claim:
A method comprising: identifying at least two computing systems and a plurality of data objects from the identified computing systems containing predetermined data, wherein at least one of the computing systems is a legacy computing system; obtaining a hierarchical list of tables and fields of each table from an external data source, wherein each of the tables and fields is associated with at least one of the plurality of data objects; identifying a selection of at least one table or field from the hierarchical list; identifying, using a processing device, legacy computing system archive files that include the selected at least one table or field, wherein each archive file archives data; extracting, using the processing device, the selected at least one table or field from the identified legacy computing system archive files; merging the extracted tables or fields from the archive files with data obtained from the at least two computing systems; outputting a consolidated result from the merged data; selecting a legacy system specific schema for extracting data from each type of legacy computing system; creating a table in the selected schema; populating the created table with data extracted from a legacy system having a type corresponding to a type of the selected legacy system specific schema.