Connect to IBM DB2 source from BODS or Fetching data from IBM DB2 source

Hi All,

Follow below steps to install IBM DB2 Drivers.

The double click v9.7fp4_ntx64_rtcl_EN

Select yes

Preparation installation screen allow to run though

Select next

accept the terms in the license agreement and then next

Leave the  default typical and then select next

Select install

Review the installation screen

Select finish to complete installation

You have now the software installed

To review your software you can Select all programs >  control panel >  uninstall software and you can see the software installed as screen shot below

once we successfully install DB2 then  Create of DB2 ODBC connection:

Here are the steps for creating DB2 ODBC connection:

Navigate to start button and select Data Sources (ODBC) from Administrative tools.

Select System DSN and Add button and select IBM DB2 Driver

And enter all require details

Once you fill all the details then click on test connection whether connection is working fine or not.

If connection details are wrong you cant delete entry directly from system DSN.

we should follow below steps to delete the entry from installed folder

If connection is working fine please navigate to designer and create new data store

And click on apply button.

And test by running the job which pulls data from DB2 source.

Cheers

Sagar T