Connecting to IBM DB2 Database
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, 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.
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
- Connect to Data and view it on dashboard
- Connecting to ODBC
- Select structures for Data Connector discovery