Data Connection to AS400/BD2

ktikiwala — Wed, 20 Oct 2021 14:09:01 GMT

Hello Everyone,

We are trying to create a data connection (OLEDB) in Qlik Sense to AS400/DB2 but it's not working. The DB2 driver is already installed on Qlik server. Unfortunately there is no help on help.qlik on this one. Can anyone help with this? Is anyone using OLEDB connection to DB2 in Qlik Sense?

here is the screenshot...

Re: Data Connection to AS400/BD2

Sebastian_Linser — Wed, 20 Oct 2021 18:49:26 GMT

Hello,the help states that this is not supported anymore and the workaround is to use the odbc driver instead

https://help.qlik.com/en-US/connectors/Subsystems/ODBC_connector_help/Content/Connectors_ODBC/IBM_DB2/Create-IBM-DB2-connection.htm

Here two links for the workaround.

https://help.qlik.com/en-US/sense/August2021/Subsystems/Hub/Content/Sense_Hub/DataSource/ODBC.htm

https://community.qlik.com/t5/New-to-Qlik-Sense/How-to-create-the-ODBC-OLEDB-connection-for-DB2-server/m-p/1207491

I hope that helps.

Best regards

Sebastian

topic Re: Data Connection to AS400/BD2 in Connectivity & Data Prep

Data Connection to AS400/BD2

Re: Data Connection to AS400/BD2