Qlik Community

Qlik Sense Data Connectivity

Discussion board where members can learn more about Qlik Sense Data Connectivity.

cancel
Showing results for 
Search instead for 
Did you mean: 
Highlighted
Contributor III
Contributor III

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

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,

UI

1 Reply
Highlighted
Contributor III
Contributor III

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