Timeline for SPFx to connect to local SQL Server Tables,Stored Procedures & view.. Approaches to follow
Current License: CC BY-SA 4.0
7 events
| when toggle format | what | by | license | comment | |
|---|---|---|---|---|---|
| Feb 21, 2022 at 15:59 | comment | added | Callum Crowley | I have added a further edit to my answer but essentially, you're going to have to fetch these details from SQL Server using an Azure function or web app. You can then use SPFx to call the API you have created to display the details in the property pane. | |
| Feb 21, 2022 at 15:58 | history | edited | Callum Crowley | CC BY-SA 4.0 |
further edit to answer comment
|
| Feb 21, 2022 at 14:30 | comment | added | John John | i know how to create a configurable SPFx... but my question is about having an SPFx that can show info from databases similar to the on-prem one | |
| Feb 21, 2022 at 13:09 | comment | added | Callum Crowley | I have updated my answer with an article which describes how you would make your web part configurable once you have developed the intermediary which will interact with SQL Server e.g. a web API. | |
| Feb 21, 2022 at 13:07 | history | edited | Callum Crowley | CC BY-SA 4.0 |
updated answer after comment
|
| Feb 21, 2022 at 11:03 | comment | added | John John | I am already aware that i can create API for the DB and connect SharePoint to On-prem DB using gateways.. but my main question is; how we can develop a dynamic web part (similar to the current on-prem web part), which allow us to show & filter data from on-prem database's Tables,Views & Stored procedure, but just specify which component (table,view or Stored Procedure) we want to show the data from .. Is there a documentation to create such SPFx web part? or if there are 3rd part SPFx web part that we can benefit from? Thanks – | |
| Feb 20, 2022 at 16:37 | history | answered | Callum Crowley | CC BY-SA 4.0 |