topic Connect to IBM DB2 (AS/400) JDBC database in QMC Server in Connectivity & Data Prep

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

lanlizgu — Tue, 06 Mar 2018 16:52:27 GMT

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 — Wed, 07 Mar 2018 11:50:49 GMT

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 — Tue, 27 Mar 2018 10:32:32 GMT

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