Collaborative data mapping system
A data mapping system provides a share, reusable and single mapping tool for mapping data and data lineage. The mapping system provides a version control functionality in the form of spreadsheet for tracking a plurality of mapping tasks that occur in parallel. The system allows multiple users to view the changes in mapping tasks, thereby improving data mapping visibility. Such visibility can significantly reduce conflicts between different mapping tasks that are independently performed by different teams or persons.
1. A method for mapping data, the method comprising:
obtaining, by a computing device, a plurality of versions of a mapping specification, the mapping specification describing how data from a source information system maps to a destination information system;
merging, by the computing device, the plurality of versions of the mapping specification to generate a master version of the mapping specification, wherein the master version of the mapping specification is created by merging a first version of the plurality of versions of the mapping specification with a second version of the plurality of versions of the mapping specification;
identifying, by the computing device, any conflicts between data elements in the master version of the mapping specification based on one or more predetermined business rules;
generating, by the computing device, a severity score of the conflicts, wherein the severity score indicates a significance of the conflicts and whether the conflicts should be fixed; and
generating, by the computing device, an alert based upon the conflicts.
2. The method of claim 1 , further comprising identifying a nature of the conflicts between the data elements in the master version of the mapping specification.
3. The method of claim 1 , wherein obtaining the plurality of versions includes:
obtaining the first version associated with a first mapping project of a first user; and
obtaining the second version associated with a second mapping project of a second user.
4. The method of claim 1 , further comprising generating a user interface including information on the mapping specification.
5. The method of claim 4 , wherein the user interface includes a rule column listing the one or more predetermined business rules.
6. The method of claim 5 , wherein the user interface includes a filters column programmed to filter data values.
7. The method of claim 6 , wherein the filter data values are based on types, fields, and other elements based on business rules.
8. A system for mapping data, the system comprising:
a processor; and
memory encoding instructions which, when executed by the processor, causes the system to:
obtain, by the processor, a plurality of versions of a mapping specification, the mapping specification describing how data from a source information system maps to a destination information system;
merge, by the processor, the plurality of versions of the mapping specification to generate a master version of the mapping specification, wherein the master version of the mapping specification is created by merging a first version of the plurality of versions of the mapping specification with a second version of the plurality of versions of the mapping specification;
identify, by the processor, any conflicts between data elements in the master version of the mapping specification based on one or more predetermined business rules;
generate, by the processor, a severity score of the conflicts, wherein the severity score indicates a significance of the conflicts and whether the conflicts should be fixed; and
generate, by the processor, an alert based upon the conflicts.
9. The system of claim 8 , comprising further instructions which, when executed by the processor, causes the system to identify a nature of the conflicts between the data elements in the master version of the mapping specification.
10. The system of claim 8 , wherein to obtain the plurality of versions includes to:
obtain the first version associated with a first mapping project of a first user; and
obtain the second version associated with a second mapping project of a second user.
11. The system of claim 8 , comprising further instructions which, when executed by the processor, causes the system to generate a user interface including information on the mapping specification.
12. The system of claim 11 , wherein the user interface includes a rule column listing the one or more predetermined business rules.
13. The system of claim 12 , wherein the user interface includes a filters column programmed to filter data values.
14. The system of claim 13 , wherein the filter data values are based on types, fields, and other elements based on business rules.