Skip to Content
Author's profile photo Former Member

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

Hi All,

Follow below steps to install IBM DB2 Drivers.

/wp-content/uploads/2015/11/db2_824747.png

The double click v9.7fp4_ntx64_rtcl_EN


/wp-content/uploads/2015/11/db2_824747.png

Select yes

/wp-content/uploads/2015/11/db2_824747.png

Preparation installation screen allow to run though


/wp-content/uploads/2015/11/db2_824747.png


Select next

/wp-content/uploads/2015/11/db2_824747.png

accept the terms in the license agreement and then next

/wp-content/uploads/2015/11/db2_824747.png

Leave the  default typical and then select next

/wp-content/uploads/2015/11/db2_824747.png


Select install


/wp-content/uploads/2015/11/db2_824747.png

Review the installation screen

/wp-content/uploads/2015/11/db2_824747.png


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

/wp-content/uploads/2015/11/db2_824747.png

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.

/wp-content/uploads/2015/11/db2_824747.png

/wp-content/uploads/2015/11/db2_824747.png

Select System DSN and Add button and select IBM DB2 Driver

/wp-content/uploads/2015/11/db2_824747.png

And enter all require details

/wp-content/uploads/2015/11/db2_824747.png

/wp-content/uploads/2015/11/db2_824747.png

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

/wp-content/uploads/2015/11/db2_824747.png

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

/wp-content/uploads/2015/11/db2_824747.png

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

/wp-content/uploads/2015/11/db2_824747.png

And click on apply button.

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

Cheers

Sagar T

Assigned tags

      Be the first to leave a comment
      You must be Logged on to comment or reply to a post.