1. To-Increase Dynamics 365 for Finance & Operations
  2. Data modeling studio
  3. Processing and monitoring data exchange

Process data export

If a data model is set up and deployed, you can export the data as defined in the data model.

For each data model you can define transformations to be executed automatically before and after the data model is exported.


DMS Administrator DMS Administrator Start Start Apply pre- and  post-export  transformations  to export? Apply pre- and  post-export  transformations  to export? Select pre- and post-export transformations Select pre- and post-export transformations For each data model you can define transformations to be executed automatically before and after the data model is exported. On data export for a data model, the processing transformations are used to do calculations in the target database. A processing transformation contains one or several SQL statements which define the transformation actions to be done. You can have processing transformations executed before or after exporting data: Pre-export transformations: Used to do calculations on the metadata in the target database. For example, on enumerations or labels. Post-export transformations: Used to do calculations based on the data that is just exported to the target database. Procedure 1. Go to Data modeling studio > Data modeling studio > Data models. 2. In the list, find and select the desired data model. 3. Click Processing. 4. Sub-task: Add several pre-export transformations at once. 5. In the Pre-processing section, click Add multiple. 6. In the list, find and select the desired transformations. Note: Only the transformations of category 'Processing' are shown in the list. 7. Click Ok. 8. Sub-task: Add one pre-export transformation. 9. In the Pre-processing section, click Add. 10. In the Template field, enter or select a value. Note: Only the transformations of category 'Processing' are shown in the lookup. 11. Sub-task: Add several post-export transformations at once. 12. In the Post-processing section, click Add multiple. 13. In the list, find and select the desired transformations. Note: Only the transformations of category 'Processing' are shown in the list. 14. Click Ok. 15. Sub-task: Add one post-export transformation. 16. In the Post-processing section. click Add. 17. In the Template field, enter or select a value. Note: Only the transformations of category 'Processing' are shown in the lookup. 18. Sub-task: Define sequence of pre- and post- export transformations. 19. Define the sequence in which the pre- and post-export transformations are applied. To move a transformation one position up, in the Pre-processing section or Post-processing section, select a transformation, and click Up. Note: You can also manually set the sequence in the Order field. 20. To move a transformation one position up, in the Pre-processing section or Post-processing section, select a transformation, and click Down. Note: You can also manually set the sequence in the Order field. 21. Click OK. 22. Close the page. Notes You can apply transformations without exporting the data model. To do so, on the Select processing dialog, to apply: A selection of pre-export transformations, in the Pre-processing section, select the transformations, and click Apply selected. All defined pre-export transformations, in the Pre-processing section, click Apply all. A selection of post-export transformations, in the Post-processing section, select the transformations, and click Apply selected. All defined post-export transformations, in the Post-processing section, click Apply all. Export data Export data If a data model is set up and deployed, you can export the data as defined in the data model. Procedure 1. Go to Data modeling studio > Data modeling studio > Data models. 2. In the list, find and select the desired data model. 3. Click Export. 4. Sub-task: Run export in batch. 5. In the list, find and select the export group for which you want to set up batch processing. 6. To create the batch job, click Schedule. Note: If a batch job is already created, you can skip this step. If a batch job exists, it is shown in the Job field. 7. In the list, find and select the desired export group. 8. Click Recurrence. 9. Define the desired recurrence settings, and click OK. 10. Sub-task: Optional batch-related options. 11. In the list, find and select the desired export group. 12. Click Pause. 13. In the list, find and select the desired export group. 14. Click Resume. 15. In the list, find and select the desired export group. 16. Click Run in batch. 17. In the list, find and select the desired export group. 18. Click History. 19. Close the Batch job history page. 20. Sub-task: Run direct. 21. You can directly run the export for an export group. No batch job is required to do so. In the list, find and select the desired export group. Note: You can only continue work when the export is finished. 22. Click Execute. Note: If you do a direct export, the value of the State field is not changed. The Status field is related to batch jobs only. 23. Sub-task: Refresh data on Export dialog. 24. Click Refresh. 25. Click Close. End End Yes No

Activities

Name Responsible Description

Select pre- and post-export transformations

DMS Administrator

For each data model you can define transformations to be executed automatically before and after the data model is exported.

On data export for a data model, the processing transformations are used to do calculations in the target database. A processing transformation contains one or several SQL statements which define the transformation actions to be done.

You can have processing transformations executed before or after exporting data:

  • Pre-export transformations: Used to do calculations on the metadata in the target database. For example, on enumerations or labels.
  • Post-export transformations: Used to do calculations based on the data that is just exported to the target database.

Export data

DMS Administrator

If a data model is set up and deployed, you can export the data as defined in the data model.

See also

Provide feedback