topic Integrate Synapse Warehouse to a web frontend in Data Warehouse

Integrate Synapse Warehouse to a web frontend

justmehere — Wed, 23 Oct 2024 02:25:45 GMT

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?

Re: Integrate Synapse Warehouse to a web frontend

Anonymous — Wed, 23 Oct 2024 08:51:07 GMT

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

Re: Integrate Synapse Warehouse to a web frontend

AndyDDC — Sat, 26 Oct 2024 09:13:43 GMT

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