I need an OLTP solution for the deprecation of DES

Late last year MS announced the deprecation of Data export service
https://powerapps.microsoft.com/en-us/blog/do-more-with-data-from-data-export-service-to-azure-synapse-link-for-dataverse/

So far i can’t find an adequate replacement for our usage.

we are using the Azure SQL database for real(ish) time queries that feed a transaction system.  Current DES serves teh following

* under half second response time

* low replication latency even though the official SLA is <15min

* full use of TSQL language

It isn’t uncommon to need to read the data only a few seconds after a write and that has been our experience with DES.

What i have found that replaces DES so far hasn’t met these needs.  I have set up sql serverless over the Synapse data lake.  That works but it is too slow.  The search time on the simplest query is >10secs.  The TSQL language is limited (though i think i can work around that).  There are options to use ADF to pump that into Azure SQL however that would need to run on a trigger (timer).  I wouldn’t get single digit seconds latency I get now using that.

Those are the options as i understand them.  And i don’t see how any of those fills the gap left behind DES deprecation.

This is a production environment and i don’t have an adequate solution only a few months before DES is turned off.

I would very much appreciate ideas on how others have solved this.

thanks,

dan