PDA

View Full Version : ETL/Reporting deathmatch



MattCasters
02-06-2007, 05:50 PM
To bring new life to the eternal ETL vs. Reporting deathmatch, Thomas Morgner (lead developer for Pentaho Reporting (http://reporting.pentaho.org)) and myself wrote a plugin for Kettle (http://kettle.pentaho.org) to drive the shiny new reporting engine that is being developed. It seems that each time we meet for a short while, some code is being written. http://www.ibridge.be/wp-includes/images/smilies/icon_smile.gif
The new engine works a lot like a HTML/CSS processor and is one of the really cool new things on the block. I’m sure you will hear a lot more about it once it’s actually finished.
This is what the plugin looks like:
http://www.kettle.be/images/pentaho-reporting-plugin.png
I dumped the source code into subversion over on Javaforge (http://www.javaforge.com/proj/summary.do?proj_id=1402) for the time being.
Subversion checkout is at URL: http://svn.javaforge.com/svn/PentahoReportingPlugin/trunk , username: Anonymous , password: anon
If you want to join the coding effort, let me know and I’ll give you subversion write access. A binary version of the first plugin draft can be found over here (http://www.javaforge.com/displayDocument/PentahoReporting.zip?doc_id=27480). Download the zip file and unzip it in the plugins/steps/ directory of your 2.4.0 Kettle distribution. Restart Spoon and you’re set.
The easiest way to get started is by using the included “auto-start.xml” report definition. You can simply send some rows to the plugin and it will generate a (one-page) report from it. PDF seems to work already, the rest I’m told is a bit shaky.
NOTE: This is not production grade software and for sure a lot of functionality is still missing. However, consider helping us make this better http://www.ibridge.be/wp-includes/images/smilies/icon_wink.gif That way, when the new Pentaho Reporting engine is ready, this plugin will also be ready.

Whatever the case, soon the questions with regard to “PDF Output”, “Excel Output”, etc. will all be gone. Then you can create documents in whatever layout you want.
Until next time,
Matt


More... (http://www.ibridge.be/?p=31)