Integrate Synapse Warehouse to a web frontend

[justmehere]

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?

[Anonymous · Accepted solution]

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 Learn

Best Regards,
Yang
Community Support Team

If 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]

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