Unanswered

Assistance in setting up a SQL connection to an Oracle Database access via Power Automate Desktop

(1) Share

Report

Posted on by CParsons09

141

Has anyone successfully setup a SQL connection to an Oracle Database using PAD? I know there is a cloud connector, which I'm in the process of trying to setup, but why not on the desktop application?

Oracle EBS java forms would be much easier to automate if I could validate date using a SQL call instead of manipulating the front end. If Oracle DB isn't supported, this may be a fatal flaw that sends me over to UI Path, unfortunately.

Any help would be greatly appreciated.

Thank you!

Categories:

Power Automate Desktop

I have the same question (0)

All responses (4)

Answers (0)

VJR 7,635 on at

Like (0)

Report
Copy link

Link copied!

Hi @CParsons09

Never tried with Oracle but you should be able to set up a connection with the Oracle database using the connection string to it.

https://docs.microsoft.com/en-us/power-automate/desktop-flows/actions-reference/database

Was this reply helpful? Yes No
VJR 7,635 on at

Like (0)

Report
Copy link

Link copied!

Oracle connection strings

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

Was this reply helpful? Yes No
CParsons09 141 on at

Like (1)

Report
Copy link

Link copied!

Thank you for providing!

Was this reply helpful? Yes No
FeierCiprian 20 on at

Like (0)

Report
Copy link

Link copied!

Did it work? I have the same issue.
I want to connect PAD with Oracle (zero knowledge on Oracle).
Till now I`ve install the Oracle driver, but when I want to create the Data Source is giving me error on test connection (10060).
When I check on PowerShell (Test-NetConnection **** -port*** the Ping is True and the Tcp is False)
can someone guide me true this issue? Thanks

Was this reply helpful? Yes No