Create a Target transformation in the Mapping Designer to write data to Microsoft Dynamics AX 2012. When you select a Microsoft Dynamics AX V3 connection for a Target transformation in a mapping, you can select an operation based on the imported WSDL. When you want to write data that is in relational format to Microsoft Dynamics AX 2012, the Secure Agent converts the relational data to a hierarchical format before writing to Microsoft Dynamics AX 2012.
When you configure a Microsoft Dynamics AX 2012 target, you can select Write Operations on the Target tab to display the subset of write operations supported by the WSDL you specified in the Microsoft Dynamics AX V3 connection properties. If you select All Operations, all the supported operations for the WSDL display. The Secure Agent creates target fields based on the request message structure of the operation you select on the Target tab.
When you write data to Microsoft Dynamics AX 2012, the Secure Agent includes all the incoming fields from the source, by default. You can exclude the incoming fields, if required. You can add multiple input groups into the Microsoft Dynamics AX V3 target and define the primary and foreign key relationships between the multiple input groups before you run the mapping.
You can add the input files in a Source transformation, and use the Joiner transformation to join data from multiple files to create one target file. Use the data from the target file to create the final source file.
The following image shows the mapping configured to create one target .csv file that includes all the referential information:
The following image shows the fields from the customer object in Microsoft Dynamics AX V3:
The following image shows the fields from the person reference object in Microsoft Dynamics AX V3:
The following image shows the fields from the address reference object in Microsoft Dynamics AX V3:
Use Joiner transformations to join the data from the files.
The following image shows a configured Join condition to join the customer and person reference data:
The following image shows the included fields for the customer and person reference data:
The following image shows a join condition to join the customer_person and address reference data:
The following image shows the included fields for the customer_person and address reference data:
When you run the mapping, the Secure Agent writes data to a configured target .csv file. Later, use this file as a source from which you write data to Microsoft Dynamics AX 2012.
Field Mapping in a Target Transformation
You can map fields that are in a relational structure to the hierarchical structure used by a Microsoft Dynamics AX V3 target.
On the Field Mapping tab for the Target transformation, the fields in the Target Fields appear in hierarchical format. The target fields are determined by the request message structure of the operation you select for the Target transformation.
Each source object displays as a group in the Input Fields area. You can select fields in the Input Fields area to map the fields to the request. If the input fields include multiple input groups, map the groups to the corresponding nodes in the request. Be sure to map all of the fields that you require in the request.
The following image shows an example of mapped input fields from the source file with the Microsoft Dynamics AX V3 target in an operation create:
