Unanswered

Connection Oracle Cloud Database

(0) Share

Report

Posted on by LokeshSurana

we want to connect PowerApps portal data connection to cloud oracle database. Am not founding any source. Any one tried same ? Please share any workaround.

Thanks

Lokesh

Categories:

Microsoft Dataverse with Power Apps

I have the same question (0)

All responses (7)

Answers (0)

Joel CustomerEffective 3,224 on at

Like (0)

Report

Yes--it can be done
Requires on premise data gateway running on a machine that has the oracle tools installed
https://powerapps.microsoft.com/en-us/blog/connecting-to-oracle-database-from-powerapps-flow-and-logic-apps/

Was this reply helpful? Yes No
EricRegnier 8,720 Most Valuable Professional on at

Like (1)

Report

Hi @LokeshSurana, do you want to have an Oracle connection or you want to connect Power Apps Portal to an Oracle backend? If you wish to connect Portals to an Oracle database instead of CDS it's not possible. Portal Apps Portal requires CDS to manage the pages and content. One way is to integrate Oracle with CDS, expose your Oracle data into CDS and then surface it to the Portals.
You can integrate with Oracle using the gateway like @jlindstrom stated then use Dataflows with Oracle data source or Power Automate if you want to stick with Power Platform integration. Hope this helps...

Was this reply helpful? Yes No
Joel CustomerEffective 3,224 on at

Like (2)

Report

good catch @EricRegnier . I missed the word "portal" in there.

Agree--any kind of data integration with CDS will make the Oracle data available on the portal.
Maybe a good use for virtual entities if a lot of data
https://docs.microsoft.com/en-us/powerapps/developer/common-data-service/virtual-entities/get-started-ve

Was this reply helpful? Yes No
LokeshSurana 6 on at

Like (0)

Report

@EricRegnier and @jlindstrom - Thanks for input.

- This restriction is only for Portal creation or for canvas app and model driven app as well ?

- For Oracle DB connection we required one more machine to setup and through we required to connect. Am not understood why one more layer. Other hand for SQL server we able to connect directly by using IP, no gateway required. Can't be Oracle Cloud get connect in same fashion ?

Was this reply helpful? Yes No
EricRegnier 8,720 Most Valuable Professional on at

Like (0)

Report

Unfortunately as of now, the out-of-the-box Oracle connection is only for on-premise, however I'm not sure but if Oracle cloud offers some kind of API, if so you can connect to it leverage using the generic Web API connector or create a custom connector.
You can submit the idea to have an Oracle cloud connector at: https://powerusers.microsoft.com/t5/Power-Apps-Ideas/idb-p/PowerAppsIdeas

For the restriction, it will be for model-driven apps as well, but for canvas app you can create an app on top of Oracle by leveraging the connectors or custom connector.
Hope this clarifies...

Was this reply helpful? Yes No
LokeshSurana 6 on at

Like (0)

Report

Thanks lot @EricRegnier

So if understood correctly only CDC is the way to synch data ? We can't utilize SQL DB server or MY SQL or Oracle ?

Was this reply helpful? Yes No
EricRegnier 8,720 Most Valuable Professional on at

Like (0)

Report

Yes, for model-driven apps and Portals, CDS is the only way. As we described earlier though, there are many methods to integration with CDS to then make your data come to life with Portals and model-driven apps.

Was this reply helpful? Yes No