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?
Here's how I would do it:
- 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
- On one of your servers, install and configure an on-premises data gateway. The steps are similar to Step 3 of this article
Deploy your API to Azure. Keep the connection string the same. Azure should resolve the connection string and route traffic through the gateway.
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