Database Activities Automation

Hi Developers,

Can writing queries in Oracle can be automated in UiPath. As far as the official documentation is concerned, the only activities pack, I can only see the Microsoft access & database options available.

Can this be done ?

Thanks !

@Piyush_Hemant
you can try this. I just saw this Uipath GO. hope its works

5 Likes

Actually Microsoft ODBC for Oracle can help us in connecting uipath with oracle database server with this connection string syntax

“Data Source=(DESCRIPTION=(CONNECT_DATA=(SERVICE_NAME=<service_name>))(ADDRESS=(PROTOCOL=TCP)(HOST=)(PORT=1521)));Uid=;Pwd=;”

And For the steps involved and more details we got lot of details in the same in our forum

Kindly try this and let know for any queries or clarification
Cheers @Piyush_Hemant

1 Like

So you mean to say that choosing the 2nd option from the Data Source Window will help me with this ?

1 Like

yah
did that work on this
Cheers @Piyush_Hemant