Synapse serverless pool and D365 F&O - Data Integration

(2) Share

Report

Posted on by CU12092249-0

Hi All.

I am keen to understand the thoughts of others who have mature D365 F&O environments using synapse link, can it be used for transactional near real time integrations. For example find the status of a customer on the database, having other upstream processes on a web application and having to query the data on a serverless SQL pool, I am concerned about the speed and performance especially as the data grows. Is this a scalable solution ?

As the data within the serverless pool is effectively data within a data lake, its not possible to tune the queries by adding indexes etc, would it be sensible idea to include calls to the data via the serverless SQL pool as part of a short lived transaction via a web application.

Thanks in advance.

Categories:

Dynamics 365 Finance

I have the same question (0)

All responses (1)

Answers (0)

Suggested answer

André Arnaud de Cal... 303,667 Super User 2026 Season 1 on at

Like (0)

Report
Copy link

Link copied!

Hi,

I found this question unanswered. In case you are looking for near real time integrations, then the Synapse or Fabric link are not the recommended technologies. It is exporting data for reporting purposes where the minimum value for incremental updates is 5 minutes.

See: Query and analyze the incremental updates with Azure Synapse Link for Dataverse - Power Apps | Microsoft Learn

Can you tell the exact requirement? For what purpose do you need a copy of the data? What is the intention of the web application you mentioned in your question? If you can provide more information, we can try to suggest a recommended approach.

Was this reply helpful? Yes No