Patent ID: 7805341

Claim:
A method of configuring an Extraction, Transformation and Loading (ETL) package for loading source data elements from a financial table of a financial data store into a reporter table having pre-defined format, the method comprising: providing a computer including a processor; providing a tangible computer-readable medium; providing an Extraction, Transformation and Loading (ETL) designer module stored on the tangible computer-readable medium, the ETL designer module comprising: a destination column class defining destination column objects each identifying a destination column of the reporter table; an association class defining association objects each identifying an association of at least one source column of the financial table with a destination column identified by a corresponding destination column object; and a transformation class defining transformation objects each responsible for a transformation of the source data elements of the source column into a reporter format of the associated destination column as identified by a corresponding association object; executing the ETL designer module using the processor; and generating instructions for configuring an ETL package, responsive to executing the ETL designer module, comprising: forming one or more association objects, each of which are instantiations of the association class and identify one or more source columns of the financial table that are associated with a destination column of the reporter table; forming a transformation object, which is an instantiation of the transformation class and defines a transformation of source data elements of at least one of the source columns from a source format into a reporter format of the associated destination column identified by the association object; and generating instructions for configuring an ETL package to extract the source data elements of the source column, transform the source data elements into the reporter format in accordance with the transformation object, and load the transformed source data elements into the associated destination columns of the reporter data table in accordance with the association objects.