Forum Discussion
Integrate Synapse Warehouse to a web frontend
Hi, we have tables in the Synapse Warehouse experience in Microsoft fabric, we would like to connect a Next.js Web frontend to the specific tables in the warehouse and be able to perform operations on the columns of the tables? Is that possible? How would u go about this?
Hi, justmehere
The official documentation states that any non-Microsoft tool can also use the SQL connection string via ODBC or OLE DB drivers to connect to a Microsoft Fabric Warehouse or SQL analytics endpoint, using Microsoft Entra ID (formerly Azure Active Directory) authentication.
Connectivity to data warehousing - Microsoft Fabric | Microsoft LearnBest Regards,
Yang
Community Support TeamIf there is any post helps, then please consider Accept it as the solution to help the other members find it more quickly.
If I misunderstand your needs or you still have problems on it, please feel free to let us know. Thanks a lot!How to get your questions answered quickly -- How to provide sample data in the Power BI Forum
2 Replies
Hi, justmehere
The official documentation states that any non-Microsoft tool can also use the SQL connection string via ODBC or OLE DB drivers to connect to a Microsoft Fabric Warehouse or SQL analytics endpoint, using Microsoft Entra ID (formerly Azure Active Directory) authentication.
Connectivity to data warehousing - Microsoft Fabric | Microsoft LearnBest Regards,
Yang
Community Support TeamIf there is any post helps, then please consider Accept it as the solution to help the other members find it more quickly.
If I misunderstand your needs or you still have problems on it, please feel free to let us know. Thanks a lot!How to get your questions answered quickly -- How to provide sample data in the Power BI Forum
- AndyDDC
Most Valuable Professional
Hi justmehere I'd advise to look at GraphQL. This creates an abstraction layer between a Fabric Warehouse and an application
https://learn.microsoft.com/en-us/fabric/data-engineering/api-graphql-overview
