Add an user-created IBM DB2 LUW Data Source

Procedure

1. Log on to the Quick BI console.

2. Follow the steps depicted in the figure below to add a user-created IBM DB2 LUW data source.

   1. Navigate to the data source creation page.

   2. Click Show More.

      

   3. Select the IBM DB2 LUW data source.

      

3. In the Configure Connection dialog box, enter the required configurations.

   Name	Description

   Name	Description
   Display Name	The display name of the datasource config list. The name cannot contain special characters or start or end with spaces.
   Database Address	The address where the IBM DB2 LUW database is deployed, including the IP address or domain name.
   Port	The port number of the database that you want to access. Default value: 50000.
   Database	The name of the database that you want to access.
   Schema	The schema of the database. Default value: DB2INST1.
   Username	The username that is used to connect to the database.
   Password	The password that is used to access the database.
   VPC Data Source	Specifies whether to access the data source over a VPC based on your business requirements. If you select VPC Data Source, you need to configure the following parameters: Purchaser Accessid: The AccessKey ID of the purchaser of this instance. For more information, see obtain an AccessKey. Note Make sure that the AccessKey ID has the Read permission on the destination instance. If you have the Write permission on the corresponding security group, the system automatically adds the whitelist. Otherwise, you need to manually add it. For more information, see create a custom policy. Purchaser Accesskey: The AccessKey Secret of the purchaser of this instance. For more information, see obtain an AccessKey. Instance ID: The ID of the purchaser of this instance. Log on to the ECS console and obtain the instance ID on the Instances tab. For more information, see view instance information. Area: The area where the instance is located. For more information, see view instance information
   SSH	Specifies whether to access the data source over an SSH tunnel based on your business requirements. If you select SSH, you need to configure the following parameters: SSH Host: The hostname or IP address. SSH Username: The SSH username that is used to connect to the database. SSH Password: The password of the username that is used to connect to the database. SSH Port: The port of the database. Default value: 22.

4. Click Test Connection to verify the data source's connectivity.

   

5. Once the test is successful, click OK to finalize the data source addition.