Forum Discussion

Abhi04's avatar
Abhi04
Copper Contributor
Feb 11, 2020

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 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

developer
SharePoint Online

1 Reply

  • jcgonzalezmartin's avatar
    jcgonzalezmartin
    MVP
    Feb 11, 2020
    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

Resources