IBM DB2 Data Connection

Version

Application Scenario

This document describes how to connect to an IBM DB2 database.

Database Version and Driver

Data connection URL format: jdbc:db2://hostname:port/database

Preparation

Download the driver package and upload it to FineBI. For details, see section "Creating a Data Connection" in Driver Management. You can view the driver upload page in the following figure. After uploading, click Save.

Before connecting the database, you need to collect the following information:

1. IP address and port number of the database server

2. Database name

3. The username and password of the database

4. The type of database

1. Choose System Management > Data Connection > Data Connection Management > New Data Connection as shown in the following figure.

2. Find the icon of the IBM DB2 Database.

3. Select the driver uploaded in section "Preparation" and enter the connection information collected in that section. You need to select the connection mode of the IBM DB2 database. If you click Click to Connect Database and the connection is successful, select the mode.

Note:

You can optionally modify other advanced settings on the page. For details, see section "Advanced Settings" in Entry-Level Data Connection Configuration.

4. Click Test Connection. If the connection is successful, click Save.

You can add database tables to FineBI by adding database tables or adding SQL datasets.