Forum Discussion
NewUser2020
Apr 09, 2020Copper Contributor
Developing custom web part on Sharepoint 2019
Hello everyone, I need to develop custom web parts that read data from SQL and Oracle databases. Kindly advise what is the best practice to execute the above on SharePoint 2019. Many thanks ...
- Apr 10, 2020Hi,
You can use SPFx or SharePoint app but both are client side coding, to access the DB, there has to be a API which i think its over kill for your project. If you think that there is an API or web service that can return the data from DB then you can use SPFx or SharePoint App.
Hope it helps, please like it or mark it as a solution if it resolves ur clarification or issue
-Sudharsan K...
NewUser2020
Apr 10, 2020Copper Contributor
Hi Sudharsan K ,
Great!
One last question: spfx platform or SharePoint app can not be used in my case because I mean .NET to connect to my SQL/Oracle databases, right?
Many thanks for your prompt support,
Sudharsan K
Apr 10, 2020Steel Contributor
Hi,
You can use SPFx or SharePoint app but both are client side coding, to access the DB, there has to be a API which i think its over kill for your project. If you think that there is an API or web service that can return the data from DB then you can use SPFx or SharePoint App.
Hope it helps, please like it or mark it as a solution if it resolves ur clarification or issue
-Sudharsan K...
You can use SPFx or SharePoint app but both are client side coding, to access the DB, there has to be a API which i think its over kill for your project. If you think that there is an API or web service that can return the data from DB then you can use SPFx or SharePoint App.
Hope it helps, please like it or mark it as a solution if it resolves ur clarification or issue
-Sudharsan K...
- Pulithevan BalaFeb 11, 2022Copper ContributorHi Sudharsan,
I have a query... Need to consume data from SOAP WSDL webservice (from SAP system) and show it in SharePoint 2019 OnPremise site. Any suggestion/reference material please? Thanks in advance! - NewUser2020Apr 10, 2020Copper Contributor
Hi,
All is clear now 🙂
Many thanks,