UIpath DB Connect activity. Assitance required

Learn
1

Hi Team,

Idea is to connect the bot to the DB to fetch the data as stored in the tables:

first bottleneck is, the option to choose from the drop-down menu in ‘edit connection setting’

image
image828×559 78.9 KB

2

@KP6689 still facing the issue?

1 Like
3

Well my IT team is working on it as we speak, but there is another concern that Im trying to preempt.

When passing the value to be looked up in DB, in excel i generally enclose them in this manner : “'”&A2&“',”

Problem is the last value with an extra comma, how to remove it.

So @shishirshetty2701 there is this problem that I request you to help me with and if my IT team cant fix the JDBC issues, would solicit your kind guidance on that too