DB2 connection through JDBC

[NewUser (Nikitha)]

Hi,

Can you please let me know if we can connect to db2 database server through jdbc driver instead of odbc in uipath studio.

Thanks,
Nikitha

[KarthikByggari]

Hi Nikitha,

I guess you can do it, if you install required drivers to connect to the DB2 database using JDBC.

Reference:

Connecting to a Db2 database with JDBC

Regards,
Karthik Byggari

[NewUser (Nikitha)]

I have the jdbc driver. What is the steps to achieve in uipath?

[KarthikByggari]

How to query data from a SQL database

Note - In the sample workflow, update DB2 settings.

To connect DB2:

Connect to a DB2 Database

I am unable to establish a connection to DB2 Database. I have used Microsoft ODBC Data Source (ODBC) and my connection string is as follow ConnectionString = Driver={IBM DB2 ODBC DRIVER};DataBase=DataBaseName;HostName=ServerName;Protocol=TCPIP;Port=PortNumber;Uid=UserName;Pwd=Secret;"; Please let me know what I am doing wrong

[NewUser (Nikitha)]

I have tried those steps already but it did not work. May I know what would be the data source should be chosen for jdbc driver.

[KarthikByggari]

Do you installed and configured JDBC drivers on your machine.
If not check in IBM Knowledge Center, it is clearly explained how to install, configure and use it.
Please check.