Oracle on-prem data source

[francorg]

Please add Oracle as an on-prem data source.

Thank you!

[bz3361]

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

[RobertBruckner]

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]

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]

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]

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]

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]

@archanan to confirm status pls.

[francorg]

Please also add queries/views reading support.

Table only support is not enough.

Thank you,

Roberto

[benatmic]

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]

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.