Using entities to export data to custom database (BYOD) in AX7 / D365

This topic explains how administrators can export data entities from Microsoft Dynamics 365 for Finance and Operations into their own Microsoft Azure SQL database. This feature is also known as bring your own database (BYOD). 

We start by starting with the following steps:

Create your custom database in SQL

Create Login for the DB created

Assign DB to the created login

Now go to Data Management in AX.

Next go to Configure Entity export to database

Now click on Validate. You will receive following error initially

To resolve this follow the following steps:

Now validate again

Now click Publish.

Select The entity that you want to use for data export

Now create an export project for the entity you have published

Export data through this entity and the data will be dumped into your custom database