AX7/D365/Operations: Data export using data entities

DataManagement


Purpose:

The purpose of this document is to demonstrate how we can export data using out-of-band (OOB) data entities from Dynamics 365 for Operations.

Prerequisites:

  • Access to Dynamics 365 for Operations instance via remote desktop.
  • To be provisioned as an administrator or at least data management officer for the instance.

Business requirement:

Ability to export customer master for USMF legal entity.

Process:

1. Navigate to Workspaces > Data management.
2. Click Export tile.
3. Enter JOB DETAILS as follows. We have selected Customers data entity for this scenario.

Step1

4. Click Add entity button. You should see Customers data entity added to the right pane.
5. Click Export button.
5. After the job ends, you can see the count of records exported on the Execution summary screen.

Step3

6. Click the ellipsis button to download the file.

Step4

7. You should be able to see the exported records in the Excel file.

Result

Advertisements

One thought on “AX7/D365/Operations: Data export using data entities

  1. I am right in concluding that standard entities from AX7/D365/Operations only contain the business key, but never the technical primary key of the associated table?

Leave a Reply

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

WordPress.com Logo

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

Google+ photo

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

Twitter picture

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

Facebook photo

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

w

Connecting to %s