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

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 tips 768x460 v2.png

Restore a Deleted Flow

Did you know that you could restore a deleted flow? Check out this helpful article.

Microsoft Build 768x460.png

Microsoft Build is May 24-26. Have you registered yet?

Come together to explore latest innovations in code and application development—and gain insights from experts from around the world.

May UG Leader Call Carousel 768x460.png

What difference can a User Group make for you?

At the monthly call, connect with other leaders and find out how community makes your experience even better.

Top Solution Authors
Users online (3,107)