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

This topic explains how to export data entities from Dynamics 365 Finance & Operations into their own Microsoft Azure SQL database. This feature is also known as Bring Your Own Database (BYOD). This feature was released with platform update 2 with Minor improvements and bug fixes in subsequent platform updates.

Currently, more than 1,700 data entities are available and it allows us to export data (via data entities) into another Azure SQL Database where normalized and aggregated data can be easily accessed for reporting, BI or integration purposes. Export can be done via full push (all data) or incremental push (only changed records).

Introduction

This is part one of a three-part series, In this part I talked about Data base type and the idea behind BYOD (Bring Your Own Database) , In second 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. Before start BYOD (Bring Your Own Database) system configuration within Dynamics 365 for Finance and Operations (Dynamics 365 Finance & Operations), let us understand the data model.

We has 3 data stores in Dynamics 365 Finance & Operations:

1.     Primary Data Base : 

• This is the operational database and experimental results are submitted directly into the database by any other tool-set.

1.     Secondary Data Base: 

• This is a real-time replicated database, which is used to support the application and also experimental results are submitted directly into the database by any other tool-set.

1.     Entity Store or BYOD : 

• Entity store is the operational data warehouse it can be thought of as a database attached to the primary operational database(s) but whose function is to expose the data entities in an aggregated way – note that the Entity store resides within the Dynamics 365 Finance & Operations system.

Conclusion

In this article, I talked about Data base type and the idea behind BYOD(Bring Your Own Database) , In second 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.