Connect to IBM DB2 (AS/400) JDBC database in QMC Server

[lanlizgu]

I am trying to connect to a IBM DB2 (AS/400) database without success.

In my computer I can connect through ODBC using iSeries Access ODBC Driver.

However, the computer where the QMC is, has Windows 2008 R OS and I can't install the iSeries Drivers.

Any solution?

[lanlizgu]

I am able to connect to the database in the following way in qlik sense

OLEDB CONNECT TO [Provider=IBMDA400;Data Source=XXXXX;Initial Catalog=XXXXX;]

XXXXX is to avoid displaying my current.

However, in the QMC I generated a manually trigerred reload of the document but it fails, as it doesn't connect to the database in the QMC

2018-03-07 12:25:10 0023 LIB CONNECT TO ***

2018-03-07 12:25:11      Error: Connector connect error: ErrorSource: Unknown source, ErrorMsg: Class not registered

2018-03-07 12:25:11      Execution Failed

2018-03-07 12:25:11      Execution finished.

In data connections I have the connection as follows

Thank you.

[lanlizgu]

I installed in the Qlik Server the IBM iSeries and the connection is ok now.