How to get database tables from Dyanamics 365 ?

(0) Share

Report

Posted on by Sabarisri

Hi,

Are there two groups of tables in Dynamics 365 ?

When I connect my Dynamic CRM through Dataedo , I see lot of tables, which have some columns as data type - lookup, picklist . So definitely these are not sql tables.

How come these columns come in, ? Is it because some one, from the front end of Dynamics 365 generated it ? If that is so, why are they not stored as String/Varchar format ?

Where is the actual database residing ?

I have the same question (0)

All responses (1)

Answers (0)

Suggested answer

Bipin D365 28,983 Moderator on at

Like (0)

Report

Hi,

You can setup azure synapses link in Dataverse to copy data to Azure data lake in the form of SQL table

learn.microsoft.com/.../azure-synapse-link-pipelines

You can also enable TDS endpoint to directly query with SQL

learn.microsoft.com/.../dataverse-sql-query

You can also use SQL4CDS plugin in xrmtoolbox

markcarrington.dev/.../

Was this reply helpful? Yes No