Data Connection to AS400/BD2

[ktikiwala]

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...

[Sebastian_Linser · Accepted solution]

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_DB...

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-serv...

I hope that helps.

Best regards

Sebastian