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.
To access your data stored on an IBM DB2 database, you will need to know the server and database name that you want to connect to, and you must have access credentials. Once you have created a connection to an IBM DB2 database, you can select data from the available tables and then load that data into your app or document.
In Qlik Sense, you connect to an IBM DB2 database through the Add data dialog or the Data load editor.
In QlikView you connect to an IBM DB2 database through the Edit Script dialog.
Setting up the database properties
| Database property | Description | Required |
|---|---|---|
| Host name | Host name to identify the location of the IBM DB2 database. | yes |
| Port | Server port for the IBM DB2 database. | yes |
| Database | The name of the IBM DB2 database. | yes |
Authenticating the driver
Qlik Sense: IBM DB2 authentication properties
| Property | Description |
|---|---|
| Username | User name for the IBM DB2 connection. |
| Password | Password for the IBM DB2 connection. |
| Name |
Name of the IBM DB2 connection. The default name will be used if you do not enter a name. |
QlikView: IBM DB2 authentication properties
| Property | Description |
|---|---|
| Username | User name for the IBM DB2 connection. |
| Password | Password for the IBM DB2 connection. |
Miscellaneous properties
| Property | Description |
|---|---|
| Query timeout | Amount of time before a data load query times out. Can be set from 30 seconds to 65535 seconds. Default is 30 seconds. |
Advanced options
Information noteThis section is for advanced users who want to add their own custom connection parameters that are not displayed above.
| Property | Description | Required |
|---|---|---|
|
Name |
Name of the custom property. You can add additional properties by clicking the |
No |
| Value |
Value of the property. |
No |
. Information noteWhen you connect to an IBM DB2 database with the Data load editor or the Edit Script dialog, Test Connection enables you to test the connection before you attempt to create it.