Search code examples
javajavascriptpentahokettle

Execute .jar file in Spoon (Pentaho Kettle)

I need to execute a java jar file from Spoon.

The program has only one class, and all I want is to run it with or without parameters.

The class is named "Limpieza", and is inside a package named:

com.overflow.csv.clean

I have deploy the jar to:

C:\Program Files (x86)\Kettle\data-integration\lib

And from a Modified JavaScriptValue step, I am calling it this way:

var jar = com.everis.csv.clean.Limpieza;

This is not working at all, is there a way around to make it work? Also would be nice to have a way to see the logs printed by the program when it runs. I am not getting any error when I run the transformation.

Thanks.

Solution

  • Check the blog below:

    https://anotherreeshu.wordpress.com/2015/02/07/using-external-jars-import-in-pentaho-data-integration/

    Hope this might help :)