I have a requirement like , have to pull on-premises SQL server data in to SharePoint online page using spfx without importing into the SP list?

1 Answer 1


Here's how I would do it:

  1. Create an authenticated API (I would use a .NET API project), making sure to use keep the connection strings in the project configuration (web.config/settings .json) -- see Part I of this article
  2. On one of your servers, install and configure an on-premises data gateway. The steps are similar to Step 3 of this article
  3. Deploy your API to Azure. Keep the connection string the same. Azure should resolve the connection string and route traffic through the gateway.

  4. Create a web part that calls the authenticated API to query the data.

It is a very over-simplified list of steps, but it should get you started.

Let me know if you need more detailed instructions.

  • Hi Hugo Can you provide some detailed steps or article regarding this? Jun 4, 2020 at 17:09
  • @Parthasarathy I'll write an article and update this discussion with the link. Jun 5, 2020 at 17:36

Your Answer

By clicking “Post Your Answer”, you agree to our terms of service and acknowledge you have read our privacy policy.

Not the answer you're looking for? Browse other questions tagged or ask your own question.