Tip : Install mysql driver in Pentaho Data Integration (Kettle)

1) Download mysql-connector-java-gpl-5.1.35.msi from

2) Execute the .msi file. (As soon as you click on run button it executes and disappears).

3) It'll create MySQL folder inside "Program Files(x86)". (Not the "Program Files")

Go to below location "C:\Program Files (x86)\MySQL\Connector.J 5.1" and find

the "mysql-connector-java-5.1.35-bin.jar" file.

4) Copy this driver to lib folder of kettle .

i.e.,. copy driver in : pdi-ce-5.4.0.0-128\data-integration\lib

5) Start PDI and try giving connection to a mysql database .

Example :

Resources :

1) http://stackoverflow.com/questions/18894416/install-mysql-jdbc-driver-msi

Pages