How to connect with Oracle SQL Could Cloud Wallet DB from Uipath DB activities? Ho to build the connection string

Help Studio
, , , , , , ,
1

Hi Team,

I am working on connecting UiPath to Oracle SQL Cloud wallet database, but not able to establish the connection as there is no criteria to select cloud wallet options.

With the knowledge i have, i have drafter the connection string after routing and researching in oracle forum and websites as below, but it is not working as expected.

“PERSIST SECURITY INFO=True;PASSWORD=XXXXX;USER ID=ABC;DATA SOURCE=‘(DESCRIPTION = (ADDRESS_LIST = (ADDRESS = (PROTOCOL = TCPS)(HOST = adb.XX-XXXX-1.oraclecloud.com)(PORT = 1522)))(CONNECT_DATA = (SERVER = ServerNameABC)(SERVICE_NAME = ServerABC.adb.oraclecloud.com)));Wallet_Location=C:\OracleSQL_Zip\Wallet_DBName;SSL_VERSION=1.2;’”

Please let me know what i am missing, kindly help us on the same.

Best Regards
Pradkumar

@loginerror @ppr

2

@pradkumar

Did you first happen to configure the connection in odbc or oledb drivers?

First the dns and tns details are to be provided then and from there we can see the provided connection eetails on UiPath…

Cheers

3

Could you please help us on detailed explanations, or steps to perform the same.? I have tried with installing ODBC Drivers and able to connect from VS Code but unable to connect from UiPath Studio.

Appreciate your response, as it is blocking the development.

4

Hi,
@pradkumar my working connection string:

“USER ID=user;PASSWORD=password;DATA SOURCE=(description= (retry_count=20)(retry_delay=3)(address=(protocol=tcps)(port=1522)(host=host))(connect_data=(service_name=servicename))(security=(ssl_server_dn_match=yes)));WALLET_LOCATION = (SOURCE = (METHOD = file) (METHOD_DATA = (DIRECTORY=C:\Wallet)))”

-provider - Oracle.ManagedDataAccess
-path C:\Wallet - path to the unpacked wallet
-no driver is needed

5

My wallet is in zip. when i give the wallet lcoation it is throwing out error . my wallet location lies at below location

C:\Users\abc\OneDrive - Enbridge\Desktop\607_CashFlow\

and wallet name is Wallet_DBPROD.zip

what should give in connection string