Bizcubed Blog

Andrew Cave

Recent Posts

Spoon: What ETLs are using this connection?

The week before last I delivered the Pentaho DI1000 training to a group to our North Sydney office and I got asked a question that (it turned out) had an easy answer. And as with a lot of things, I hadn’t read it, somebody had told me.

read more

SFTP Algorithm Negotiation Fail with JSch and Pentaho Spoon/Kettle

Pentaho offers a step that handles the process of connecting to an SFTP server and putting and getting files, and (as always) orchestrating the steps leading up to and after the file transfer.  The step relies on the Java implementation of the SSH2 connectors done by the good folk at JCRAFT ( ) and uses the underlying Java policy files.  However, due to US export ...

read more

Changing the Spoon shortcut keys

As a programmer (and the lonely Windows hold-out at Bizcubed), I have a strong habit of hitting ctrl+s to save whatever I am working on, early and often.  As a wobbly typist, I also have a tendency to sometimes clip the wrong key.  So what's next to the 'S'?   The 'D' key.  And what does ctrl+d do in Spoon in versions 5 and 6?  Close the repository immediately without saving your work and ...

read more

Setting up a Pentaho server as a Windows service

1. Download the 64-bit version of Apache Tomcat that matches the Apache Tomcat version that was bundled with the PDI Server

read more