web

You’re offline. This is a read only version of the page.

News and Announcements icon

Dynamics 365 CommunityForums Customer experience | Sales, Customer Insights,... How to get database ta...

Customer experience | Sales, Customer Insights,...

Suggested Answer

How to get database tables from Dyanamics 365 ?

(0) Share

Report

Report

Posted on by Sabarisri

5

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 Img

All responses (1)

Answers Img

Answers (0)

Suggested answer

Bipin D365 28,985 Moderator on at

Like (0)

Report
Copy link

Link copied!

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

Join the conversation

Helpful resources

Quick Links

Subscribe to this forum!

Stay up to date on forum activity by subscribing.

Leaderboard > Customer experience | Sales, Customer Insights, CRM

#1

ManoVerse 98 Super User 2026 Season 1

#2

#3

Muhammad Shahzad Sh... 69 Most Valuable Professional

Last 30 days Overall leaderboard

Featured topics

Hide selecting Contact for potential customer when creating quote

Product updates

Dynamics 365 release plans