Microsoft Dynamics CRM

ERD Generator for Dynamics CRM 2011/2013

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
Advertisements

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

  1. 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

  2. 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?

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

  4. 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

      1. Nice tool to have but whenever I generate it .. it gives operation completed message but nothing is generated in destination folder. I am using Dynamic CRM online (2013)

    1. 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

      1. 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

      1. Thanks for the reply Deepesh,

        I have tried with the same version but no luck. It still doesn’t generate the document. Also no error found in the EventLog.

        Not sure what I am doing wrong.

        Regards,
        Kedar

      2. Don’t know what I may be missing either, but am having the same problem. REALLY hoping to get this figured out! Could be a phenomenal tool! Using v2015 online.

      3. Thanks for being so responsive! Could you perhaps just run through the process with a screen record? For some reason, I am able to get it to run with the previous file, but not this one. Hard to imagine I’m missing something since I was able to execute successfully using previous file.

  5. 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

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

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 )

Twitter picture

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

Facebook photo

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

Google+ photo

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

Connecting to %s