Anyone that wants to create reports (RDLC, WORD, PowerBI, other) at a certain moment needs to know where to find what information and how the different tables are linked.
Anyone who wants to create an app and add fields to certain tables also needs to clearly understand the database schema of Business Central.
Imho this is essential documentation that is currently very difficult to find. There are bits and pieces available on docs, yammer and github, but it's very difficult to see the trees in the forest ;)
Some advantages on having an ERD:
- Provide a preview of how all your tables should connect, what fields are going to be on each table
- Helps to describe entities, attributes, relationships
- ER diagrams can be used by database designers as a blueprint for implementing data in extensions
- ERD allows you to communicate with the logical structure of the database
Comments
I've started making ER diagrams for Navision 4.0. Always thought it is pointless as Microsoft will publish their own versions. It hasn't happened so far.
I've been working on the next version of https://DynamicsDocs.com that generates ERDs for the customized Business Central solution:
https://bcentral.dev
p.s.
The new version generates E/R diagrams for your customized solution.
Category: Development
Regarding this remark:
Business Central Team (administrator)
Thank you for this suggestion! Currently this is not on our roadmap. We are tracking this idea and if it gathers more votes and comments we might consider it in the future.
Best regards,
Business Central Team
How many votes are required for this idea to be added to the roadmap?
Category: Development
Very difficult to use POWER BI without a MAP! Any help here is much appreciated. I am trying to produce Financial Report Suite.
Category: Development
Really good idea! Would help a lot for getting new developers on track :-)
Category: Development
Yes - Advanced customers are also asking for this.
Category: Development
Business Central Team (administrator)
Thank you for this suggestion! Currently this is not on our roadmap. We are tracking this idea and if it gathers more votes and comments we might consider it in the future.
Best regards,
Business Central Team