Connecting to IBM DB2
This article shows you how to set up a data connector for connecting to the IBM DB2 database.
2. Install the driver
In order to connect to the DB2 database when running Dundas BI on a Windows server, you need to download the IBM Data Server Package (DS Driver) and install it on the 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
For a list of supported environments and required drivers for connecting to DB2, see Dundas BI - System Requirements for your version of Dundas BI.
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.
There are various other settings supported by DB2 that you can configure in each expandable section below.
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.
- The IBM DB2 data provider may not be able to connect to certain versions of DB2 such as AS/400. ODBC or JDBC drivers can be used instead.
5. See also
- Connect to data and view it on a dashboard
- Connecting to ODBC
- Connecting to JDBC
- Selecting structures for data connector discovery
- IBM: The ISOLATION (UR) option