Skip to main content
Open

SQL database in Microsoft Fabric - Entra Authentication

Related products:Integrations
uncle_mole
danilo_fme
oliver.morris
raghavendrans
  • uncle_mole
    uncle_mole
  • danilo_fme
    danilo_fme
  • oliver.morris
    oliver.morris
  • raghavendrans
    raghavendrans

oliver.morris
Contributor

SQL database in Microsoft Fabric is now in preview, we would like to be able to read/write to it with FME. Only Microsoft Entra Auth is supported - https://learn.microsoft.com/en-us/fabric/database/sql/connect

Please can the sql server readers/writers be updated to support this type of authentication. 

4 replies

PierreAtSafe
Safer
Forum|alt.badge.img+1
NewOpen

PierreAtSafe
Safer
Forum|alt.badge.img+1

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


oliver.morris
Contributor
Forum|alt.badge.img+12
  • Author
  • Contributor
  • June 11, 2025

@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?


PierreAtSafe
Safer
Forum|alt.badge.img+1

@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?


Cookie policy

We use cookies to enhance and personalize your experience. If you accept you agree to our full cookie policy. Learn more about our cookies.

 
Cookie settings