web
You’re offline. This is a read only version of the page.
close
Skip to main content
Community site session details

Community site session details

Session Id :
Microsoft Dynamics 365 | Integration, Dataverse...
Unanswered

Creating a dedicated SQL pool and keeping the data in synch with the synapse link tables for F&O

(0) ShareShare
ReportReport
Posted on by 12
Hi All.
 
I have been able to setup synapse link to get data from Dynamics F&O into a datalake and query via the serverless SQL pool, I have got some features that I will like to use which are only possible with a dedicated SQL pool. My question is this, how can one create a way to keep the data in synch with the datalake that synapse link ports across.
 
Can the pipelines be flexible such that tables can be added & removed, what triggers the data synch or is it just a timed synch, how does it deal with delta and data changes ?
 
Thanks in advance.
Categories:
I have the same question (0)

Under review

Thank you for your reply! To ensure a great experience for everyone, your content is awaiting approval by our Community Managers. Please check back later.

Helpful resources

Quick Links

Responsible AI policies

As AI tools become more common, we’re introducing a Responsible AI Use…

Abhilash Warrier – Community Spotlight

We are honored to recognize Abhilash Warrier as our Community Spotlight honoree for…

Leaderboard > Microsoft Dynamics 365 | Integration, Dataverse, and general topics

#1
Sahan Hasitha Profile Picture

Sahan Hasitha 394

#2
André Arnaud de Calavon Profile Picture

André Arnaud de Cal... 124 Super User 2025 Season 2

#3
Nimsara Jayathilaka. Profile Picture

Nimsara Jayathilaka. 123

Last 30 days Overall leaderboard

Product updates

Dynamics 365 release plans