Exploring the sample plugins for PDI

rolling_plugins

Dear Kettle enthusiasts,

this is just a short blog post to point out that there are some new development resources available: Pentaho has added several sample plugins for PDI to the public CI-Server. If you ever wondered how to create your own plugins for PDI, check out the samples! . . . → Read More: Exploring the sample plugins for PDI

Releasing Edi2Xml plugin for PDI

edi

In this post I would like to announce the release of the Edi2Xml PDI plugin. It will convert a string field with edifact data to an XML text, with one tag per segment, containing the fields and values as child tags. This makes the edifact data more accessible, as the XML can be queried using the . . . → Read More: Releasing Edi2Xml plugin for PDI

Releasing the Ruby Scripting Step for Kettle

ruby_featured_image

In this post I would like to announce the release of the Ruby Scripting Step v1.0 for the community edition of Kettle 4.x. Grab it from the downloads section of the github page.

The plugin allows to easily put ruby into your ETL. It is bundled with many samples so it should be easy to get . . . → Read More: Releasing the Ruby Scripting Step for Kettle

Releasing Excel Writer Plugin for Kettle

excel_screen

In this post I would like to announce the release of my Excel Writer Plugin for Kettle 3.2.x and 4.0.x, 4.1.x Grab it at the Excel Writer Plugin page.

The plugin allows to easily write and modify Excel files in xls and xlsx format based on template files. . . . → Read More: Releasing Excel Writer Plugin for Kettle

Updated Open Source Google Analytics Plugin for Kettle

Based on the feedback I got from the Kettle community, I updated the google analytics plugin step to include a preview button and the possibility to define a limit for the rows it will produce. The new version is entirely backwards compatible, all you need to do is to replace the old plugin folder with the . . . → Read More: Updated Open Source Google Analytics Plugin for Kettle

Releasing Open Source Google Analytics Plugin for Kettle

ga_plugin_screenshot

In this post I would like to announce the release of my Google Analytics Plugin for the community editions of Kettle 3.2.x and 4.0.x. Grab it at the Google Analytics Plugin page.

The plugin allows to easily fetch data from Google Analytics using their Export API.

Give it a try and let me know what you think. . . . → Read More: Releasing Open Source Google Analytics Plugin for Kettle

Developing a Custom Kettle Plugin: Triggering a Report on JasperServer

screenshot-job

The previous posts on Kettle plugin development focus on transformation steps. It is also possible to extend Kettle with custom job entries. This post introduces a plugin that provides a job entry which can trigger a report on JasperServer 3.7 Community Edition. Scheduling reports can be a tricky thing. If you keep your reports on JasperServer, . . . → Read More: Developing a Custom Kettle Plugin: Triggering a Report on JasperServer

Developing a custom Kettle Plugin: Looking up values in Voldemort

hashing icon

This post is meant to be a tutorial for any Java developer who wants to extend Pentaho Kettle with custom plugins. It explains the code of a custom plugin for Pentaho Kettle 4.0. The plugin discussed in this article provides a custom transformation step that is looking up values in the Voldemort key-value store. . . . → Read More: Developing a custom Kettle Plugin: Looking up values in Voldemort

Developing a custom Kettle Plugin: A Simple Transformation Step

screen shot template plugin

This article shows how to develop a simple plugin which provides a custom transformation step for Kettle 4.0. The transformation step should accept any row stream and append a string field at the end, filling it with a fixed value. The user should be able to define the name of the added field. For starters, that should be enough. Keeping the step functionality at a minimum allows me to explain how the plugin interfaces with Kettle with as little distraction as possible. . . . → Read More: Developing a custom Kettle Plugin: A Simple Transformation Step