Database Activities Automation

[Piyush_Hemant]

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 !

[sandeep13 (Sandeep Pathak)]

@Piyush_Hemant
you can try this. I just saw this Uipath GO. hope its works
https://go.uipath.com/component/oracle-database-connectivity-with-uipath

[Palaniyappan (Forum Leader)]

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

How to setup a connection to Oracle Database with UiPath

I need to connect to a Oracle database using UiPath. Have been going through this trail. Still I am unable to setup a connection. As I understood there are two ways to connect, using different combinations of below. Connection strings Connection String = Driver={Microsoft ODBC for Oracle};Server=10.3.4.xxx; Data Source=(DESCRIPTION=(CONNECT_DATA=(SERVICE_NAME=<service_name>))(ADDRESS=(PROTOCOL=TCP)(HOST=)(PORT=1521)));Uid=;Pwd=;” Driver Options System.Data.OracleClient System.Data.Odbc Bu…

How to connect to ORACLE Database

Installing the basic 32 bit oracle client and then adding the below to connection string worked for me. “Data Source=(DESCRIPTION=(CONNECT_DATA=(SERVICE_NAME=<service_name>))(ADDRESS=(PROTOCOL=TCP)(HOST=)(PORT=1521)));Uid=;Pwd=;” Choose System.Data.OracleClient from the dropdown. Since it’s a basic client, and I am using the descriptive connection string, I didn’t have to include any .ora files at all.

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

[Piyush_Hemant]

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

[Palaniyappan (Forum Leader)]

yah
did that work on this
Cheers @Piyush_Hemant