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

%3CLINGO-SUB%20id%3D%22lingo-sub-2341126%22%20slang%3D%22en-US%22%3ERe%3A%20What%20is%20the%20best%20way%20to%20use%20SQL%20on-premise%20data%20within%20SharePoint%20Online%3F%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-2341126%22%20slang%3D%22en-US%22%3E%3CP%3EBest%20way%20is%20to%20create%20a%20PowerApp%20that%20consume%20SQL%20On-Premises%20data%2C%20but%20this%20option%20implies%20to%20have%20a%20paid%20Plan%20of%20PowerApps%20since%20SQL%20connector%20is%20a%20premium%20one.%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-2340710%22%20slang%3D%22en-US%22%3EWhat%20is%20the%20best%20way%20to%20use%20SQL%20on-premise%20data%20within%20SharePoint%20Online%3F%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-2340710%22%20slang%3D%22en-US%22%3E%3CP%3EWe%20would%20like%20to%20create%20a%20solution%20in%20SharePoint%20Online%20that%20can%20perform%20CRUD%20operations%20on%20data%20in%20an%20on-premise%20SQL%20database.%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EWhat%20is%20the%20best%20way%20to%20accomplish%20this%3F%3C%2FP%3E%3CP%3EWhat%20are%20the%20different%20options%3F%3C%2FP%3E%3CP%3EIs%20it%20possible%20to%20do%20this%20from%20a%20SharePoint%20Framework%20web%20part%3F%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-LABS%20id%3D%22lingo-labs-2340710%22%20slang%3D%22en-US%22%3E%3CLINGO-LABEL%3ESharePoint%20Online%3C%2FLINGO-LABEL%3E%3CLINGO-LABEL%3ESQL%3C%2FLINGO-LABEL%3E%3CLINGO-LABEL%3Eweb%20part%3C%2FLINGO-LABEL%3E%3C%2FLINGO-LABS%3E%3CLINGO-SUB%20id%3D%22lingo-sub-2344637%22%20slang%3D%22en-US%22%3ERe%3A%20What%20is%20the%20best%20way%20to%20use%20SQL%20on-premise%20data%20within%20SharePoint%20Online%3F%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-2344637%22%20slang%3D%22en-US%22%3EAre%20there%20any%20other%20options%20besides%20PowerApps%3F%20Is%20it%20possible%20to%20create%20a%20SharePoint%20Framework%20web%20part%20that%20connects%20to%20SQL%20data%3F%3C%2FLINGO-BODY%3E
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?