Abstract: A system for capturing the context of, and translating, or mapping, from data in an originating database presentation, or in an originating format, to data in a target database presentation, or target format. The translation uses the context of the originating report/query in terms of the originating database as a basis for the translation. The originating context is translated to the target context and is used to accurately map data from one presentation to another. By using a context and a translation map, which define specifics of the translation between contexts against different data sources, the invention is able to achieve a mapping engine that can efficiently map data between databases of different types. The translation map includes rules set automatically by the system, or set by a human administrator. The rules permit special treatment of different mapping scenarios.

Abstract: A system for capturing the context of, and translating, or mapping, from data in an originating database presentation, or in an originating format, to data in a target database presentation, or target format. The translation uses the context of the originating report/query in terms of the originating database as a basis for the translation. The originating context is translated to the target context and is used to accurately map data from one presentation to another. By using a context and a translation map, which define specifics of the translation between contexts against different data sources, the invention is able to achieve a mapping engine that can efficiently map data between databases of different types. The translation map includes rules set automatically by the system, or set by a human administrator. The rules permit special treatment of different mapping scenarios.