Qlik Community

QlikView Scripting

Discussion Board for collaboration on QlikView Scripting.

Announcements

Breathe easy -- you now have more time to plan your next steps with Qlik!
QlikView 11.2 Extended Support is now valid through December 31, 2020. Click here for more information.

Not applicable

DB2 as Data Source for QlikView

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

5 Replies
SunilChauhan
Not applicable

DB2 as Data Source for QlikView

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

danielrozental
Not applicable

DB2 as Data Source for QlikView

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.

SunilChauhan
Not applicable

DB2 as Data Source for QlikView

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

Thanks

Sunil Chauhan

danielrozental
Not applicable

DB2 as Data Source for QlikView

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

Not applicable

DB2 as Data Source for QlikView

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