Oracle connection guide

[MaheshShelke (Mahesh Prakash Shelke)]

Can anyone help me with the oracle connection steps in UiPath?

[KarthikByggari]

How to query data from a SQL database

You need to change the provider w.r.t Oracle db.

DB connection -ORACLE DB

Use Microsoft ODBC Data Source and Data Provider - Oracle.

Regards,
Karthik Byggari

[balupad14 (Balamurugan)]

Hello @MaheshShelke,

This will help you

Oracle DB on a different server

This is a quite common question, and you can find answers in any of below topics. With regard to your other options - using SQL Developer seems like an overly complicated approach. Sure, you can use Desktop Automation to open SQL Developer, and then create and maintain your databases here - but why would you? UiPath allows you to execute any query against your database, and this covers creation of databases, maintaining users, assigning permissions, and much more.

Regards
Balamurugan.s

[MaheshShelke (Mahesh Prakash Shelke)]

Thanks for the same