News and Announcements icon

Dynamics 365 CommunityForums Service | Customer Service, Contact Center, Fie... Linked Servers / Repli...

Service | Customer Service, Contact Center, Fie...

Suggested answer

Linked Servers / Replication with Microsoft Dataverse and TDE

(0) Share

Report

Report

Posted on by graflunds

I have been successfully connecting to Dynamics 365 Dataverse data using SQL Management Studio as well as ADO.NET connectors in SSIS.

I would LOVE it if i could setup a linked server here.. has anybody done this yet or do they know how too?

I would also LOVE if we can setup replication to a local SQL Server now instead of using Kingswaysoft packages for this. Is this possible yet?

All responses Img

All responses (2)

Answers Img

Answers (0)

AriaConsulting 2 on at

Like (0)

Report

RE: Linked Servers / Replication with Microsoft Dataverse and TDE

Great link Prateek! Hey, I'm not familiar with a vendor mentioned in that blog post: Skyvia. Do you have any experience with them?
Suggested answer

prt33k 6,907 on at

Like (0)

Report

RE: Linked Servers / Replication with Microsoft Dataverse and TDE

Hi,

No you cannot setup a linked server - TDS just gives you read only access to one database.

Replication is possible using azure data factory - the other possible ways are mentioned here :

nishantrana.me/.../

PS

Helpful resources

News and Announcements

Now Available: 2025 Release Wave 2

Quick Links

Leaderboard > Service | Customer Service, Contact Center, Field Service, Guides

#1

Muhammad Shahzad Sh... 51 Most Valuable Professional

#2

Ramesh Kumar 42

#3

David Shaw_UK 27

Last month Overall leaderboard

Featured topics

Product updates

Dynamics 365 release plans