Connect to IBM DB2 source from BODS or Fetching data from IBM DB2 source
Follow below steps to install IBM DB2 Drivers.
The double click v9.7fp4_ntx64_rtcl_EN
Preparation installation screen allow to run though
accept the terms in the license agreement and then next
Leave the default typical and then select next
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.