Skip to main content

Here’s a question!

Microsoft Dataverse currently hosts our Dynamics 365.  We are trying to create an ERD of the relevant parts of D365 and present it LucidChart (we don’t use all the functions of Dynamics).  There isn’t a standard database connector for Microsoft Dataverse, so the only way we can currently see of building our ERD and keeping it updated is manually.  Does anyone know of an alternative way of doing this? 

Someone has suggested we can get the entities into Excel and then into Lucid, but this seems a rather long-winded & manual approach.

Guidance gratefully accepted.

 

@Kevin Plunkett I believe this thread will give you the answers you are seeking: 

It does seem that the solutions are manually-oriented but that there is more than one option.


Thank you but this goes nowhere near to answer the question I’ve asked.  Dynamics if the Microsoft CRM, Financial & ERP platform and having the ability to be able to understand the ERD that supports this would be massively useful.  


Hi @Kevin Plunkett

Thanks for following up! A workaround alternative to manually building your ERD is to format your data as a PostgreSQL, using the attached document for reference. If you can export your data from Microsoft Dataverse in the attached format, you can then upload your data as shown below.

  1. From a Lucidchart board, select File > Import > Data > Entity relationship (ERD) > Import from SQL Database
  1. Select PostgreSQL > Next > and follow the prompts to upload your files

 

I hope that is helpful! Please let me know if you have any further questions! I would be happy to help find another solution for you.


Reply