Jump to content
Changes to the Jaspersoft community edition download ×

Can I add a JDBC driver to JasperETL?


oidsman

Recommended Posts

I have a jdbc driver (jtopen) for connection to an IBM iseries (AS/400) and would like to use this with jasperETL. Can anyone advise whether it is possible to add an additional jdbc datasource and if so how to go about it?

 

Any help greatly appreciated!

Link to comment
Share on other sites

  • Replies 1
  • Created
  • Last Reply

Top Posters In This Topic

Top Posters In This Topic

Hi,

 

First, make sure that you're using the current version of JasperETL. v2.2.2 is available for download.

 

Next, create a new job and look for this tool:

Databases/DB JDBC/tJDBCInput

In the properties for that tool you'll be able to set all the JDBC properties (jar, class, url, etc.) that you want.

 

Lastly... I'm anticipating your next question. "But what about setting a connection in Metadata/Db Connections/<myDBConnection>? I want to set it there."

 

As far as I can tell, you're stuck. I'm new to JasperETL myself, so I'm looking into this to confirm all the details. But I'm pretty sure that you cannot--as of v2.2.2--make arbitrary JDBC connections there. Your only choice for the moment is to use the tool (and the related tools like tJDBCOutput and tJDBCRow) mentioned above. If I learn more I'll post here.

 

Regards,

Matt

JasperSoft

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...