Patent ID: 9727550
Date: 2017-08-08
CPC Classifications: G06F,G06T

Claim:
1. A computer-implemented method comprising: accessing, by a computer system, a plurality of transactional data stores, wherein particular transactional data stores are selected by a user; establishing, by the computer system, data connections to selected transactional data stores; selecting, by the user, one or more particular tables of data in the plurality of transactional data stores; extracting, by a computer system, the one or more selected tables of data from the plurality of transactional data stores and storing the data from the one or more particular tables in a local data store; presenting the data from the one or more selected tables as one or more spreadsheets to the user, the spreadsheets comprising a plurality of columns and rows; receiving a plurality of spreadsheet manipulations, by the user, to transform the data in at least one spreadsheet; automatically, by the computer system, based on to the spreadsheet manipulations, generating a plurality of data flow objects, the data flow objects being automatically configured to produce a data flow graph to cause data from the transactional data stores to be transformed according to the spreadsheet manipulations; automatically transforming, by the computer system, after each spreadsheet manipulation by the user, the data from the one or more selected tables according to the data flow graph to produce modified data; and presenting the modified data to the user in the spreadsheet.