Pentaho Tools :

Pentaho C-Tools(CDE,CDF,CDA),Pentaho CE & EE Server,OLAP-Cubes,Analysis using Pivot4J, Saiku Analytics, Saiku Reporting, Ad-hoc Reporting using Interactive Reporting Tool,Dashboards,Reports using PRD, PDD,Data Integration using Kettle ETL,Data Mining usign WEKA,Integration of Servers with Databases,Mobile/iPad compatible Dashboards using Bootstrap Css,Drilldown dashboards,Interactive Dashboards

Sunday, 14 June 2015

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