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

All responses (4)

Answers (0)

Sort by

VJR 7,635 on at

Like
a
(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
VJR 7,635 on at

Like
a
(0)

Report
Copy link

Link copied!

Oracle connection strings

https://www.connectionstrings.com/oracle/
CParsons09 141 on at

Like
a
(1)

Report
Copy link

Link copied!

Thank you for providing!
FeierCiprian 20 on at

Like
a
(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