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
bz3361
Regular Visitor

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

RobertBruckner
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

 

 

francorg
Advocate I
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!
RobertBruckner
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

bz3361
Regular Visitor

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?

francorg
Advocate I

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

 

Audrie-MSFT
Power Automate
Status changed to: Under Review

@archanan to confirm status pls.

francorg
Advocate I

Please also add queries/views reading support.

Table only support is not enough.

 

Thank you,

Roberto

benatmic
New Member
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
francorg
Advocate I
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.