How to connect oracle databse

Installer(.exe or .msi):EXE

License type:i have license code(EE)

Studio/Robot version:Microsoft Windows 10 Enterprise 64-bit

.NET Framework Version 4.7.2 or later

Current behavior:

Screenshot: i have attached Screenshot

please see screenshot it is not showing liftside searching database connection
Please help me
Reagrds
Ram

1 Like

Buddy @Ramalingayya

Welcome to UiPath Community buddy

Buddy kindly install the package named uipath.Database.Activities in package manager to get the dataabase related activities like execute query and insert query where in
execute query - you can execute any query by passing that query as string to this activity and you can get the output from the database as a table of type datatable
then
insert query - you can insert any datatable read from the excel with read range activity to the databbase you want with this buddy by mentioning the table name in database as input

  1. to get the package
  2. execute query and insert query

to connect with the database you can use the connection wizard which would require database credentials like username and password like this buddy and you can even check whether you got connected to database or not buddy @Ramalingayya with that test connection option


image

Kindly try this and let know buddy
Cheers @Ramalingayya

Were you able to connect now with database buddy @Ramalingayya

Hi Palaniyappan,

thank you for replying ,i have attached screenshot .
ERROR :
Error [NA000][Microsoft][odbc driver for oracle ][oracle ]ora-06413:connection not open,error [im006][microsoft][odbc driver manager driver’s sqlSetConnectionAttr Failed
eror [01000][Microsoft][ODBC Driver manager] the driver
does not support the version of ODBC behavior that the application requested see sqlSetEnvAttr)
i need to add any ODBC jar file,
please help out me .

thank you
Ram

1 Like

Buddy @Ramalingayya
This could help you buddy

https://social.msdn.microsoft.com/Forums/en-US/579532a4-e92f-4b15-bc07-24d21b48faa6/gettin-error-while-connecting-to-database-using-odbc-?forum=adodotnetdataproviders

Cheers

Hi Palaniyappan,

thank you for replying ,i have attached screenshot,please help out me ,
ODBC Error: Data source name not found and no default driver specified

Thank you
Ram

Dear Palaniyappan,

I have license Uipath but it will support Blue prism or not.
how to install Blue prism ,can you give me suggestion?

Regards
Ram