Repository files navigation

An plugin for Pentaho kettle (PDI) allowing to include ruby scripts as transformation steps.

The elegance of the ruby language is paired with ultimate row processing flexibility. The step allows scripts to read, write, aggregate, consume and redirect rows to accomplish the most complex of data processing tasks in one place.

The implementation is based onJRuby. Thanks to JRuby's great Java interop, the scripting step also enables easy Java scripting in kettle.

The plugin works with Kettle versions 5.x - 8.x.

Grab the latest release from thereleases page.You can also get the plugin zip as a maven dependency frommaven central.

Decompress the release zip to<kettle-dir>/plugins and restart Spoon. The "Ruby Script" step will appear in the "Scripting" section of a transformation.

The ruby scripting step comes with a lot of samples. You can access them by opening a ruby step dialog and exploring the samples section on the left.

• rows are represented as hashes, indexed by field name
• automatic conversion between all kettle data types and ruby types
• steps with no input can be used as row generators
• can redirect rows to an error handling stream
• can read from specific info steps
• can write to specific target steps
• can call your favorite Java libraries
• can use ruby gems
• kettle's step$step and transformation$trans objects are available in ruby scope for advanced scripting

Just openissues on github.

You can use gems, see theRuby gems article on the project wiki. As long asJRuby likes the gem, which usually means that the gem has no unsupported native bindings, you may use gems as with any other ruby program.

mvn clean package

It creates the plugin zip intarget/ruby-for-pentaho-kettle-{version}-plugin.zip.

Create a package, then run the tests. The packaging process unzips the plugin intotarget/ruby-for-pentaho-kettle, whichenables kettle to find the plugin when running integration tests.

mvn clean packagemvn -DskipTests=falsetest

If you'd like to contribute please fork the project, add the feature or bugfix and send a pull request. If your change majorly alters the way the plugin works, we should discuss it via an open issue first.

The ruby-for-pentaho-kettle plugin uses theLGPL 2.1 license.

Open source does not mean you're on your own. The ruby-for-pentaho-kettle plugin is developed byTwineworks GmbH. Twineworks offers commercial support and consulting services.Contact us if you'd like us to help with a project.