Hi all. I am trapped in the common "can I solve this problem with current licenses or do I require another license" question. I am wondering if anyone can help with the general approach to this problem. I am posting here because I think Power Automate is involved in the solution.
The problem is: I have an on-premises Oracle RDBMS and I would like to sync an Oracle table/view into a Microsoft List so that Teams users can see the data. The list can be read only in SharePoint. The list does not need to be live but can be updated on a schedule i.e. its a one direction delayed update.
The license issue is that I only have Business Standard licenses, i.e. I do not have the Premium data connectors.
I have installed an On Premises Data Gateway (although I am unclear as to whether I am licensed for this) which is live and visible but seemingly without the Premium Connectors I cannot create flows that use it.
So my question is a high level one: Is there any automated technique to get data from Oracle into M365 except with a Power Automate Plan? Or is there another technical solution altogether, which may or may not involve Power Automate. Web services? Adsync?
Any pointers would be much appreciated.
Learn to digitize and optimize business processes and connect all your applications to share data in real time.
Did you know that you could restore a deleted flow? Check out this helpful article.
Come together to explore latest innovations in code and application development—and gain insights from experts from around the world.