BYOD ( Bring Your Own Database in Dynamics 365 Finance & Operations) : Part 2

This is part second of a three-part series, In first part I talked about Data base type and the idea behind BYOD (Bring Your Own Database) , In this part, I will set up BYOD (Bring Your Own Database), and in the third part We will check some system logs for error messages as a result of BYOD (Bring Your Own Database) runs.

How-to set up BYOD ( Bring Your Own Database in Dynamics 365 Finance & Operations)

BYOD ( Bring Your Own Database in Dynamics 365 Finance & Operations) uses the Data Management Framwork Export services in Dynamics 365 for Finance and Operations, found in the “Modules > System Administration > Data Management” workspace of the environment.

Let’s begin. We will walk through the steps to set up BYOD ( Bring Your Own Database in Dynamics 365 Finance & Operations):

Step 1: set up configuration to Azure SQL DB

• Go to the System administration >> Data management >> Configure data source 

• Create a new Data source name BYODW and type Azure SQL DB

• Go to the System administration >> Data management >> Configure entity export to database 

• Go to your new created data source BYODW and replace the connection string with the given code and Validate:

• Go to the System administration >> Data management >> Data Entities

• Select all entities one by one and click Publish

• Select the BYODW data source and then Publish All

• After Publish all entity in BYODW data source Go to System administration >> Data management >> Data Entities and Select all entitie which one you want to Export under change tracking and click Change tracking after that you have to select Enable entire Entity

Step 2: export data to Azure SQL DB

• When all entity Published and Enabled change tracking then Go to System administration >> Data management >> Export and Create a new Group BYODW

• Click on Add Entity button and select all Entity which you want to export in your own Database(BYOD)

•  Click Export.

Congratulations, you have now set up BYOD ( Bring Your Own Database in Dynamics 365 Finance & Operations).