Forum Discussion
Solved
Client side web parts accessing external data
I have seen the CRUD exmple to accss data within SharePoint. https://dev.office.com/patterns-and-practices-detail/11246 I'm looking for an example that accesses an OData service that gets it ...
- I think that for this scenario is where the Add-in model still fits well.
Another option could be to build an Azure AD App securing a custom WebAPI. That web API can get data from your on premises infrastructure using an encrypted connection string and even with a specific connection between your Azure website and the On-Prem SQL Server (kind of this article: https://docs.microsoft.com/en-us/azure/app-service-web/web-sites-hybrid-connection-connect-on-premises-sql-server).
This spfx sample is calling an Azure AD secured custom WebAPI from spfx:
https://github.com/SharePoint/sp-dev-fx-webparts/tree/master/samples/react-aad-webapi
Hi JaredMatfess,
This is Office 365. Initially we were going down the route of BCS however this doesn't perform at all. It takes about 20 seconds for a query when tables exceed 15 columns.
Got it Pieter Veenstra, then yeah you're probably going to need to explore what Luis Mañez recommended with the Azure Hybrid Connections. Takes a bit more setup work, but it should do the job.
Here's a good https://docs.microsoft.com/en-us/azure/biztalk-services/integration-hybrid-connection-overview.