Sharepoint- read/write from Oracle Database table

Copper 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