Data Management Framework – Part2

Before using the Data Management Framework (DMF), it’s recommended to check and modify the parameters. This post aims to clarify the DMF parameters. (Workspaces > Data management or System administration > Workspaces > Data management > Framework parameters)


To deploy the DMF, you need to ensure the availability and connectivity of the DMF service to the remote server. You can test this by clicking on ‘Validate’.

Note: If you receive an error message upon validation, make sure the service is running for the current environment.

Skip Duplicate

In DMF, there is a parameter that allows you to import/export data with duplicates or to ignore errors.

For instance, if you try to import customer group records from an Excel file with duplicates (i.e., duplicate customer group IDs), you may receive an error message during the import process indicating that the records cannot be transferred to the staging table:

By activating the ‘Ignore error’ and ‘Remove duplicate’ options in the DMF parameters, you can import the records that can be imported, without inserting duplicates into the staging table and without encountering an error that stops the data job.

You can consider enabling these parameters if you want to import data into D365FO and skip error messages.

Enhanced view

The standard view for DMF is set to ‘Default by user’, but it can be changed to ‘Enhanced view’ for a better overview of entities, sequences, disabled status, filters, skip staging, and refresh type.

The following screenshots compare the standard and enhanced views. If you select ‘Standard view’, you will receive a message that it has been deprecated and will be removed. You can change your default view to ‘Enhanced’ on the Data Management Framework parameters page.

Number of legal entities for copying

You can set the maximum number of legal companies that can be involved in copy into legal entity projects.


You can define the SQL command timeout for non-BYOD jobs in seconds to prevent large import/export data jobs from failing. The same parameter can also be set for the log time to insert or update one record in milliseconds.

For BYOD jobs, you can set the SQL command timeout in seconds and send timeout for each or all companies to limit the time a BYOD project can take before timing out.

I hope you found this post helpful in providing an overview of DMF parameters and how they can be set to make your work easier. Please feel free to send any related questions or feedback using the ‘Leave a Reply’ feature.

One Comment Add yours

Leave a Reply

Fill in your details below or click an icon to log in: Logo

You are commenting using your account. Log Out /  Change )

Facebook photo

You are commenting using your Facebook account. Log Out /  Change )

Connecting to %s