Skip to main content

IBM DB2

Warning noteThe IBM DB2 Connector in the Qlik ODBC Connector Package is no longer supported. 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.

Information noteIndustry-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 offerings

  • Qlik Sense Desktop/Qlik Sense Mobile Client Managed
  • QlikView (Requires separate installation)

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