Abstract: Provided is a method for an administrative apparatus for creating a business rule set for dynamic transform and load. A business rule template definition is obtained. A source metadata defining a data source is obtained. A store metadata defining a data store is obtained. Output is displayed to a user based on the template definition, the source metadata, and the store metadata. Input is accepted from the user indicating desired correspondence between source metadata and the store metadata. A business rule set is created based on the business rule template definition and the input. The method may be encoded onto a computer-readable medium, providing an article of manufacture. A system for an administrative apparatus for creating a business rule set for dynamic transform and load is also provided.

Abstract: Provided is a method for dynamic transform and load of data from a data source defined by metadata into a data store defined by metadata. A business rule set is created (116) based on (a) a business rule template definition, (b) metadata defining at least a portion of data of a data source, and (c) metadata defining a data store. Data from the data source is transformed (118) based on the business rule set. The data is loaded (120) into the data store based on the business rule set. The transforming and loading are repeated (122) until all desired transforming and loading of data from the data source to the data store has been accomplished. The method may be carried out through execution of a computer programming product containing suitable logic. A system (100) for dynamic transform and load is also provided.