Showing results for 
Search instead for 
Did you mean: 
Regular Visitor

Sync data from on-premises Oracle to Microsoft Lists

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.


Helpful resources

Power Platform Conf 2022 768x460.jpg

Join us for Microsoft Power Platform Conference

The first Microsoft-sponsored Power Platform Conference is coming in September. 100+ speakers, 150+ sessions, and what's new and next for Power Platform.

May UG Leader Call Carousel 768x460.png

June User Group Leader Call

Join us on June 28 for our monthly User Group leader call!

MPA Virtual Workshop Carousel 768x460.png

Register for a Free Workshop

Learn to digitize and optimize business processes and connect all your applications to share data in real time.

Power Automate Designer Feedback_carousel.jpg

Help make Flow Design easier

Are you new to designing flows? What is your biggest struggle with Power Automate Designer? Help us make it more user friendly!

Users online (3,578)