BeyondERP.Newsletter
Menu

Workspace page · System administration

Data management

A workspace that gives access to the main data management tasks and shows data projects and how they ran.

Used by
Business Performance Planning app role, Business events security role, Data management administrator and 4 more roles
Business process
Administer system features
Menu item
DM_DataManagementWorkspaceMenuItem
Data entity
None for this page's own settings
Setup steps
1 on this page
Show what matters for
PAGE GUIDEWhat the page does and how to use it8 sections. Choose a role to highlight what matters to you.
Everyone

1What it is and why

What it isA workspace that gives access to the main data management tasks and shows data projects and how they ran.
What you do hereUse this workspace to import and export data, copy data into another legal entity, and manage data projects built from data entities, templates and data packages.
ExampleFor example, the BEAT team exports the 010 - System Setup template from a test environment as a data package and imports it into the go-live environment from the Import tile, then follows the job on Job history.
Data management page in Dynamics 365
The page in Dynamics 365. page title tab to open what to set or check
Functional consultant · Solution architect

2Where it fits

Business processAdminister system features
Menu pathSystem administration › Workspaces › Data management
Set up firstConfigure cross-company data sharing Microsoft Learn
Used next byBatch jobs (import runs in batch) Microsoft Learn
Related pagesSystem parameters Microsoft Learn
End user · Functional consultant

3How to do it

About the examples: Examples and screenshots in this guide use BEAT, a demo company in a Dynamics 365 test environment. Use your own company's codes and values instead of copying them.

Setup steps on this page

Load configuration through the Data management workspace

Use the workspace to move configuration between environments with data packages and templates.

Steps from Microsoft

  1. On the dashboard, open the Data management workspace.
  2. Select the Import tile.
  3. Enter a name for the import.
  4. In the Source data format field, select Package.
  5. Select Upload and choose the package file.
  6. Select Save, and then select Import.
  7. Use Refresh to follow the progress of the import.

Source: Microsoft Learn

Fields on the page

FieldWhat it meansExample
Import / Export tilesStart a data project that reads a file or package into entities, or writes entities out to a file or package.Microsoft Learn
Data projectsThe saved import and export projects, each with its entities, format and sequence.Microsoft Learn
Job historyEach run of a data project with its status and execution log.Microsoft Learn
TemplatesPredefined lists of entities per module area, such as 010 - System Setup.Microsoft Learn 010 - System Setup

Common errors and fixes

MessageWhat to do
An import fails because a record it refers to doesn't exist yetLoad entities in the order of Microsoft's templates: lower levels first, and entities at the same level in sequence order. Microsoft Learn

Test checklist

  1. Create an export project with one entity, for example User groups, and export it as a package.
  2. Import the package into a test company with a new import project.
  3. Open Job history and check the run ended without errors.
  4. Open the target page and check the records are there.

Source: Microsoft Learn

Functional consultant

4Setup decisions

Setup stepRecommended value and whyDecision, common mistake and test
Load configuration through the Data management workspaceBuild import and export projects from Microsoft's default templates (010 - System Setup first) and keep their sequenceThe templates order the entities by level and sequence, so records that others depend on load first.How is configuration moved between environments?Adding entities to a project one by one without a sequence; the import then fails on records that refer to rows not yet loaded.Test: A template package imports cleanly

Feature management and licence

Licence or add-inOn this system the page opens for Information technology manager, Data management administrator, Business events security role, Data management operations user and Business Performance Planning app role. Data management administrators and migration users work here. No Feature management feature needs to be turned on for this page.

Microsoft Learn

Solution architect

5Design impact

Shared or per companyA data project runs in the company you are signed in to; shared entities load for all companies at once. Microsoft Learn
Can it be undoneHard to reverse: An import writes to the target tables. There is no undo of an import; correct the data with a new import or by hand. Microsoft Learn
If you change it laterJob history entries and their staging data older than 90 days are deleted automatically (from September 2023); a shorter retention needs the Execution history cleanup feature. Microsoft Learn
Technical architect

6Technical

Menu itemDM_DataManagementWorkspaceMenuItem Checked in Dynamics 365
FormDataManagementWorkspace Checked in Dynamics 365
Data entitiesDataManagementDefinitionGroupEntityDefinition Groups (only the data projects (definition groups) of the workspace) DataManagementExecutionJobEntityJob runs (only the history of data project runs)
Who can open itPrivilegesData management application administrator DataManagementMaintainMaintain data import export tasks DataManagementOperationsMaintainView data import export tasks DataManagementOperationsViewDutiesApplication document entities DataManagementMaintainMaintain data import export operation processes DataManagementOperationsMaintainView data import export operation processes DataManagementOperationsView
12 security rolesBusiness Performance Planning app role BPPBudgetPlanningAppRoleBusiness events security role BusinessEventsSecurityRoleData management administrator DataManagementAdministratorData management migration user DataManagementMigrationUserData management operations user DataManagementOperationsUser DmfTest_SecurityRoleDemand planning app role ScpDemandPlanningAppRole SysDETstTPFDeleteAccessEntityWithoutTPFAccess SysDETstTPFDeleteAccessEntityWithTPFAccess SysDETstTPFReadAccessEntityWithoutTPFAccess SysDETstTPFReadAccessEntityWithTPFAccessInformation technology manager SysServerITManager
Checked in Dynamics 365
Roles to set it up and use itTo set it up or change itInformation technology manager SysServerITManagerData management administrator DataManagementAdministratorBusiness events security role BusinessEventsSecurityRoleData management operations user DataManagementOperationsUserBusiness Performance Planning app role BPPBudgetPlanningAppRoleGive people one of these roles. On this system, 7 roles can open this page.Checked in Dynamics 365
Actions on the pageOptions: Personalize, Page options, ShareChecked in Dynamics 365
Developer

7Developer

Open it by URLhttps://<your-environment>/?mi=DM_DataManagementWorkspaceMenuItem
Data migrationDataManagementDefinitionGroupEntity (Definition Groups): shared by all companies; not in Microsoft's default templates.DataManagementExecutionJobEntity (Job runs): shared by all companies; not in Microsoft's default templates.Load order: Neither entity is part of Microsoft's default configuration templates in this system; add them to their own data project when you need to move data projects.Checked in Dynamics 365
Everyone

8Sources