cancel
Turn on suggestions
Auto-suggest helps you quickly narrow down your search results by suggesting possible matches as you type.
Showing results for 
Search instead for 
Did you mean: 
francorg

Oracle on-prem data source

Submitted by Advocate I on ‎10-06-2016 01:39 AM

Please add Oracle as an on-prem data source.

 

Thank you!

 

 

Status: Under Review

@archanan to confirm status pls.

See more ideas labeled with:
14 Comments (14 New)
Comments
bz3361
Regular Visitor
‎11-25-2016 10:39 PM

 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
Microsoft
‎11-25-2016 11:20 PM

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
Advocate I
‎11-26-2016 12:31 AM
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
Microsoft
‎11-26-2016 09:29 AM

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
‎11-27-2016 12:30 PM

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
Advocate I
‎12-02-2016 12:50 AM

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
Power Automate
‎03-13-2017 07:32 AM
Status changed to: Under Review

@archanan to confirm status pls.

francorg
Advocate I
Advocate I
‎03-13-2017 07:45 AM

Please also add queries/views reading support.

Table only support is not enough.

 

Thank you,

Roberto

benatmic
New Member
‎07-19-2017 11:58 PM
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
Advocate I
‎07-20-2017 12:23 AM
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.