Data Mapper - Connect All (Magic xpi 4.13)
Data Mapper can have a large and complex schemas on the Source and/or Destination side. Creating connections one by one for all the nodes can be time-consuming. To avoid this, the Connect All feature of the Mapper can be used. With this the user can do bulk connections just by few clicks.
The user can connect multiple nodes from Source to Destination by connecting complex nodes from the Source to Destination or multi-selecting simple or leaf nodes on the Source and connecting them to the Destination.
This option allows the user to select a complex node on the Source and connect it with the complex node on the Destination using any one of the three options Simple, Fuzzy and 1:1 further explained in the document. Here, Data Mapper will try to bulk match and connect all the child elements of the selected complex node to the Destination as per the selected option. The user can select either the root node or multi-occurrence node to map the connections. Connections to single occurrence nodes are not supported.
The user can use this option to connect only selected nodes instead of bulk matching above.
Here the user will select multiple simple or leaf nodes on the Source and connect them with the required simple nodes on the Destination side. If the user selects a node that doesn't match one of the selected nodes on the Destination, the Mapper will not do the connections. If the node matches one of the selected nodes, the Mapper will connect the nodes as per the option selected.
The connections using both the ways above can be done based on either of the options below:
-
Simple
-
Fuzzy
-
1:1
The Mapper will connect all the child nodes of the selected complex node based on the chosen criteria.
The Data Mapper will create connections between the Source and Destination by matching the exact node's name . Here the full name of the nodes on both source and destination should be same. The name matching is not case sensitive.
For example, look at the image given below. Here the nodes to be mapped have exact matching names but are in mixed order. So, mapping can be done using the Simple Connect All option.
The Data Mapper will create connections between the Source and Destination using a smart matching algorithm based on the defined rules. The node names matching will be done as per the order given below. The name matching is not case sensitive.
Partial name match ranked in the following order:
-
Destination node name is same as the source node name
-
Destination node name begins with the source node name.
-
Destination node name ends with the source node name.
-
Destination node name contains the source node name.
For example, look at the image given below. Here the nodes to be mapped are not the same but match based on the above rules. So, mapping can be done using the Fuzzy Connect All option.
This will directly link the nodes on Source to Destination in sequence.
The first node on Source will be linked to the first node on Destination, second node to second node and so on till next match is found. Here there will be no matching based on the name or data type of the nodes.
|
|
It will be the user’s responsibility to verify the correctness of linked nodes.
|
For example, look at the image given below. Here the nodes to be mapped are in same order on both the sides. So, mapping can be done using the 1:1 Connect All option.
The selection of complex node(s) on the Destination side is not supported when performing the Connect All operation for the multi-selected nodes on the Source side.
Look at the examples given below:
Invalid Scenario:
Valid Scenario:
(Since version: 4.13)
