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

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

@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

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.

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