Finance | Project Operations, Human Resources, ...

BYOD purpose in D365F&O

(0) Share

Report

Posted on by CU22111441-0

Hello, I have searched in Google and found many blogs about BYOD. I understood the BYOD configuration required.

But still I have one confusion, when the BYOD is recommended to use. I mean the actual needed to implement BYOD in D365F&O. What is the purpose to use of this.

Please provide me the thoughts. thanks

Categories:

Dynamics 365 Finance

I have the same question (0)

All responses (4)

Answers (0)

Suggested answer

Aymen CHELBI 502 on at

Like (0)

Report
BYOD purpose in D365F&O

Hello,

BYOD allows you to export data entities from D365FO into your own SQL Server database, instead of using the Entity Store (AXDW) or Data Entity, which isn’t accessible to end users in production. With BYOD, you can export data manually, through batch jobs, via the standard DMF export projects.

To use BYOD, you first configure your SQL database in the Data management workspace under Configure Entity export to database. After that, you can publish entities to create the corresponding SQL tables, and then run DMF export jobs targeting your BYOD database.

Advantages

Full access to exported data in your own SQL database

Ability to filter data during export

Can be automated through batch jobs

Disadvantages

One-way integration (export only)

For more detail : Bring your own database (BYOD) - Finance & Operations | Dynamics 365 | Microsoft Learn

Best regards,

Was this reply helpful? Yes No
CU22111441-0 64 on at

Like (0)

Report

BYOD purpose in D365F&O

Thanks Aymen, I understood well the steps you mentioned. Finally, you mentioned that export the data in to BYOD database.

Now, my questions is , When we completed the export process of BYOD, then next where we used that BYOD db in real world.

Is it strongly recommended for Power BI?

Please give me your thoughts.

Was this reply helpful? Yes No
Sohaib Cheema 49,258 User Group Leader on at

Like (0)

Report

BYOD purpose in D365F&O

Hi ,

BYOD was introduced mainly to address reporting needs. When Microsoft blocked access to the production database with the release of AX7, people still wanted to create reports using direct SQL. Microsoft introduced BYOD so you can export Dynamics data to your own Azure SQL database and work with it as needed. Most commonly, it’s used to build Power BI reports.

I have also seen people use the BYOD database for integration purposes.

Once you have data in your own Azure SQL instance, do whatever you like with it.

Was this reply helpful? Yes No
Suggested answer

Martin Dráb 237,389 Most Valuable Professional on at

Like (0)

Report

BYOD purpose in D365F&O

There may be many reasons why you want to export to your own database. It may be for reporting, analytics, integration or so. It also you to use existing tools that connects to databases (you don't have access to the F&O production DB), you can combine data from multiple systems, transform the data to meet particular needs and so on.

Nevertheless note that BYOD is considered a legacy solution. Check out Transition from legacy data integration services, for instance, to learn about the current options.

Was this reply helpful? Yes No

Join the conversation

Community site session details

BYOD purpose in D365F&O

Helpful resources

Quick Links

Responsible AI policies

Pallavi Phade – Community Spotlight

Congratulations to the October Top 10 Community Leaders!

Leaderboard > Finance | Project Operations, Human Resources, AX, GP, SL

Featured topics

Product updates

Community site session details

BYOD purpose in D365F&O

Helpful resources

Quick Links

Responsible AI policies

Pallavi Phade – Community Spotlight

Congratulations to the October Top 10 Community Leaders!

Subscribe to this forum!

Select categories

Leaderboard > Finance | Project Operations, Human Resources, AX, GP, SL

Featured topics

Product updates