Create an oracle connection

Help Studio
1

Hi all,

i need to connect to an oracle db, i have read several posts about it on the forum.

The first question is, is the only way to connect via ODBC?

What are the prerequisites on the machine to make the connection? Is it necessary to have oracle installed? Is the procedure different from sql server?

Thanks in advance

2

Hey

i think that the only way is via ODBC, also you dont need to get the bd installed in your machine, just setup your ODBC in your local machine and then call that connection within UiPath, its also the same procedure as SQL Server

Regards!

1 Like
3

What do you mean specifically with setup your ODBC in your local machine?

considering we have about 20 production machines should I replicate it on all of them?

4

Hey

i’ve found another way to connect directly without need to create your ODBC
image

image

when your connection is successfull, it will create a string connection, you can pass that string connection into an asset and store the value, then you can create dinamyc variables like server, port, username, etc, and replace those variables within your connection string, maybe it will work without creating tedius odbc on each machine (not sure about functionality, but you can test)

"DATA SOURCE=""(DESCRIPTION = (ADDRESS_LIST = (ADDRESS = (PROTOCOL = TCP)(HOST = 123.123.123)(PORT = 554)))(CONNECT_DATA = (SERVER = DEDICATED)(SERVICE_NAME = servicename)))"";PERSIST SECURITY INFO=True;PASSWORD=password;USER ID=user"

Regards