Abstract: A graphical mapping interface and method are provided for creating and displaying a schema map, which is used by a data transformation system to perform a data transformation between a primary source schema and at least one target schema. The graphical mapping interface includes a main map window and a mini-map window. The main map window is adapted for displaying a graphical representation of a primary source schema. The mini-map window is adapted for creating a mapping between one or more nodes of the primary source schema and one or more nodes of an intermediate target schema, and displaying a graphical representation of the mapping within the mini-map window. Upon closing the mini-map window, a graphical representation of the intermediate target schema is displayed along with the primary source schema within a source schema region of the main map window and is accessible for mapping within the main map window.

Abstract: Embodiments of a graphical mapping interface and method are provided herein for creating and displaying a schema map, which may be used by a data transformation system to perform a data transformation between at least one source schema and at least one target schema. According to one embodiment, the graphical mapping interface may generally comprise a main map window and a mini-map window. The main map window comprises a source schema region, which is adapted for displaying a graphical representation of a primary source schema defining a structure of a primary data source. The mini-map window is adapted for creating a mapping between one or more nodes of the primary source schema and one or more nodes of an intermediate target schema, and displaying a graphical representation of the mapping within the mini-map window.

Abstract: Graphical mapping interface embodiments and method are provided for creating and displaying a schema map, which may be used by a data transformation system to perform a data transformation between at least one source schema and at least one target schema. According to one embodiment, the graphical mapping interface may comprise a source schema region for displaying a graphical representation of at least one source schema, a target schema region for displaying a graphical representation of at least one target schema, and a mapping region for displaying graphical representations of a plurality of links connecting the source nodes displayed in the source schema region to the target nodes displayed in the target schema region. The plurality of links may comprise at least one control link having at least one ECA rule associated therewith and at least one data link having at least one textual-based target field expression associated therewith.

Abstract: Graphical mapping interface embodiments and method are provided for creating and displaying a schema map, which may be used by a data transformation system to perform a data transformation between at least one source schema and at least one target schema. According to one embodiment, the graphical mapping interface may comprise a source schema region for displaying a graphical representation of at least one source schema, a target schema region for displaying a graphical representation of at least one target schema, and a mapping region for displaying graphical representations of a plurality of links connecting the source nodes displayed in the source schema region to the target nodes displayed in the target schema region. The plurality of links may comprise at least one control link having at least one ECA rule associated therewith and at least one data link having at least one textual-based target field expression associated therewith.

Abstract: A system and method is described for event-driven data transformation. Generally, the system and method is directed to a transformation engine that iterates through one or more data sources, transforms data received from the data sources, and stores the output to one or more data targets. More specifically, the transformation engine is driven by executing specified event actions upon occurrence of specified triggering events. Thus, flexible, adaptable, highly tailored transformations can be implemented without incurring the often substantial expense of developing customized point-to-point solutions from scratch. The present invention supports one-to-one mappings, many-to-one mappings, one-to-many mappings, and many-to-many mappings. In addition, the present invention supports both hierarchical and flat data sources and targets.