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.
12
Share
Report
All responses (
Answers (
