Share
ReportDear All
Can you please let me know when we use exactly BYOD ( Bring your own database).
What is the purpose of use BYOD ?
Please give me more she'd on this
Thanks!
Categories:
You’re offline. This is a read only version of the page.
5,885
Dear All
Can you please let me know when we use exactly BYOD ( Bring your own database).
What is the purpose of use BYOD ?
Please give me more she'd on this
Thanks!
Entity store (AxDW) and BYOD are not same. If you go through the MS documentation here, you will find a section "Entity store or BYOD", which will help you understand how they are different.
Apart from this, there are multiple posts you can check regarding their differences. I am listing down a couple of them here -
MsDyn365FO Entity Store (AxDW) vs. BYOD – MsDyn365FO.Blog (wordpress.com)
Umm… What’s the difference between entity store and BYOD? (dynamicconsulting.com)
Other tools can not access D365 Db directly but with your own DB you can export data out of D365 and query this database and do your reporting.
-You can dump the data (either from D365FO or another resource) and generate report based on the data.
-You don't need to hit the D365FO DB whenever you are generating report.
Hi @rp@n,
What do you mean with "real example documents step by step"? The documentation provided above is already a step-by-step document. There are over 1500 data entities, a lot of reporting tools which can connect to a database for reporting. The options to do something with this database are in fact unlimited.
Hi,
If you need more than built-in integration of operational reports with Power BI provided by Entity store, and require T-SQL access to data, you can use BYOD. In summary, the purpose of BYOD:
1. Define one or more SQL databases that you can export entity data from Finance and Operations into.
2. Export either all the records (full push) or only the records that have changed or been deleted (incremental push).
3. Use the rich scheduling capabilities of the Finance and Operations batch framework to enable periodic exports.
4. Access the entity database by using Transact-SQL (T-SQL), and even extend the database by adding more tables.
You can export data though entities in your own db . You can use that data further to build your reports using power BI etc.
Stay up to date on forum activity by subscribing. You can also customize your in-app and email Notification settings across all subscriptions.
#1
André Arnaud de Cal...
284,876
Super User
#2
Ludwig Reinhard Microsoft Employee
#3
Martin Dráb
225,425
Super User
All responses (
Answers (