Integration through the data management platform provides more capabilities and higher throughput for inserting/extracting data through entities. Typically, data goes through three phases in this integration scenario:
The following diagram shows an inbound flow.
When you import text files, string sizes are limited to 32,768 characters. If there is a string larger than this, the imported string will be truncated. This is a limitation in the underlying implemenation and is due to SQL Server Integration Services (SSIS).
If you need to import strings that are larger than 32,768 characters, we suggest that you use container entity fields.
Generating a Data Import Template
Here are the required steps for how to create a Data Import Template in Dynamics AX 7.
Lots of default templates were prepared by Microsoft to allow a user to import various datasets in Dynamics AX 2012. These templates were prepared using specific fields, and in many cases, not all fields in a table were added to these templates by default.
In a newer release Microsoft Dynamics AX 7 - while no predefined templates have been provided by default, the process for creating these templates has been simplified. A user can choose to populate these templates with relevant data from the AX database as they are being generated, and can also use a data query to populate only a subset of the data.
To generate a data Import File, first we need to create an Export – Data Project.
The following steps are required to create an Import File from the Data Project area in the Data Management workspace:
The file that we created during the previous process can now be used to import data into Dynamics AX following these steps from the Data Management workspace:
Using the Data Management’s built-in process you can easily and effectively create various data Import Templates. You can choose for all the available database fields to be added to the Data Project and the associated Template or only a subset of selective database fields.
Dynamics 365 - Common Data Service
Dynamics 365 - Batch processing overview