Jasperwave - the other JasperReports DesignerIt's always good when there is new competition on the field: Jasperwave is a recent project on creating a very user-friendly JasperReport Designer. Currently it is at version 0.9.2 and available both as Eclipse plug-in as well as standalone client from here.I have to say that for such an early version it is already a very impressive offering. All the basic functionality is covered, sub-reports are partially...

Read More

Jaspersoft iReport: How to pass a parameter to a sub-dataset

Jaspersoft iReport: How to pass a parameter to a sub-datasetLet’s say our main report is grouped by continent and the details band holds sales figures for each country. We would like to add now a pie chart to the group footer to visualize the share by product by continent. Imagine our main report query is:SELECT      product_sales.`continent` AS product_sales_continent,product_sales.`city` AS product_sales_city,     ...

Read More

Star Schema Modeling with Pentaho Data Integration

Star Schema Modeling with Pentaho Data IntegrationTutorial DetailsSoftware (this tutorial was published on 2011-11-04 and download sources were correct on this date but might change in future): Download the latest version of PDI which includes the Star Modeler plugin (download here). If you run pdi-ce-4.3.0-M1, you can download the Star Modeler plug-in from here. Ideally though, just download the latest version of PDI.MySQL or similar databaseStar...

Read More

Pentaho Data Integration 4 Cookbook - Book Review

Book Review: Pentaho Data Integration 4 CookbookPentaho Data Integration 4 Cookbook by María Carina Roldan and Adrián Sergio Pulvirenti illustrates with plenty examples how data can be imported from various sources, transformed and exported to various sources with the open source tool Kettle (Pentaho Data Integration). It's all a hands-down approach: Follow the step by step guide of the examples and you will have the right knowledge at the end of the book to create your own data integration solutions. The book is easy to read even for...

Read More

Metadata Driven ETL and Reporting

Metadata Driven ETL and Reporting with Pentaho Data Integration and Report DesignerTutorial Details Software: If PDI Kettle 4.2 GA and PRD 3.8.1 GA or later are available, download them from Sourceforge, otherwise here: PDI/Kettle 4.2 latest stable version and PRD 3.8.1 latest stable version (Note: Do not use these last stable versions in a production environment)Knowledge: Intermediate (To follow this tutorial you should have...

Read More