Sharepoint- read/write from Oracle Database table

%3CLINGO-SUB%20id%3D%22lingo-sub-1166929%22%20slang%3D%22en-US%22%3ESharepoint-%20read%2Fwrite%20from%20Oracle%20Database%20table%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-1166929%22%20slang%3D%22en-US%22%3E%3CP%3EHi%20All%2C%3C%2FP%3E%3CP%3EI'm%20new%20to%20SharePoint%20but%20with%20some%20good%20knowledge%20of%20basics.%20(Currently%20on%20SP365)%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EI%20have%20a%20requirement%20to%20build%20a%20%3CSTRONG%3Eweb%20form%20in%20SharePoint%3C%2FSTRONG%3E%20which%20will%20%3CSTRONG%3Eread%20and%20write%3C%2FSTRONG%3E%20into%20an%20Oracle%20Database%20table.%20I%20understand%20that%20this%20could%20be%20a%20bit%20complicated.%26nbsp%3B%3C%2FP%3E%3CP%3ENot%20sure%20where%20to%20start%20for%20this%20particular%20ask.%20I've%20tried%20checking%20a%20lot%20of%20online%20resources%20but%20couldn't%20find%20any.%26nbsp%3B%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EAppreciate%20your%20help%20%3A)%3C%2Fimg%3E%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EBest%20Regards%2C%3C%2FP%3E%3CP%3EAbhi%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-LABS%20id%3D%22lingo-labs-1166929%22%20slang%3D%22en-US%22%3E%3CLINGO-LABEL%3EDeveloper%3C%2FLINGO-LABEL%3E%3CLINGO-LABEL%3ESharePoint%20Online%3C%2FLINGO-LABEL%3E%3C%2FLINGO-LABS%3E%3CLINGO-SUB%20id%3D%22lingo-sub-1167478%22%20slang%3D%22en-US%22%3ERe%3A%20Sharepoint-%20read%2Fwrite%20from%20Oracle%20Database%20table%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-1167478%22%20slang%3D%22en-US%22%3EYou%20will%20need%20to%20design%20a%20proper%20architecture%20to%20be%20able%20to%20integrate%20the%20Oracle%20DB%20in%20a%20SPO%20App.%20A%20high%20level%20overview%3A%3CBR%20%2F%3E(1)%20The%20Form%20can%20be%20a%20SPFx%20WebPart%20or%20even%20a%20PowerApp%3CBR%20%2F%3E(2)%20You%20will%20need%20an%20API%20deployed%20to%20Azure%20that%20can%20be%20called%20from%20the%20SPFx%20WebPrt%20or%20the%20PowerApp.%20This%20API%20can%20be%20an%20Azure%20Function%20or%20just%20a%20Web%20API%3CBR%20%2F%3E(3)%20You%20will%20need%20to%20%22public%22%20the%20Oracle%20Database%20directly%20to%20the%20wire%20or%20through%20an%20API%20that%20can%20be%20called%20from%20the%20API%20deployed%20to%20Azure%3C%2FLINGO-BODY%3E
Occasional Contributor

Hi All,

I'm new to SharePoint but with some good knowledge of basics. (Currently on SP365)

 

I have a requirement to build a web form in SharePoint which will read and write into an Oracle Database table. I understand that this could be a bit complicated. 

Not sure where to start for this particular ask. I've tried checking a lot of online resources but couldn't find any. 

 

Appreciate your help :)

 

Best Regards,

Abhi

1 Reply
You will need to design a proper architecture to be able to integrate the Oracle DB in a SPO App. A high level overview:
(1) The Form can be a SPFx WebPart or even a PowerApp
(2) You will need an API deployed to Azure that can be called from the SPFx WebPrt or the PowerApp. This API can be an Azure Function or just a Web API
(3) You will need to "public" the Oracle Database directly to the wire or through an API that can be called from the API deployed to Azure