Hi ​@oliver.morris,

I’m doing some research on potential development on the Microsoft Fabric front. Would you be able to give me more information on the use cases you have with the Fabric ecosystem? I acknowledge the need to have a connector for MS SQL Database in Fabric. Would there be other important use cases you’d have?

Thank you

​@PierreAtSafe Entra is a requirement to connect to the SQL Database contained within the Fabric platform, it seems increasingly this authentication route is being adopted by microsoft so it would be great to have this authentication mechanism. 

It would be great to have read/write to the Data Lake as well, I know this is more tricky - perhaps via DuckDB?

​@oliver.morris got it for Entra ID! On the authentication front, are you also using Service Principals by any chance?

Regarding the data lake, you mean accessing OneLake in Fabric right?

Hi ​@PierreAtSafe 

• We are currently migrating our reporting and analytics data to Microsoft Fabric, and we would greatly benefit from the ability to read data directly from Fabric in FME (particularly from Lakehouses, but would be beneficial to read from a  SQL Database and Warehouse).

• Support for Entra ID authentication and Service Principals would be particularly useful for automated workflows.

• Having the ability to write directly to a Lakehouse, Warehouse, or SQL Database within Microsoft Fabric would also significantly streamline certain data processes. Currently, we need to write to Azure SQL Database or SQL Server and then mirror it into Fabric if we want to use the data in PBI reports.

On this topic, are there any current options to read Fabric Lakehouse data in FME using the Lakehouse SQL endpoint?

Cheers

Hi ​@ivy_araujo,

We currently support connecting to Microsoft SQL on Fabric using a Microsoft Azure SQL Database (JDBC) connection and the Azure SQL Reader/Writer with the JDBC driver. You can use Entra ID for Authentication but Service Principals are not supported at the moment. We are planning to add support for it.

Note that a defect prevents authentication from being successful on non Windows machines. This will be resolved in FME 2025.2.

We don’t have support for reading Lakehouse / Warehouse data in Fabric for the time being but are actively looking into it.

If you are able to share more use cases or needs you have regarding Fabric integrations / authentication and operating systems support that would be very helpful on our side.

Thank you!