Pentaho

Installing Pentaho

Install Pentaho Server

Common Issues

Missing MySQL Library File

Reference: http://stackoverflow.com/questions/11634181/pentaho-data-integration-sql-connection

  1. Download the Latest MySQL Java Connector / Driver
  2. Unzip the zip file (in my case it was mysql-connector-java-5.1.29.zip)
  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