Unanswered

PAD oracle db driver

(0) Share

Report

Posted on by HazemMsaleh

Hello all,

I have oracle db want to connect and query but cant find which is the right driver

i have the connection as following

"Data Source=(DESCRIPTION = (ADDRESS = (PROTOCOL = TCPS)(HOST = XX.XX.XX.XX)(PORT = 2984)) (CONNECT_DATA = (SERVER = DEDICATED) (SERVICE_NAME = FC.cu) ) );User Id = haz; Password =XXXX"

Any tips

Categories:

Power Automate Desktop

I have the same question (0)

All responses (11)

Answers (0)

lbendlin 8,479 Super User 2025 Season 2 on at

Like (0)

Report

What you are showing is a screenshot from the MS SQL Server Import/Export wizard. It has nothing to do with Oracle.

You need to create a new connection reference in a PA Solution.

Use a connection reference in a solution - Power Apps | Microsoft Learn

Was this reply helpful? Yes No
HazemMsaleh 12 on at

Like (0)

Report

hi,
Thanks for answering. but i mean in BA-desktop.

Regards.

Was this reply helpful? Yes No
lbendlin 8,479 Super User 2025 Season 2 on at

Like (0)

Report

Me too. This is the process for PAD.

Was this reply helpful? Yes No
HazemMsaleh 12 on at

Like (0)

Report

Sorry i cant see this in PAD, is only on power automate cloud flow not desktop!
Use a connection reference in a solution - Power Apps | Microsoft Learn

Was this reply helpful? Yes No
lbendlin 8,479 Super User 2025 Season 2 on at

Like (0)

Report

You create the connection reference in the service and then you can pick it from the selection drop-down in PAD

Was this reply helpful? Yes No
momlo 1,527 Super User 2024 Season 1 on at

Like (0)

Report

What you suggest @lbendlin is based on assumption that there is a connectivity possible and established between Power Automate Cloud and Oracle database.

This will not be possible if Oracle database is accessible from local network only.

@HazemMsaleh In such case Oracle ODBC needs to be installed on local machine

https://www.oracle.com/database/technologies/releasenote-odbc-ic.html

Was this reply helpful? Yes No
lbendlin 8,479 Super User 2025 Season 2 on at

Like (0)

Report

I haven't seen a way for PAD to use a local ODBC connection? Can you please refer the documentation for that?

Was this reply helpful? Yes No
momlo 1,527 Super User 2024 Season 1 on at

Like (0)

Report

hey @lbendlin

I did not use/test so, i should have state that this is my assumption, not something I've tested

Having said that, i see .Net connection string here, among others

https://www.connectionstrings.com/oracle/

Also CDATA has several odbc drivers for Oracle and examples on how to use within PAD:

https://www.cdata.com/kb/tech/oraclesalescloud-odbc-power-automate.rst

https://www.cdata.com/kb/tech/oracledb-odbc-power-automate.rst

Was this reply helpful? Yes No
HazemMsaleh 12 on at

Like (0)

Report

Hello i get this
'Oracle.ManagedDataAccess.Client' provider is not registered on the local machine.
its already registered and working on other automation tool !
My connection like this
Provider=Oracle.ManagedDataAccess.Client ;Data Source=(DESCRIPTION = (ADDRESS = (PROTOCOL = TCPS)(HOST = Ip)(PORT = 2484)) (CONNECT_DATA = (SERVER = DEDICATED) (SERVICE_NAME = FCPRODRT) ) );User Id = User; Password =password;

Thanks
Hazem

Was this reply helpful? Yes No
momlo 1,527 Super User 2024 Season 1 on at

Like (0)

Report

did you take a look here to see if there are aternatives that works for you ?

https://www.connectionstrings.com/oracle/

What else come up into my mind if none works - can you estabilsh connection via cmd/powershell/vb/python?

If yes then you can use "run script" actions and execute all statements this way passign and receivign outpus

Was this reply helpful? Yes No