Qlik Talend Data Integration DB2i Source Endpoint using SSL connection

[Bill_Steinagle]

Qlik Talend Data Integration Data Movement Gateway supports connecting to a DB2i Source Endpoint using SSL. This article documents the step-by-step requirements to set up an ODBC connection to an iSeries with SSL enabled.

For general information about Qlik Data Movement Gateway, see Qlik Data Gateway - Data Movement.

1. Install the DB2i driver using the Qlik Talend Data Integration installation procedure.
   
   See Driver setup.
   
   

   $ cd /opt/qlik/gateway/movement/drivers/bin
   $ ./install db2iseries

2. Download the attached ibmi.conf (ibmi.zip) file and save it to /etc/stunnel before changing its permissions as follows:

   chmod 755 ibmi.conf

3. Place your certificate (AS400-7CA.txt) in /etc/stunnel before changing its permissions as follows:

   chmod 755 AS400-7CA.txt

4. Update the /etc/odbc.ini file, adding this section:

   [DB400]
   Description = SSL-enabled IBM i DSN
   Driver = IBM i Access ODBC Driver
   #System = as400-7.iSeries.com
   System = 127.0.0.1

5. Start the stunnel service using the following command:

   [root@RHEL8 ~]#sudo stunnel /etc/stunnel/ibmi.conf

6. Test the connection using isql:

   [root@RHEL8 ~]# isql -v DB400 IVAN IVAN

   +---------------------------------------+
   | Connected! |
   | |
   | sql-statement |
   | help [tablename] |
   | quit |
   | |
   +---------------------------------------+

   
   SQL> SELECT REMOTE_ADDRESS, REMOTE_PORT, LOCAL_PORT_NAME, LOCAL_PORT, JOB_NAME FROM QSYS2.NETSTAT_INFO Where LOCAL_PORT = 9471

Related Content

• IBM SSL requirements for SSL ODBC connectivity
• Qlik Replicate: LINUX SSL setup for DB2i connection 
• stunnel 

 

Environment

• Qlik Talend Data Integration

[tongm]

Due to the CDC parsing error mentioned in this article,

Qlik Replicate and DB2i source endpoint: source ca... - Qlik Community - 2448743,

So above solution was tested with ibm-iaccess-1.1.0.7-1.0.x86_64.rpm (version 1.1.24) and it works fine.