Versions Compared

Old Version 3

changes.mady.by.user Aparna Tayi (Unlicensed)

Saved on

compared with

New Version 4

changes.mady.by.user Aparna Tayi (Unlicensed)

Saved on

Key

  • This line was added.
  • This line was removed.
  • Formatting was changed.


Snap Type:Write
Description:

This Snap creates records in Dynamics AX instance. This Snap uses Microsoft Dynamics AX Application Integration Framework (AIF) to communicate with Microsoft Dynamics AX 2012 servers. There are mandatory input fields that must be provided via the input view to create AX objects of different object types, and to decide which fields are mandatory you need to look at the Dynamics AX server's configuration.

ETL Transformations & Data Flow

This Snap enables the following ETL operations/flows:

  1. Extract data from the upstream Snap containing the data for creating the Dynamics AX object(s)
  2. Transform the input document into a SnapLogic friendly JSON Document
  3. Load the data into the Dynamics AX Create Snap to create the AX object(s)Input & Output
  • Input: Needs to have an upstream Snap that contains the mandatory fields for creating the AX object. Mapper Snap is a preferred upstream Snap as it populates the input schema for the selected Dynamics AX Object Type.

  • Output: A document with the result set. If the creation is successful, then the output document will contain the ID key name and ID key value of the created AX object. Note that the ID key name is usually different for each object type.

Modes

  • Ultra pipelines: May work in Ultra Pipelines.
  • Spark (Deprecated) mode: Not supported in Spark mode.
Prerequisites:

1. Microsoft Dynamics AX 2012 instance

2. An enhanced integration inbound port on the AX instance that has one or more create operations setup

Limitations and Known Issues:

None at this time.

Configurations:

Account & Access


This Snap uses account references created on the Accounts page of SnapLogic Manager to handle access to this endpoint. See Microsoft Dynamics AX Account for information on setting up this type of account.

Views

InputThis Snap has at most one document input view.
OutputThis Snap has exactly one document output view.
ErrorThis Snap has at most one document error view and produces zero or more documents in the view.


Troubleshooting:

Settings

Label

Required. The name for the Snap.

Company

The company name to perform Create operation on. The company should be defined on the AX instance side. The property can be provided through user input or pipeline parameters.

Default value: None

AIF endpoint

Required. URI of the inbound port. You may find the information at the Dynamics AX instance: System administration > Setup > Services and Application Integration Framework > Inbound ports > [Your port name] > URI.

Example: http://<host_name>/MicrosoftDynamicsAXAif60/CustomerService/xppservice.svc

Default value: None

Object type

Required. The object type to perform Create operation on. The value of the property depends on the object types contained in the target inbound port.

Example: Customer

Default value: None

Execute during preview

This property enables you to execute the Snap during the Save operation so that the output view can produce preview data.

Default value: Not selected.

 



Typical Configuration


Advanced Use Case

The following describes a pipeline, with a broader business logic involving multiple ETL transformations, that shows how typically in an enterprise environment, Create, Read, Search and Delete functionalities can be used. Pipeline download link below.  

This pipeline moves records from a Salesforce instance to the Dynamics AX instance, where the records are created, searched and read for the required IDs and deleted them as needed.

Image Added

The ETL Transformations:

  1. Extract: The Salesforce Read Snap retrieves the records from an object type from the Salesforce instance
  2. Transform: The Mapper Snap maps the records from the Salesforce object to the Dynamics AX instance 
  3. Load:The Dynamics AX Create Snap creates the records on the AX instance 
  4. Transform: The Mapper Snap maps the records to be searched from an Object type 
  5. Extract: The Dynamics AX Search Snap searches all the records 
  6. Transform: The JSON Splitter Snap splits the the records based upon the field names
  7. Extract: The Dynamics AX Read Snap reads the records based on the given fields and they are retrieved from the bottom using the Tail Snap
  8. Transform: The Mapper Snap maps the records to be deleted using the Dynamics AX Delete Snap


Downloads

Attachments
patterns.*slp, .*zip
 

Insert excerpt
Microsoft Dynamics AX Snap Pack
Microsoft Dynamics AX Snap Pack
nopaneltrue