Run Data Export to Azure SQL

Step 1 – Creating an Export Group

1. Navigate to the Data Management workspace in D365FO and select the “Export” button.

2. Give your Export Group a name and enter it under the “Group name” field.

1. Depending on if you are adding a single data entity to this export group or adding multiple data entities, decide if you would like to use the “Add entity” or “Add multiple” button at the top of the “Selected entities” pane.

2. Use the “Entities” field to filter on the entity(ies) you want to export and click the check mark next to the corresponding data entity(ies). In the “Target data format” dropdown, select the name of the data source that you created in section one, step two of this document. Also, make sure the setting for “Skip staging” is set to “Yes” and the “Default refresh type” is set to “Full push only.” Click “Add selected”.

*This is also known as BYODB or BYOD setup, which stands for Bring Your Own Database and is Microsoft’s solution for allowing access to copies of AxDB (D365FO Master Database) tables for reporting

Step 2 – Export the Data

1. Click the “Export” button at the top of the screen.

2. You should get the following message – Click “Close”.

3. You will now be brought to the “Execution summary” screen. Here you will see the progress of the exports. You will need to press the refresh button in order for the progress to update. When you see a check mark, you will know that the export has succeeded