IBM DB2

Warning: The IBM DB2 Connector in the Qlik ODBC Connector Package is deprecated. As an alternative, you can install an ODBC driver for IBM DB2 and create a data source DSN. See ODBC

Connections to a IBM DB2 database are made by selecting IBM DB2 from the list of drivers in the list of connectors in the QlikView ODBC Connection dialog or the Qlik Sense Add data or Data load editor dialogs.

Note: Industry-accepted best practices must be followed when using or allowing access through the ODBC Connector. Administrators must follow The Principle of Least Privilege when setting up source database privileges and permissions.

Supported IBM DB2 versions

The followings database versions are supported:

  • 10.5
  • 10.1
  • 9.5

Supported IBM DB2 data types

The following IBM DB2 data types are supported by the IBM DB2 Connector.

  • BigInt
  • Decimal
  • Double
  • Float
  • Integer
  • LongVarchar
  • Real
  • SmallInt
  • Time
  • Timestamp
  • Varchar

Did this information help you?

Thanks for letting us know. Is there anything you'd like to tell us about this topic?

Can you tell us why it did not help you and how we can improve it?