What is the best way to use SQL on-premise data within SharePoint Online?

Frequent Contributor

We would like to create a solution in SharePoint Online that can perform CRUD operations on data in an on-premise SQL database.


What is the best way to accomplish this?

What are the different options?

Is it possible to do this from a SharePoint Framework web part?



2 Replies

Best way is to create a PowerApp that consume SQL On-Premises data, but this option implies to have a paid Plan of PowerApps since SQL connector is a premium one.

Are there any other options besides PowerApps? Is it possible to create a SharePoint Framework web part that connects to SQL data?