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 ?

All responses (1)

Answers (0)

Suggested answer

Bipin D365 28,964 Super User 2024 Season 1 on at

Like (0)

Report

RE: How to get database tables from Dyanamics 365 ?

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/.../