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.