IBM Db2

IBM Db2 is a scalable, enterprise-grade relational database system that supports SQL for managing structured data. It handles both transactional and analytical workloads and integrates well with IBM Cloud, making it ideal for business intelligence and data warehousing.

Grab credentials

1. Login to your IBM Cloud account.
2. Navigate to the Resource List from the dashboard.
3. Under Databases, locate and select your IBM Db2 instance.
4. Inside the selected database, go to the Service Credentials section. Here, you’ll find the necessary connection details such as:
   • Hostname
   • Port Number
   • Database Name
   • Username
   • Password

These credentials are typically provided in JSON format. You can copy them directly into your Bold Data Hub configuration.

Connection Properties

In a YAML file, the config section contains the following properties:

 connectorname: IBM Db2
 schemaname: public
 host: hostname
 port: 5000 
 username: user
 password: password
 database: database
 client_lib_path : file_path

Example Configuration

version: 1.0.1
destination: 
plugins:
  extractors:
    - name: IBM Db2
      connectorname: IBM Db2
      schemaname: public
      config:
        host: hostname
        port: 5000 
        username: user
        password: password
        database: database
		client_lib_path : file_path
      select:
        - tablename

Configure the Bold Data Hub to connect IBM Db2

1. Click the Data Hub icon on the Navigation Pane.

2. Click Add Pipeline and provide the new pipeline’s name.

3. Select the newly created pipeline and add the IBM Db2 template.

Configuration Parameters

4. Update the details required in the template and Click Save, choose the desired destination to save the pipeline.

5. Creating a Pipeline in Bold Data Hub automatically creates a Data Source in Bold BI. The Bold BI Data Source is a live data source to the destination database used in Bold Data Hub. For more information on the relationship between Bold Data Hub Pipeline and the associated Data Sources in Bold BI , please refer to Relationship between Bold Data Hub Pipeline and Associated Data Sources in Bold BI.

Schedule Bold Data Hub Job

1. To configure interval-based scheduling, click on the schedules tab and select the created pipeline and click on the schedule icon and configure it.

2. For on-demand refresh, click Run Now button.

.

3. The Schedule history can be checked using the history option as well as logs.

4. Click on Logs to see if the run is completed and data source is created in Bold BI.

5. Click Edit DataSource Option to view the created tables.