cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
Rajkumar_JP
Level: Power Up

PowerApps Connecting to Oracle Database

Hi All,

 

     We are using "For Office 365 and Dynamics 365" plan and we are using PowerApps in it.

Due to this we have limited number of connectors for free and we are planning to connect to ORacle Database without using premium connectors.

 

Could you please help which connector i can use to connect to ORacle database without using premium connectors.

2 ACCEPTED SOLUTIONS

Accepted Solutions
Anonymous
Not applicable

Re: PowerApps Connecting to Oracle Database

Hi @Rajkumar_JP

 

You cannot connect to Oracle DB without premium connector.

 

If you are willing to switch databases, you can connect to Azure Database without premium connector using SQL Server connector.

 

Community Support Team
Community Support Team

Re: PowerApps Connecting to Oracle Database

Hi @Rajkumar_JP,

 

That is not possible.

Oracle DataBase connector is marked as Premium, which would require PowerApp Plan1 or Plan 2 to take use of this connector.

Other connectors are not sutiable to work with the Oracle client.

You may take a look at the blog below for the details about how to connect to Oracle database.

Connecting to Oracle Database from PowerApps, Flow and Logic Apps

 

As told by @Anonymous, a workable way is to switch the data source to Azure SQL Database, or consider add the PowerApps Plan 1 or Plan 2.

 

Regards,

Michael

Community Support Team _ Michael Shao
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
3 REPLIES 3
Anonymous
Not applicable

Re: PowerApps Connecting to Oracle Database

Hi @Rajkumar_JP

 

You cannot connect to Oracle DB without premium connector.

 

If you are willing to switch databases, you can connect to Azure Database without premium connector using SQL Server connector.

 

Community Support Team
Community Support Team

Re: PowerApps Connecting to Oracle Database

Hi @Rajkumar_JP,

 

That is not possible.

Oracle DataBase connector is marked as Premium, which would require PowerApp Plan1 or Plan 2 to take use of this connector.

Other connectors are not sutiable to work with the Oracle client.

You may take a look at the blog below for the details about how to connect to Oracle database.

Connecting to Oracle Database from PowerApps, Flow and Logic Apps

 

As told by @Anonymous, a workable way is to switch the data source to Azure SQL Database, or consider add the PowerApps Plan 1 or Plan 2.

 

Regards,

Michael

Community Support Team _ Michael Shao
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
rick_macleod204
Level: Power Up

Re: PowerApps Connecting to Oracle Database

 hello - if you have Oracle - then you have Oracle APEX (it's free) ...oracle APEX 19 is out, and via Apex you can expose Tables / entire Schemas as rest end points..., consume these endpoints in your app, OR create an Apex application and register it in Azure creating a sso path, exposing endpoints in your app via SSL, there are many ways to access oracle data without the premmium connectior, if you have something like Mulesoft in your architecture - you can also get the Oracle database connector for free...

if you have Oracle - you have the Pl/SQL gateway - you can expose SOAP and Rest endpoint here .... sooooo many ways.

Helpful resources

Announcements
firstImage

Watch Sessions On Demand!

Continue your learning in our online communities.

Power Platform 2019 release wave 2 plan

Power Platform 2019 release wave 2 plan

Features releasing from October 2019 through March 2020

FirstImage

Power Platform World Tour

Coming to a city near you

thirdimage

PowerApps Community User Group Member Badge

Fill out a quick form to claim your user group badge now!

FourthImage

Join PowerApps User Group!!

Connect, share, and learn with your peers year-round

SecondImage

Power Platform Summit North America

Register by September 5 to save $200

Users Online
Currently online: 178 members 4,370 guests
Please welcome our newest community members: