Forum Discussion
How to Fetch Data from SQL Database, Oracle, and SAP for Viva Connection ACE
Hey, Viva Connection ACE enthusiasts! Today, we'll explore how to retrieve data from various databases like SQL, Oracle, and SAP to showcase valuable insights in Microsoft Viva Connection ACE. By int...
It depends are they on-premise or online servers?
as there are serveral ways you can do it, you can query an SQL database using Secure API:s, ACE cards are built upon SPFX:
,https://learn.microsoft.com/en-us/sharepoint/dev/spfx/use-aadhttpclient-enterpriseapi
https://learn.microsoft.com/en-us/sharepoint/dev/spfx/use-aadhttpclient
What I usually do if i've got multiple sources is to query all of them using data factory and then push the data to dataverse and then use spfx to query dataverse using the links above 🙂
as there are serveral ways you can do it, you can query an SQL database using Secure API:s, ACE cards are built upon SPFX:
,https://learn.microsoft.com/en-us/sharepoint/dev/spfx/use-aadhttpclient-enterpriseapi
https://learn.microsoft.com/en-us/sharepoint/dev/spfx/use-aadhttpclient
What I usually do if i've got multiple sources is to query all of them using data factory and then push the data to dataverse and then use spfx to query dataverse using the links above 🙂
NicolasKheirallah
can I use same process like for other Oracle, SAP Database.
- You should be able to do it with data factory!