Using an ERD tool to create CRM entities


I get asked this now and then:

“I want to use Erwin [or Visio or Visual Studio or…] to graphically design the CRM entity model, then have the actual CRM entities generated off of the tool I used to design the entities.”

While I am not aware of a direct way to do this with any ERD tools, there is a multi-step process you can use as long as your ERD designer can generate a SQL or Access database:

  • Use your ERD designer to model your entities, fields and relationships
  • Generate a SQL or Access database from the designer
  • Use https://xrmspeedy.codeplex.com/ to generate the CRM entities from the database

Of course, you’ll need to make sure you don’t pick data types in your diagram that the xrmspeedy tool can’t translate to CRM types, but this approach can be used as a productivity enhancement to those who prefer to diagram out their entities and generated them.  Since this is an open source tool, you might consider contributing feedback if you have ideas for improvement.  After a little trial and error, I’ve found I get value out of using Visual Studio’s Entity Framework Designer plus this tool when brainstorming data models and building POCs.  Your Mileage May Vary (YMMV).

@devkeydet

Comments (2)

  1. Chris says:

    I believe what your talking about can be accomplished with  Toad Data Modeler by Dell Software. software.dell.com/.../toad-data-modeler

    It lets you create a diagram of all your entities map out the relationships and then will generate the DDL and SQL to create the exact model you designed. for MANY different DB's.  Microsoft  SQL, MySQL, Oracle, DB2, PostgreSQL, etc.  It can also reverse engineer databases you may already have so you can examine any issues or find ways to clean it up

  2. Joe says:

    Is there any way to do this work with CA's Erwin DM tool?

Skip to main content