Feb 17 2022 03:41 PM - edited Feb 17 2022 03:44 PM
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.
Feb 24 2022 01:17 AM
You may have alook into PowerBi:
Embed a report web part in SharePoint Online - Power BI | Microsoft Docs
Mar 18 2024 04:51 PM
@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