Skip to main content
SharePoint

Return to Question

Notice removed Draw attention by John John
Bounty Ended with Radityo Ardi's answer chosen by John John
Notice added Draw attention by John John
Bounty Started worth 300 reputation by John John
added 47 characters in body
Source Link
John John
John John
  • 1
  • 49
  • 258
  • 603

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:-

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

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

  3. optionally to pass a Parameter to the Database.

After thanthat 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:-

enter image description here

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

enter image description here

So can we build similar web part using SPFx? If the answer is Yes, then is there an available 3rd party 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.

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:-

  1. Specify a connection string

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

  3. 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:-

enter image description here

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

enter image description here

So can we build similar web part using SPFx? If the answer is Yes, then is there an available 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.

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:-

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

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

  3. optionally to pass a Parameter to the Database.

After that 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:-

enter image description here

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

enter image description here

So can we build similar web part using SPFx? If the answer is Yes, then is there an available 3rd party 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.

Source Link
John John
John John
  • 1
  • 49
  • 258
  • 603

SPFx to connect to local SQL Server Tables,Stored Procedures & view.. Approaches to follow

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:-

  1. Specify a connection string

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

  3. 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:-

enter image description here

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

enter image description here

So can we build similar web part using SPFx? If the answer is Yes, then is there an available 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.