We are using RFT to test a terminal based application running on an IBM Iseries
machine.For certain testing scenarios we need to access the database from within then script.Here's how you do it (Note that we are running RFT version 6 and eclipse 3.0 ) :

1- Activate RFT

2- Go To “Help” in the menu bar choose “Software Updates” then choose “find and install”.

3- Then choose “Search for new features to install and press next”.

4- Press on “New Remote Site” in the name type “Eclipse Update” and in the URL put this URL http://update.eclipse.org/updates/3.0/.

5- Do step 4 again and in the name type “Quantum” and in the URL put http://quantum.sourceforge.net/update-site.

6- Check them both and press the next button.

7- Install all the “GEF” and “Graphical Editing Framework” and the “Graphical Editing Framework SDK” that doesn’t produce dependencies error.

8- Install All the Quantum features

9- After you have completed the above steps open windows control panel à administrative tools à Data Sources (ODBC) .

10- In the System DSN tab, press on the add button, choose the iSeries Access ODBC Driver press finish.

11- In the Data Source Name type DB Name, then in the Server tab change the SQL Default Library to SLSQADATA and in the Packages Tab change the Package Library to SLSQADATA then press ok.

12- In the RFT go to the Windows menu in the menu bar à open perspective à others and choose Quantum DB.

13- When the Quantum Browser Loads press on the Add Bookmark.

14- Choose JDBC-ODBC Bridge press next and fill in the user id and password you use for your DB connection and in the Data Source field enter db name.

15- Press next and enter a name for the bookmark then press next leave the default choice of schema then click finish.

Now the connection is established between RFT and the Database Using a JDBC-ODBC bridge between the DB2 layer using the iSeries Navigator Driver and the RFT thus establishing the full connection.