This tool is simple to use and gives Sure Step color coded ER diagrams using MS Visio. Here is the tool can be downloaded from CodePlex and below are the steps for using this tool.

Step 1: Once you unzip the solution. The tool can be run by clicking the “XRMERDiagGenerator.exe” file.

ER_1

Step 2: After the tool comes up, you would have to connect it to a CRM organization by clicking “Sign in to CRM”. At this point you would get a pop-up to connect to a MS Dynamics CRM On-premise/ Online environment. This control would be familiar to most of us working with MS Dynamics CRM. Once a connection is made, you would be able to select and connect to your desired Organization.

ER_2

Step 3: You would get a screen as below showing your connection information and suggesting to click the “Get All Entities” button. Now at this time, the tool would be fetching all the entities present in your selected organization so that its easy for you to select your required entity/entities and generate ER Diagrams for them.

Since a Metadata call is a costly operation in CRM, this operation would take sometime approx. 5-10 minutes.

ER_3

Step 4: Once the List of entities are load, you can sort them by clicking the “Entity Schema Name” header. You can select all the entities or undo your selection by clicking the “ Select All” and “Select None” buttons. You can also select one or multiple entities by using the “Ctrl” key while selecting the entity rows.

ER_4

Step 5: Now click “Generate Visio”, to generate the ER Diagram for the selected entity/ entities in MS Visio.

ER_5

The “.vsd” file would be generated in the tool’s directory itself. Here is one sample ER diagram as created in MS Visio by this tool.

 ER_7 ER_6

Pre-requisites for the tool:

1. You should have MS Visio installed in the system where the tool is running. Link for downloading a trial version for downloading MS Visio 2013 is here.

2. You should have .Net Framework 4.5 installed on your system. Although I haven’t checked out my tool on a system that doesn’t have .Net Framework 4.5 installed, but I think it should be there for my tool to run successfully. Link for downloading .Net Framework 4.5

Color coding for the Entities is as follows:

1. If the attribute is a primary key for the entity, then “[PK]” would be appended to the attribute.

2. A Business owned entity would be colored “Orange

3. An Organization owned entity would be colored “Green”.

4. A User/Team owned entity would be colored “Blue

5. If the entity does not fall into any of the above categories then would be colored “White”.

Last edited Jan 15, 2015 at 8:18 AM by bohnnie, version 2