Inventors:
David John Ballesty - Blowing Rock NC, US
International Classification:
G06F 17/30
Abstract:
An advantageous system and method are provided for supporting and/or enabling the creation of Data Warehouse Scripts and/or data transfer in connection with a SQR-based application or program. The disclosed system and method offer a full complement of data warehousing and data transfer capabilities. In addition, the system and method of the present disclosure may be used in conjunction with and/or incorporated as part of an Enterprise Resource Planning or Business Intelligence platform on stand-alone clients and/or networked clients. The disclosed system and method generally include a object based mapping technology that captures both business rules and metadata, a database in communication with the mapping client, and creation formula that allows multiple levels of selection, subselection, transformation, and database actions that functions to control retrieval of data from the database, transformation of that data, and reinsertion to another or same target database.