Tue, 05/04/2021 - 16:47 By Vo Sy Lien Thanh

Dataverse export Entity Relation Diagram:

In Dynamics 365, we have many entities with relationships. Sometimes, we need to see the overview of those relationships in a more graphical way. We have some popular ways to archive this:

  • Use medata to generate (Official docs by Microsoft)
    For more information you can go to this article Use metadata to generate entity diagrams
  • Use Entity Relation Diagram Creator tool from XrmToolBox: I will show you how to do it in this article!

Prerequisite: Know how to install XrmToolBox. Or you can go to XrmToolBox - View Designer to see how to use XrmToolBox

Step 1: Install Entity Relation Diagram

Dataverse export Entity Relation Diagram

Step 2: Overview main feature of the tool

Dataverse export Entity Relation Diagram

Step 3: Load solution or load entity

In this tool you can load all entities in the environment or you can just load entity in the solution.

Load entities or load solution

Step 4: Add setting before generate diagram

Dataverse export Entity Relation Diagram

Explain each options:

Field to show

Five options:

  • Custom fields from publisher
  • Custom fields from all publisher
  • All fields
  • Key field only
  • No fields
Show collapsed entities Show entities in collapsed view
Show data types in entities Show fields with data type
Show friendly names in entities Show entity display name (rarely use)
Show fieldname in relationship Show relationship field name
Show name of many-to-many relationship Show relationship name
Show related entities outside solution (Ghosted relationship) If you choose to create a diagram from solution and you need to know the relationship of an entity in solution with the entity outside of currently selected solution
Hide unpublished customizations  

Step 5: Generate entity relation diagram

After click "Create Entity Relation Diagram" button you will get a diagram

Diagram example

Step 6: Save diagram as Image or .ERD file

In this tool, you can export diagram to an .ERD file or an image.

You can click "Save Diagram" or "Save Diagram as" to save as .ERD file

Save option

With this file, you can open it later on using this tool by clicking "Open Diagram" button

Open existing diagram

Or you can also save the diagram as an image to share with other team members by clicking "Take image"

Save as image

Hope this tool will help you!

Dataverse export Entity Relation Diagram

Tags

Add new comment

Image CAPTCHA
Enter the characters shown in the image.