How to Connect DB2 in Bold BI

This article will guide you through the process of connecting DB2 in Bold BI using the IBM DB2 ODBC Driver and configuring a system DSN.

Prerequisites

• Ensure that the IBM DB2 ODBC Driver is installed. You can verify this by checking the driver name in the ODBC Data Sources 32/64 bit application.
  
  

Steps to Connect DB2 in Bold BI

1. Add a system DSN in ODBC. Refer to the images below for guidance.
   

   
   

2. The Data Source Name must be the DB2 database name.
   

   
   

3. Once the DSN is added, you can see it in the list of DSN.
   

   

4. Open Bold BI and create an ODBC data source. Since the system DSN is configured, you can use the DSN to connect DB2 in Bold BI.
   

   

Now you have successfully connected DB2 in Bold BI using the IBM DB2 ODBC Driver and a system DSN.

Additional References

• IBM DB2 ODBC Driver
• Bold BI Documentation for ODBC connection