Using Pentaho Data Integration (community edition) with MySQL


Pentaho Data Integration is a free ETL tool that is versatile and easy to learn.  While it is very easy to get started with the tool, mastering the tool takes time, and knowing the “tricks” to make it work takes practice.  Having been said, online resources can be very helpful to solve some problems you may be experiencing, but not all of them.

Juilien Hofstede has a blog entry about how to improve MySQL output for table output or update steps:

In his post, he recommends using the following options for your database connections:


While this will work nicely with native JDBC connections, it will not increase performance for JNDI connections.  For JNDI connections, you will need to code these options into the JNDI URL.  To do so, simply add these options to the jdbc url in your file like so:


This will ensure that these options are indeed used by your JNDI connections.


Leave a Reply

Fill in your details below or click an icon to log in: Logo

You are commenting using your account. Log Out /  Change )

Google+ photo

You are commenting using your Google+ account. Log Out /  Change )

Twitter picture

You are commenting using your Twitter account. Log Out /  Change )

Facebook photo

You are commenting using your Facebook account. Log Out /  Change )

Connecting to %s