Forum Discussion
Sharepoint- read/write from Oracle Database table
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 Databas...
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
(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