web

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

News and Announcements icon

Dynamics 365 CommunityForums Supply chain | Supply Chain Management, Commerce Can "SQL Data Syn...

Supply chain | Supply Chain Management, Commerce

Unanswered

Can "SQL Data Sync for Azure" be used to pull D365 data to an On Prem MS SQL database?

(0) Share

Report

Report

Posted on by samalex1701

262

I'm needing some way to pull our data from D365 online into an on prem SQL Server and in as real time as possible. I've started building an SSIS process to use CozyRoc and the Change Token on entities where this is enabled, but this isn't ideal as not all tables can be setup with this option, and it relies on a delayed ETL process. Is there some means to automatically replicate this data down? And what about pushing data back up where it would be imported using a supported means as to follow the D365 rules, plugins, and such?

Thanks for any guidance.

I have the same question (0)

All responses Img

All responses (0)

Answers Img

Answers (0)

Join the conversation

Helpful resources

Quick Links

Leaderboard > Supply chain | Supply Chain Management, Commerce

#1

Mallesh Deshapaga 1,072

#2

Laurens vd Tang 227 Super User 2026 Season 1

#3

SoumitraforD365 130

Last 30 days Overall leaderboard

Featured topics

Quality order uses default receipt location instead of actual physical receipt location

Product updates

Dynamics 365 release plans