cancel
Showing results for 
Search instead for 
Did you mean: 

Oracle on-prem data source

Please add Oracle as an on-prem data source.

 

Thank you!

 

 

Status: Under Review

@archanan to confirm status pls.

Comments
Level: Powered On

 i am new to PowerApps. Trying to find a way to connect my apps to an Oracle DB on premise. Is this possible?

Microsoft

Hi bz3361,

 

there is no on-premise Oracle connector available for PowerApps today. But it is ranked high in our list to add - please stay tuned.

 

Btw, what version is your Oracle DB? Are you using Windows authentication, or user/pwd?

 

Thanks,

Robert

 

 

Level: Powered On
Hi,
We use oracle 11g with user/password

Considering oracle is supported in PowerBI through the same connector used by PowerApps, I thought it was quite easy to enable it also in PowerApps.

Thank you!
Microsoft

Hi francorg,

 

The Power BI workload is about read-only queries. PowerApps needs full CRUD operations, and needs each insert and update to return certain metadata which Oracle DB doesn't provide automatically - so there is a bit of work there to support that.

 

Thanks,

Robert

Level: Powered On

We are actually MSFT's global strategic partner. We have products based on Oracle 11 and 12, mainly authentication by Oracle DB.

Is there an estimated timeline to make Oracle connector available?

What about making SOAP or JMS connector available?

Level: Powered On

Hi RobertBruckner,

 I am eager to have Oracle DB support because I only need read operations and they are already supported in PowerBI.

 

We use Oracle 11g with Oracle DB authentication.

 

Thank you,

Roberto

 

Power Automate Staff
Status changed to: Under Review

@archanan to confirm status pls.

Level: Powered On

Please also add queries/views reading support.

Table only support is not enough.

 

Thank you,

Roberto

Level: Power Up
Hi, I'm new on PowerApps. I try to use the on-premise Oracle connector. As Francorg said, accessing only the tables is not enough : there are views and queries. I have also found that only the first tables are available : I have a lot of tables in my Oracle database and only the first 150 tables are visible (thos begining with the A letter). Francorg : do you find a workaround to access your Oracle database ? Ben
Level: Powered On
Hi benatmic,
considering the current limitations on PowerApps and Oracle connection, we had to choose a custom developed iOS app.
They also suggested to try using Oracle Web Services but we didn't investigate that option.