question

Leung20-5533 avatar image
0 Votes"
Leung20-5533 asked ·

How to call local Oracle database ( on-premise) from SharePoint Online

we have SharePoint 2010 Foundation customized web parts build to retrieve data from on premises Oracle and SQL database. Since SharePoint 2010 will expired soon, we want to replace it by SharePoint Online for Office 365 and maintain function of retrieving data from on premises Oracle and SQL database. I am planning options for this replacement:

PowerApps call Azure Web App API, Azure web App do Hybrid connection with the database (daily update); or Azure Web App API call SQL and Oracle web service, return OData collection.

At same time, I also think an option of SharePoint Online list using BCS, WCF to get external list, external content type return to SharePoint Online as SharePoint lists to get the on-premise data.

I am not sure which one is more applicable? Thanks for any suggestion.

Jeung

azure-webapps
10 |1000 characters needed characters left characters exceeded

Up to 10 attachments (including images) can be used with a maximum of 3.0 MiB each and 30.0 MiB total.

1 Answer

BryanTrachMSFT avatar image
0 Votes"
BryanTrachMSFT answered ·

Hi @Leung20-5533, I mainly work with Azure Web Apps so my reply is slightly biased. I would suggest you post your question to the SharePoint community forum as well to receive a well rounded answer.

In regards to web apps, yes either approach that you listed is possible and I've seen customers successfully implement either approach. If you want to avoid the overhead of managing a web app, it might be possible to accomplish this on an Azure Function, which is essentially a server-less web app.


· Share
10 |1000 characters needed characters left characters exceeded

Up to 10 attachments (including images) can be used with a maximum of 3.0 MiB each and 30.0 MiB total.