topic Re: Qlik Sense Connection with DB2 on IBM i (OS/400) in Connectivity & Data Prep

Qlik Sense Connection with DB2 on IBM i (OS/400)

umerikhlas — Sun, 23 Apr 2017 12:41:25 GMT

Hi All Qlikers,

At a customer side, they have the following environment:

Database: IBM DB2

OS: IBM OS/400 on IBM AS/400

I just wanted to know that how can we connect Qlik Sense (on a separate windows server) to DB2 that resides in OS/400 on AS/400?

I know there is a driver available in ODBC packages but I am a bit confused or perhaps with lack of knowledge on creating a connection with different operating system on network.

Any help would be appreciated!

rwunderlich Sir, please have a look and respond!

Regards,

Re: Qlik Sense Connection with DB2 on IBM i (OS/400)

Anonymous — Sun, 23 Apr 2017 16:37:47 GMT

For connecting IBM DB2 OS 400 with QlikView, you need to install iSeries Access ODBC Driver v12.64.

version may differ but this one is the most stable. ask this from your client.

Other drivers to connect with QlikView are;

IBM DB2 ODBC Driver
Client Access ODBC Driver v12.64

Also, you can refer to Qlik help for connecting to IBM DB2

Create an IBM DB2 connection ‒ Qlik Connectors

Hope this will help you.

Best Regards,

Ahmed Ali Shiraz