Qlik Community

New to Qlik Sense

Discussion board where members can get started with Qlik Sense.

deshania
New Contributor

Qlik Sense Connecting to IBM DB2

Hi,

I'm currently using Qlik Sense Desktop 3.2 and have a problem in connecting to DB2 database. I am able to connect to one DB2 database (DB2/Linux 10.5.0.1) but I am unable to connect to another DB2 Database (DB2/Linux 10.5.0.3). The Qlik ODBC Connector in use is 1.2.1.


When I try to connect to DB2 Database (DB2/Linux 10.5.0.3) with the correct username and password I get the attached error. I am able to connect to this database via a database tool using the same credentials, but not via Qlik Sense. The default time out is set to 60. I have tried by increasing the connection time out and still no result. If anyone has any idea why this is happening can someone help me or guide me?


Thank you.

1 Solution

Accepted Solutions
agigliotti
Honored Contributor II

Re: Qlik Sense Connecting to IBM DB2

did you try using the native ODBC driver of DB2 ?

4 Replies
agigliotti
Honored Contributor II

Re: Qlik Sense Connecting to IBM DB2

did you try using the native ODBC driver of DB2 ?

deshania
New Contributor

Re: Qlik Sense Connecting to IBM DB2

Hi Andrea,

The Native ODBC Driver of DB2 did help. Thank you!

The following links also came in useful. Hence I am posting them for someone who might need them

IBM Knowledge Center

Using the DB2 ODBC Driver with unixODBC

michal_durica
New Contributor III

Re: Qlik Sense Connecting to IBM DB2

Hi guys,

I have the same problem. Can you please explain me what does Native ODBC Driver means?

Should I use ODBC connector or IBM DB2 connector?

Thanks for help

Michal

deshania
New Contributor

Re: Qlik Sense Connecting to IBM DB2

Hi Michal,

Use the IBM DB2 ODBC Driver.

Community Browser