Jump to content
Changes to the Jaspersoft community edition download ×

How to create a dataAdapter on IBM DB2


moises.ibarra

Recommended Posts

  • 3 years later...
  • Replies 1
  • Created
  • Last Reply

Top Posters In This Topic

Top Posters In This Topic

I see this is several years old, but still in need of an answer...First, look up Pete Helgren's excellent work in this area.  This answer is using TIBCO Jaspersoft Studio 6.3.

Second, download the Ibm toolbox for java and jtopen and install it somewhere on your PC.

Next, right click on the database adapters icon, create new adapter to bring up the Data Adapter Wizard.  Click Database JDBC Connection.

For JDBC Driver, specify com.ibm.as400.access.AS400JDBCDriver

For JDBC URL, specify jdbc:AS400://SYSTEMNAME/DATABASENAME    (substituting your own values for SystemName and DatabaseName

Fill in whatever you need for user and password

Click on the "Driver Classpath" tab.

Click the add button and navigate to the place you  installed the java toolbox, in my case it is C:jt400libjava8jt400.jar

Hopefully I haven't forgotten any steps.  Be sure to search for anything Pete Helgren has published on this, he's the expert!

 

Link to comment
Share on other sites

Create an account or sign in to comment

You need to be a member in order to leave a comment

Create an account

Sign up for a new account in our community. It's easy!

Register a new account

Sign in

Already have an account? Sign in here.

Sign In Now

×
×
  • Create New...