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
Yes - this is long overdue. Customers complain about the marketed ease of use pf Power BI and then the reality in using it with products like Business Central. Suggestion is to transfer marketing budget to product development with the goal of allowing them some semblance of the marketing presentation. Good place to start is ER-diagrams.
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