SOLVED

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

%3CLINGO-SUB%20id%3D%22lingo-sub-1245394%22%20slang%3D%22en-US%22%3EHow%20to%20call%20local%20Oracle%20database%20(%20on-premise)%20from%20PowerApps%2FSharePoint%20Online%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-1245394%22%20slang%3D%22en-US%22%3E%3CP%20class%3D%22x-hidden-focus%22%3Ewe%20have%26nbsp%3B%3CSPAN%20class%3D%22x-hidden-focus%22%3ESharePoint%202010%20Foundation%20customized%20web%20parts%20build%20to%20retrieve%20data%20from%20on%20premises%20Oracle%20and%20SQL%20database.%20Since%20SharePoint%202010%20will%20expired%20soon%2C%20we%20want%20to%20replace%20it%20by%20SharePoint%20Online%20for%20Office%20365%20and%20maintain%20function%20of%20retrieving%20data%20from%26nbsp%3B%3C%2FSPAN%3E%3CSPAN%3Eon%20premises%20Oracle%20and%20SQL%20database%3C%2FSPAN%3E%3CSPAN%3E.%20I%20am%20planning%20options%20for%20this%20replacement%3A%26nbsp%3B%26nbsp%3B%3C%2FSPAN%3E%3C%2FP%3E%3CP%3E%3CSPAN%20class%3D%22x-hidden-focus%22%3EPowerApps%20call%20Azure%20Web%20App%20API%2C%20Azure%20web%20App%20do%20Hybrid%20connection%20with%20the%20database%20(daily%20update)%3B%20or%26nbsp%3B%3C%2FSPAN%3E%3CSPAN%3EAzure%20Web%20App%20API%20call%20SQL%20and%20Oracle%20web%20service%2C%20return%20OData%20collection.%3C%2FSPAN%3E%3C%2FP%3E%3CP%3EAt%20same%20time%2C%20I%20also%20think%20an%20option%20of%20S%3CSPAN%3EharePoint%20Online%20list%20using%20BCS%2C%20WCF%20to%20get%20external%20list%2C%20external%20content%20type%20return%20to%20SharePoint%20Online%20as%20SharePoint%20lists%20to%20get%20the%20on-premise%20data.%3C%2FSPAN%3E%3C%2FP%3E%3CP%3E%3CSPAN%3EI%20am%20not%20sure%20which%20one%20is%20more%20applicable%3F%20Thanks%20for%20any%20suggestion.%3C%2FSPAN%3E%3C%2FP%3E%3CP%3E%3CSPAN%3EJeung%3C%2FSPAN%3E%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-LABS%20id%3D%22lingo-labs-1245394%22%20slang%3D%22en-US%22%3E%3CLINGO-LABEL%3EMicrosoft%20Flow%3C%2FLINGO-LABEL%3E%3CLINGO-LABEL%3EPowerApps%3C%2FLINGO-LABEL%3E%3CLINGO-LABEL%3ESharePoint%3C%2FLINGO-LABEL%3E%3C%2FLINGO-LABS%3E%3CLINGO-SUB%20id%3D%22lingo-sub-1245427%22%20slang%3D%22en-US%22%3ERe%3A%20How%20to%20call%20local%20Oracle%20database%20(%20on-premise)%20from%20PowerApps%2FSharePoint%20Online%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-1245427%22%20slang%3D%22en-US%22%3EMy%20two%20cents%3A%3CBR%20%2F%3E(1)%20Don't%20waste%20time%20with%20BCS%3CBR%20%2F%3E(2)%20Go%20for%20the%20Power%20Apps%20option%20you%20have%20described%20or%3CBR%20%2F%3E(3)%20SPFx%20%2B%20Secure%20API%20you%20can%20call%20from%20SPFx%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-1245577%22%20slang%3D%22en-US%22%3ERe%3A%20How%20to%20call%20local%20Oracle%20database%20(%20on-premise)%20from%20PowerApps%2FSharePoint%20Online%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-1245577%22%20slang%3D%22en-US%22%3E%3CP%3E%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F60%22%20target%3D%22_blank%22%3E%40Juan%20Carlos%20Gonz%C3%A1lez%20Mart%C3%ADn%3C%2FA%3E%26nbsp%3B%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EThank%20you%2C%20Juan.%26nbsp%3B%20Just%20wondering%20why%26nbsp%3B%3CSPAN%3EBCS%20not%20working%3F%3C%2FSPAN%3E%26nbsp%3B%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-1245860%22%20slang%3D%22en-US%22%3ERe%3A%20How%20to%20call%20local%20Oracle%20database%20(%20on-premise)%20from%20PowerApps%2FSharePoint%20Online%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-1245860%22%20slang%3D%22en-US%22%3EDidn't%20say%20it's%20not%20working...the%20fact%20is%20that%20Microsoft%20has%20not%20done%20any%20investment%20in%20BCS%20for%20years%3C%2FLINGO-BODY%3E
New Contributor

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

3 Replies
My two cents:
(1) Don't waste time with BCS
(2) Go for the Power Apps option you have described or
(3) SPFx + Secure API you can call from SPFx

@Juan Carlos González Martín 

 

Thank you, Juan.  Just wondering why BCS not working? 

best response confirmed by Leung1975 (New Contributor)
Solution
Didn't say it's not working...the fact is that Microsoft has not done any investment in BCS for years