ERD Generator for Dynamics CRM 2011/2013

deepeshsomani2013 Microsoft Dynamics CRM

ERD Generator for Dynamics CRM 2011/2013 is a Windows Form application that is can be used for Dynamics CRM 2011 or Dynamics CRM 2013:

ERDGenerator

For CRM 2015, Use following link: https://dynamicsofdynamicscrm.wordpress.com/2015/04/16/new-versionerd-generator-tool-for-crm-2015/

Here is a video to see how this will work:

Just download the above .doc file and rename it to .zip and run the tool.

This tool allows you to build ERD (Entity relationship diagrams) that are dynamically updated based on the published CRM entities and Fields. You can pick a source entity and build ERD around it. It generate a VISIO output but also lets you pick CSV to document Entity relationships.

It generates a CSV having details like:

image

It generates ERD in VISIO:

image

Visio legend below:

image

Hope it helps!


Check this out

53 thoughts on “ERD Generator for Dynamics CRM 2011/2013”

  2. Hi Deepesh

    Great tool. Thanks.
    Could you please add the source code to CodePlex. Otherwise you are breaking their terms of use!
    If you do not want to share the source code, that’s fine, just please remove the project from CodePlex.

    Thanks
    Massimo

    Reply

  5. Hi Deepesh,
    I am able to install and connect to the CRM server ,however the tool keeps returning a blank visio file whenever I generate an ERD.Is there something I am not doing correctly?

    Reply

  6. HI Deepesh, great work done….it would be truly usable stuff for generating ERD without any effort….Keep up the great work…..

    Reply

  7. Hi Dipesh,

    It seems a good stuff you did. i was able to download and unzip the application, i tested by connecting to CRM and selecting “Lead” entity, however it says “operation completed” but when i go to see folder which i selected to store generated diagram, it shows nothing, i tried several times but same result. Any idea why it should have happened ?

    Regards,
    Hiren

    Reply

    • Application: ERDGenerator.exe Framework Version: v4.0.30319 Description: The process was terminated due to an unhandled exception. Exception Info: System.IO.FileLoadException Stack: at TeamAllocator_New.UserCloner..ctor() at TeamAllocator_New.Program.Main() error generated in event log

      Reply

      • Hello Deepesh,

        Above, I have added error details. Kindly let me know if I am missing any environment setup or any library based on the error details.

        I think I am almost done and missing some settings.

        Your help will really make my day.

        Thanks in advance
        Kedar

  12. Great tool. Some entities are not showing e.g.: Service. It exists in the database as I can see it both with SQL Server management Studio, and CRM console (Settings -> Customisation -> Customise the System -> Entities

    Reply

  17. Thanks Deepseh, really appreciate your time and efforts for this wonderful tool.
    I have used it for CRM 2011 worked like a charm

    Reply

  19. Hello,

    I know this is an old post but I am hoping it is still being monitored. Does the ERD generator create a model of the tables being used or is it base on what entity you select? I am trying to create an ERD model of the entities that are actually being used by the users in the legacy system before we migrate to Dynamics 365.

    I created one using ERWIN but there are over 300 tables and I am not sure if all are really being used. I excluded the ones I noted rowcount = 0 but I would like to go further or separate model into subject areas if possible in an easier and quicker fashion.

    Reply

      • I was thinking to divide entities based on subject area. I am not sure if all 300 are published. I indicated over 300 because I was going by the row count >0 to see what to include in the ERWIN model. It maybe different using the generator within CRM. I was hoping for alternatives.

        Thanks

  20. Hi Deepesh,

    Thanks for the tool, I am trying to generate entity relationship for my crm 2011 app. Unfortunately i am getting an error when trying to connect. Hoping you could help.

    Error while retrieving organizations: The remote name cound not be resolved: ‘https’
    The remote name could not be resolved: ‘https’
    Metadata contains a reference that cannot be resolved:
    ‘https//myserver/server port#/XRMServices/2011/Discovery.svc?wsdl’.

    Thanks,
    Kenny

    Reply

  22. Deepesh – I’m trying to document an old 2011 system. Using your 2011/2013 tool, it appears to run to completion without error, but there is no output when it finishes. I tried running it on a Win7 system with Office and VS 2010, and on a WIn10 system with Office and VS 2017, and I had the same results on both. Any suggestions?

    thanks,
    Geoff

    Reply

Leave a reply to deepeshsomani2013 Cancel reply