D365FO Entity Relationship Diagrams (ERD)

Visualizing the D365FO data model can be a challenge. The platform supports table inheritance and the relationships between each table are defined by metadata and not immediately accessible by CASE tools via the database.

With the help of dbdiagram.io, the Database Markup Language (DBML) and the Generate Entity Relation Schema extension for Visual Studio, we can interrogate and transform the metamodel into a visual representation of our entity relationships.

For example, the core tables from the Global Address Book (GAB) are related as follows:

To generate the diagram, we first need to generate a DBML schema that describes the entities and their relations by opening the Addin from the main Dynamics 365:

Or from the table designer:

You can select specific tables to include in the schema or automatically include tables that have outward or inward relations to/from the selected table:

Once the tables and options are selected, we just need to Generate DBML and copy it over to dbdiagram.io.

You can get the Visual Studio extension from github.

Pull Requests welcome!

Leave a Reply

Fill in your details below or click an icon to log in:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out /  Change )

Google photo

You are commenting using your Google account. Log Out /  Change )

Twitter picture

You are commenting using your Twitter account. Log Out /  Change )

Facebook photo

You are commenting using your Facebook account. Log Out /  Change )

Connecting to %s

Create a website or blog at WordPress.com

Up ↑

%d bloggers like this: