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

[CParsons09]

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!

[VJR]

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]

Oracle connection strings

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

[CParsons09]

Thank you for providing!

[FeierCiprian]

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