Method, system and program product for mapping data fields between a data source and a data target
AssigneeInternational Business Machines Corporation
InventorScott R. Morris
Life of this patent
Estimating the term…
Abstract
An input stream in which a data source, a data target, source data fields and target data fields is defined. Any field identifier that is identical to another field identifier is modified to be unique. Once the field identifiers are modified as necessary, the source data fields will be mapped to the target data fields based on the field identifiers. After mapping, the field identifiers will be changed back to their original state, and data associated with the source data fields will be communicated to the data target.
Claims27
A method for mapping data fields between a data source and a data target:
- providing an input stream, wherein the input stream identifies the data source, the data target, and a set of data fields;
- modifying a field identifier for each one of the set of data fields that has a field identifier in common with another one of the set of data fields;
- mapping the set of data fields between the data source and the data target;
- and
- returning each modified field identifier to an original state.
A method for non-programmatically mapping data fields between a data source and a data target:
- providing an input stream, wherein the input stream identifies the data source, the data target, source data fields and target data fields;
- modifying a field identifier for each one of the target data fields that has a field identifier in common with another one of the target data fields;
- graphically mapping the source data fields to the target data fields after the modifying step;
- and
- returning each modified field identifier to an original state after the graphically mapping step.
A system for non-programmatically mapping data fields between a data source and a data target, comprising:
- an input system for receiving an input stream, wherein the input stream identifies the data source, the data target, source data fields and target data fields;
- and
- a modification system for modifying a field identifier for each one of the target data fields that has a field identifier in common with another one of the target data fields, wherein a modified stream containing each modified field identifier is communicated to a system for graphically mapping the source data fields to the target data fields, and wherein each modified field identifier is returned to an original state after the source data fields are mapped to the target data fields.
A system for mapping data fields between a data source and a data target:
- a definition system for defining an input stream, wherein the input stream identifies the data source, the data target, source data fields and target data fields;
- a connector system for receiving the input stream and for modifying a field identifier for each one of the target data fields that has a field identifier in common with another one of the target data fields;
- a mapping system for receiving a modified input stream that includes each modified field identifier and for mapping the source data fields to the target data fields;
- and
- an activity system for receiving the modified input stream and the mapping of the source data fields to the target data fields, wherein the activity system communicates the modified input stream, the mapping of the source data fields to the target data fields and data associated with the source data fields to the connector system, and wherein the connector system returns each modified field identifier to an original state after the source data fields are mapped to the target data fields.
A program product stored on a recordable medium for non-programmatically mapping data fields between a data source and a data target, which when executed, comprises:
- program code for receiving an input stream, wherein the input stream identifies the data source, the data target, source data fields and target data fields;
- and
- program code for modifying a field identifier for each one of the target data fields that has a field identifier in common with another one of the target data fields, wherein a modified stream containing each modified field identifier is communicated to program code for graphically mapping the source data fields to the target data fields, and wherein each modified field identifier is returned to an original state after the source data fields are mapped to the target data fields.
A program product stored on a recordable medium for non-programmatically mapping data fields between a data source and a data target, which when executed, comprises:
- program code for defining an input stream, wherein the input stream identifies the data source, the data target, source data fields and target data fields;
- program code for receiving the input stream and for modifying a field identifier for each one of the target data fields that has a field identifier in common with another one of the target data fields;
- program code for receiving a modified input stream that includes each modified field identifier and for mapping the source data fields to the target data fields;
- and
- program code for receiving the modified input stream and the mapping of the source data fields to the target data fields, wherein each modified field identifier is returned to an original state after the source data fields are mapped to the target data fields.
Dependencies are inferred from the claim text.