Connecting data provider to Microsoft Fabric

Hi all, we are interested in creating a data provider that would point to an Azure SQL database living in Microsoft Fabric. The challenge here is that Fabric supports Entra ID users, service principals, and groups only. SQL or Windows authentication aren’t supported.

It doesn’t appear that the built in SQL data provider driver, as of 25R1, supports Entra ID authentication.  

We’ve come up with a couple of ideas but would be very interested to hear if anyone has been able to establish this kind of integration successfully.

Our thoughts:

• Find a middleware driver that would support Entra ID authentication through Acumatica.  Potentially CDATA?
• Access fabric data through a linked server query to a SQL Managed Instance in Azure
• Replicate the fabric data to a regular Azure SQL Database

Thoughts welcome.  Thank you!