Converting JSON schema to ER Diagrams about cdm HOT 7 CLOSED

Having an Entity Relationship diagram will certainly help new developers to understand such important concept of CDM. This will be very use for us too. Do let us know on how to get ER diagram in any tools.

from cdm.

Thanks for reaching out - we don't have any tools available today to convert CDM entity schema JSONs to an ER diagram. Our advice for you is to perform resolve operation on all the entities which will remove any nesting/referencing that currently exists in the logical schema (example of entity resolving can be found in the SDK samples). Once this is done, you can code a new utility that will turn the resolved schema into Excel workbooks and then import that into an ER tool.

from cdm.

This would be really usefull, some updates?

from cdm.

How do we get proper training on Microsoft CDM operations/projections? Is there any community to discuss or clarify doubts for our young developers?

from cdm.

What is the difference between "Entities" and "Tables" under OperationsCommon?

I understand that Entities is conceptual and that Tables are Physical but can you still use both cstegories as a standard Data Model?

from cdm.

As I can see, the relations are not visible within the "Operations" area in CDM inside https://microsoft.github.io/CDM/SchemaViz.html.

Is that correct or am I missing something?

from cdm.

What is the difference between "Entities" and "Tables" under OperationsCommon?

I understand that Entities is conceptual and that Tables are Physical but can you still use both cstegories as a standard Data Model?

In Finance and Operations there is a difference between a Table (which is pretty close to 1:1 with a SQL table) and an Entity (which behind the scenes is a SQL view that wraps one or more tables, or even other entities and views).

from cdm.