Method and system for an administrative apparatus for creating a business rule set for dynamic transform and load

An article of manufacture for an administrative apparatus for creating a business rule set for dynamic transform and load, the article comprising a computer-readable medium encoded with logic for:

• reading a business rule template definition;
• reading a source metadata defining a data source;
• reading a store metadata defining a data store;
• displaying output to a user based on the source metadata and the store metadata;
• accepting input from the user indicating desired correspondence between source metadata and the store metadata;
• creating a business rule set based on the business rule template definition and the input.

A system for an administrative apparatus for creating a business rule set for dynamic transform and load, the system comprising:

• a computing device comprising a memory and a processor,
• a communications interface enabling communication between the computing device and a dynamic transform and load engine (DTLE) processor;
• wherein the computing device is configured to retrieve source metadata from a data source, retrieve a business rule template definition from a template database, and retrieve store metadata from a data store;
• wherein the computing device is operably configured to:
• (a) display information to a user based on the source metadata, the business rule template definition, and the store metadata;
• (b) accept input from the user;
• (c) based on the input, create business rule sets for instructing the DTLE processor in dynamically transforming and loading data from a data source to a data store.