Install Guide for Kettle/Pentaho Data Integration 4.4 (Community Edition) with MySQL on Windows

For details about MySQL setup you can refer to my earlier entry on setting up the Pentaho BI Server on this blog.

File Descriptions

Under http://sourceforge.net/projects/pentaho/files/Data%20Integration/4.4.0-stable/pdi-ce-4.4.0-stable.zip/download/
  • Download and unzip pdi-ce-4.4.0-stable.zip to c:\pentaho\data-integration\
  • Download and copy the JDBC Connector to C:\pentaho\data-integration\libext\JDBC\

Starting the Server/Carte

  • Kettle has a 2-tier architecture where the client (Spoon) connects directly to the repository
  • The server is really a lightweight process for remote execution. You can kick off remote jobs either through the web interface or from Spoon which sends commands to the remote host over HTTP
  • To launch the Carte server you run the C:\pentaho\data-integration\Carte.bat script. You need to pass it the IP Address and the port number you'd like it to run on (passing it localhost won't work) -
C:\pentaho\data-integration\Carte.bat 127.0.0.1 8081  

Repository Setup

  • Go into the MySQL Workbench and create a database and a user called kettle
  • Grant the user appropriate schema rights on the database
  • Launch C:\pentaho\data-integration\Spoon.bat
  • You'll be prompted for a Repository Connection
  • Click the little green icon with the '+' in the top right corner to add a new connection
  • You will be prompted to select a Repository type. Select 'Kettle database repository' and click 'OK'
  • You'll be prompted to enter Repository information. Click on 'New'
  • You'll be presented with a Database Connection dialog. Use the following values (I'm assuming that MySQL is installed on the same host)
    • Connection Name: Pentaho MySQL
    • Connection Type: MySQL
    • Access: Native (JDBC)
    • Host Name: localhost
    • Database name: kettle
    • Port Number: 3306
    • User Name: kettle
    • Password: ****
  • Click on 'Test' and you should get a dialog that says Connection to [Pentaho MySQL] is OK
  • This will bring you back to the 'Repository Information' dialog
  • Enter your userid and password (kettle/****) and click on 'Create or Upgrade'
  • You'll be prompted to review the SQL generated. Go ahead and execute it. The Kettle Repository has now been created
  • You will now be presented with the login dialog with the 'kettle' repository highlighted
  • The Admin user is call 'Admin' and the default password is 'admin'
  • Select Tools -> Repository -> Explore... to invoke the Repository Explorer. This is where you administer the Repository from
  • Repository and other config files are stored under c:\Users\\.kettle\ (Note:there is a leading dot before kettle)

Comments

Post a Comment

Popular posts from this blog

The Forecaster Brown Fan Club

I spent the last couple of weeks in October watching what could only be described as the Idiot's Guide to the Wikipedia entry on Hurricane Sandy, otherwise known as the Weather Channel (it was the only live channel I could find online). Half of it involved presenters with an emotional age of 14 trying to get as close to the storm surge as they could, while Dr. Thang in Atlanta helpfully pointed out the eye of the storm every so often. It left me wondering why India had fought so hard for a Cray XMP-24 all those decades ago when all they needed was a helicopter, a doppler, a satellite photo and a half-crazed adolescent with a death-wish. Then I came across this page written by the imaginately named 'Forecaster Brown'. The post, dated ' 1100 AM EDT SAT OCT 27 2012 ' begins " NOAA AND AIR FORCE RESERVE HURRICANE HUNTER AIRCRAFT HAVE BEEN  SAMPLING THE CYCLONE THIS MORNING. "  It turns out the NOAA (National Oceanic and Atmospheric Administ
Read more

How to Create a Pentaho Report Using the REST Client

Image
Prerequisites Pentaho Kettle (see earlier blog post) Pentaho Report Designer You will get an error message in Pentaho Report Designer that says ' java.lang.NoClassDefFoundErr: com/sun/jersey/api/client/ClientConfig ' if you try to run a report against the Kettle job. To fix this error copy the following files from  C:\pentaho\data-integration\libext\jersey\ to C:\pentaho\prd-ce-3.9.1-GA\report-designer\lib\. If you plan to ublish the report to the BI Server, also copy these files to C:\pentaho\biserver-ce\tomcat\webapps\pentaho\WEB-INF\lib\ as well - jersey-apache-client-1.7.jar jersey-client-1.7.jar jersey-core-1.7.jar The Payload My example returns an array of objects [   {       "id":"1",       "name":"item1",       "description":"someDescription1"   },   {       "id":"2",       "name":"item2",       "de
Read more

Automated Testing with vncdotool (Not Headless, but Hairless)

Image
The headless testing problem is a thorny one and impacts the fundamental architecture of the test automation platform I'm working on. If we can't find a solution, we might not be able to use the private cloud nor parallelize our testing effectively. Part of the problem are the tests themselves that still rely on SendKeys() and MouseMove(). Two aspects of remote interaction that are insecure and therefore disallowed by Microsoft from Windows Vista onwards. This means that we have to rely on hacks like the VIX API and the one that I am about to document below. There are two widely-used technologies for remote interactive connectivity on the Windows platform - the Remote Desktop Client (RDC) and VNC. The first is entirely proprietary while the second offers a number of open-source implementations (and some proprietary, full-featured, commercial implementations). The RDC implementation requires access to the VIX API which in turn relies on proprietary, privileged access t
Read more