cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
CParsons09
Helper III
Helper III

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

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!

4 REPLIES 4
VJR
Super User
Super User

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
Super User
Super User

Oracle connection strings

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

 

Thank you for providing!

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 

Helpful resources

Announcements
Power Automate News & Announcements

Power Automate News & Announcements

Keep up to date with current events and community announcements in the Power Automate community.

Community Calls Conversations

Community Calls Conversations

A great place where you can stay up to date with community calls and interact with the speakers.

Power Automate Community Blog

Power Automate Community Blog

Check out the latest Community Blog from the community!

Top Solution Authors
Top Kudoed Authors
Users online (2,152)