Installing Pentaho

Install Pentaho Server

Common Issues

Missing MySQL Library File


  1. Download the Latest MySQL Java Connector / Driver
  2. Unzip the zip file (in my case it was
  3. Copy the .jar file (mysql-connector-java-5.1.29-bin.jar) and paste it in your Lib folder: 

    PC: C:Program Filespentahodesign-toolsdata-integrationlib
    Mac: /Applications/data-integration/lib

  4. Restart Pentaho (Data Integration) and re-test the MySQL Connection.

Setting up SSL for Postgres

In Options, set the following parameters:
ssl = true
sslfactory = org.postgresql.ssl.NonValidatingFactory


Opinions about People, Process and Technology

Optimization WordPress Plugins & Solutions by W3 EDGE