topic DB2 as Data Source for QlikView in QlikView

DB2 as Data Source for QlikView

Mon, 25 Jul 2011 12:12:52 GMT

Hello,

we want connect our QlikView (64-bit) with a DB2 database (32-bit). Which interface/connector is the best for this constellation and how should we configure it?

Thanks and regards,

Heiko

DB2 as Data Source for QlikView

SunilChauhan — Mon, 25 Jul 2011 12:18:42 GMT

i believe using Oledb or odbc conneection u can connect to DB2.connector required for SAP.

If u have native Client of db2 installed .then u may be able to connect.

Thanks

Sunil

DB2 as Data Source for QlikView

danielrozental — Mon, 25 Jul 2011 13:55:32 GMT

Are you using QV10 or QV9?

If you're using QV10 you can check "force 32 bit" in order for QV to be able to use the 32 bits ODBC.

DB2 as Data Source for QlikView

SunilChauhan — Mon, 25 Jul 2011 15:26:17 GMT

I am using version 9. but i believe verssion is not a issue. U Can try using it.

Thanks

Sunil Chauhan

DB2 as Data Source for QlikView

danielrozental — Mon, 25 Jul 2011 15:42:17 GMT

Thanks, I was asking strangho to help him resolve his problem.

DB2 as Data Source for QlikView

Mon, 25 Jul 2011 15:51:01 GMT

Heiko,

This partly depends on where your db2 database is hosted. If you run db2 on the AS/400 then Client Access provides an ODBC driver that is very easy to use from Qlikview. There is also a db2 connector product available which provides an ODBC driver for access to db2 on a windows server.

Kal