Microsoft Dynamics 365 | Integration, Dataverse...

Reverse Engineer the Schema of Dynamics 365

(0) Share

Report

Posted on by ghdunn

235

Hi,

Maybe a bit left field, but does anyone know if there are any tools for 'reverse engineering' the schema of a Dynamics 365 environment? This is possible with many DBMS databases, but i wondered if anyone had done this with D365.

I would like to visually represent the schema in a refreshable way.

Thanks

Gerald

I have the same question (0)

All responses (2)

Answers (0)

Suggested answer

Stefan Cojocaru on at

Like (0)

Report

Hi there,

You can now connect to your Dynamics 365 instance using SQL Server to query CDS data using T-SQL. This feature is in preview for now and it only provides read access but it should be ok for just visualizing the table structure.

https://docs.microsoft.com/en-us/powerapps/developer/common-data-service/cds-sql-query

Other than that, you could use an on-premise installation of Dynamics 365 and check how the database looks like.

However, please note that any changes to the tables and direct insertion of records without using the UI or the APIs is unsupported and could cause serious damage in the long run.

Thank you!

Was this reply helpful? Yes No
Suggested answer

Pankaj Gogoi 3,177 on at

Like (0)

Report

Hi Gerald,

I would recommend the XRM Toolbox Metadata Document Generator. You can also query the metadata using webapi

https://docs.microsoft.com/en-us/dynamics365/customerengagement/on-premises/developer/overview

https://docs.microsoft.com/en-us/dynamics365/customerengagement/on-premises/developer/schemas-used-dynamics-365

Hope this helps

Best Regards

PG

Was this reply helpful? Yes No