moises.ibarra Posted August 31, 2013 Share Posted August 31, 2013 Hi i just get stared in JasperStudio and i what to make a report from a database that is on a server IBM DB2, and im having trouble doing the connection whit the database, Could any body help me, thanksI have jasperSoft studio 5.2.0 Link to comment Share on other sites More sharing options...
KeithHodges_1 Posted March 13, 2017 Share Posted March 13, 2017 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.AS400JDBCDriverFor JDBC URL, specify jdbc:AS400://SYSTEMNAME/DATABASENAME (substituting your own values for SystemName and DatabaseNameFill in whatever you need for user and passwordClick 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.jarHopefully 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 More sharing options...
Recommended Posts
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 accountSign in
Already have an account? Sign in here.
Sign In Now