Wednesday, April 21, 2010

Pentaho Community Data Access (CDA)

Pedro Alves did some impressive work on the new CDA (Community Data Access):
CDA allows you to access any of the various Pentaho data sources without worrying about the details. It can be used as a standalone plugin on the Pentaho BI server that can output the result in several formats or it can be used in combination with the Dashboard Editor and the CDF.
It basically covers any source that you can use within PRD (Pentaho Report Designer). Additionally it has a security layer that prevents code injection.
Moreover it has a caching layer (only Mondrian provides caching out of the box).
CDA also offers unions, joins (full outer join), column selection, formula additon and column renaming. Following output formats are available: JSON, XML, CSV and XSL.

CDA uses XML files to define the access data, which can be created/edited in the CDA Editor (The Editor doesn't work in IE). Results can be previewed via the CDA Previewer.

A CDA file consists two parts: the connection details and the query itself.
By using JNDI you can use the connections that you set up on the Pentaho Admin Panel.

CDA can be used then as input for the Dashboard Editor.
For all charts that are displayed within the CDA plugin pages, CDF is actually called to generate them.

Pedro is working on releasing a new version on CDF with CDA completely integrated.

Watch the webcast on for more details.

Thursday, April 15, 2010

Review coming for "Pentaho 3.2 Data Integration: Beginner's Guide"


I am quite excited to let you know that Packt will kindly send me a copy of their new book "Pentaho 3.2 Data Integration: Beginner's Guide" (by María Carina Roldán) to review it. I should have it in my post box in the next few days and then I'll focus on it. So stay tuned!


Wednesday, April 14, 2010

New books on Pentaho Data Integration (Kettle)

Good news for everybody who wants to get started with Pentaho Data Integration: 2 books are in the pipeline.
The first one "Pentaho 3.2 Data Integration: Beginner's Guide" by María Carina Roldán will be published in the next few days. I'll try to get a copy of it. The TOC promises a quite interesting book!
Later this year "Pentaho Kettle Solutions" will be available. This books will be based on the forthcoming PDI 4. It's written by the same team (Roland Bouman, Jos van Dongen) that brought you the excellent "Pentaho Solutions".