Forum Discussion

john john's avatar
john john
Iron Contributor
Feb 17, 2022

Connect to local SQL Server Tables,Stored Procedures & view, then show the result inside SPFx

I am working on a migration from SharePoint 2010 to SharePoint Online. Where inside the on-premises the customer has a configurable Web Part (Server-side of course), which allow users to do the following:-

  • Specify a connection string to connect to SQL server on-premises.

  • Specify the Table or Stored Procedure or View to connect with.

  • optionally to pass a Parameter to the Database.

After than the web part will show the results from the database and allow the users to filter the data which will be shown in a tabular format.

Here is a screenshot of the web part setting:-

 

 

Here is a screenshot of a result from one web part instance:-

 

 

So can we build similar web part using SPFx? If the answer is Yes, then is there any available 3rd party SPFx web part we can benefit from? Finally , i am also open to other approaches to achieve our work other than build/using SPFx web part.

 

Thanks in advance for any help.

2 Replies

  • tmarsny's avatar
    tmarsny
    Copper Contributor

    john john RE: your posting here, we want to do the EXACT same thing. (Miss SP 2010--only for this reason.)  We tried Power BI as one user suggested, but then we have to have PowerBI licenses for users or we had issues.

     

    Did you ever find a suitable solution? 


    TMS

  • Thomas Leclaire's avatar
    Thomas Leclaire
    Copper Contributor

    john john 

    You may have alook into PowerBi:

    https://docs.microsoft.com/en-us/power-bi/collaborate-share/service-embed-report-spo

Resources