Defining the connection parameters
You can add an IBM DB2 for LUW database to Qlik Compose to use as a source.
To add an IBM DB2 for LUW source database to Qlik Compose:
-
In the New Data Source window, enter the information as described in the table below.
Data source fields Field
Description
Type
Select IBM DB2 for LUW.
Server Name
Specify the name or IP address of the IBM DB2 for LUW server machine.
Port
Optionally, change the default port.
User Name
Specify your username for accessing the IBM DB2 for LUW database.
The specified user must have read/write privileges on the IBM DB2 for LUW database.
Password
Specify your password for accessing the IBM DB2 for LUW database.
Database Name
Specify the name of the IBM DB2 for LUW database.
Schema
Specify the schema containing the source tables.
- Click Test Connection to verify that Compose is able to establish a connection with the specified database and/or landing zone.
-
Click OK to save your settings.
The database is added to the list on the left side of the Manage Databases window.