Connecting to IBM DB2 Database


1. Overview

This article shows you how to set up a data connector for connecting to the IBM DB2 database.

IBM DB2 does not support concurrent use of ODBC and .NET providers from the same application. To avoid issues, make sure that you consistently connect to DB2 using the same type of data connector.

2. Install the driver

In order to connect to the DB2 database, you need to download the IBM Data Server Package (DS Driver) and install it on the Dundas BI server.

In certain cases, such as installing or upgrading the .NET framework after installing the DB2 database, you may have to manually register the DB2.NET provider. To do so, open command prompt as an administrator, navigate to the driver bin folder (for example C:\Program Files\IBM\IBM DATA SERVER DRIVER\bin) and execute the following command:

db2lswtchcli.exe -client -promote

3. Create the data connector

Log on to Dundas BI and create a new data connector.

Enter a name for your data connector.

Set the Data Provider dropdown to IBM DB2 Database.

Provide credentials, and enter the Server and the Database name.

Create a new data connector for IBM DB2 Database
Create a new data connector for IBM DB2 Database

 Click Test Connection to check the connection to your DB2 database.

If the test is OK, click submit to create the data connector and perform data discovery.

4. See also


Dundas Data Visualization, Inc.
500-250 Ferrand Drive
Toronto, ON, Canada
M3C 3G8

North America: 1.800.463.1492
International: 1.416.467.5100

Dundas Support Hours: 7am-6pm, ET, Mon-Fri