27 Jan

Pentaho Reporting video course from Pack Publishing

pentaho_reporting_video_courseFinally the Pentaho Reporting video course has been released!

This is a complete video course mainly based on the Pentaho Reporting 3.5 for Java Developers book. The video course is composed by 8 different sectionsmore than 40 videos and has more than 1 hour and half of duration.

Packt Publishing

20 Jan

Pentaho Sparkl tutorial

pentaho-logoAfter the (very interesting) experience in developing the A.A.A.R. v2.0 in Pentaho marketplace, I had the opportunity to dive deep in the brand new tool of the Pentaho Suite family: Sparkl Application Builder.

I’m very impressed by the power of this module and working together with the Pentaho team (in particular with Webdetails) I learnt many technical things could be interesting to share. For that reason this tutorial is born.

Sparkl Application Builder tutorial

I hope to receive lot of feedback to make it grow but until then… kudos webdetails! (like Pentaho guys always says) 🙂

13 Jan

Alfresco Audit Analysis and Reporting version 2.0 in Pentaho Marketplace.

AAAR_for_marketplaceThe Alfresco Audit Analysis and Reporting has been released with a major version 2.0. What I enjoyed most developing this brand new version is to develop directly in the new Pentaho 5 Suite, using the new Sparkl Application Builder with the support of Webdetails. About this, I would like to explicitly thank Pedro Alves (SVP of Community for Pentaho) and Pedro Vale (Product Development Leader at Webdetails).

AAAR_marketplace_1

This new release contains lot of relevant improvements (link to change log) but the most important ones are:

The recent section of the Alfresco forum about Business Reporting is a good place to receive support from all the interested people about tuning, customizations and support in general. But if you ask you what to do for the project (and for you, by consequence) take a look here.

AAAR_marketplace_2

07 Jan

How to install Pentaho Business Analytics platform 5

In this tutorial we are going to see how to install Pentaho Business Analytics Platform 5. The so called Pentaho BI-Server 5 is the front-end tool of the Pentaho Suite that develop a pure (and complete) user interface to use all the different analytical tools developed by the Suite.

If you have a Linux based operating system or a Windows based platform, the tutorial should work in any case because, you will see, the steps are very simple and easy and not related on the platform.

This tutorial describes the default installation using the HSQL database for the security storage. If you want to know how to install it using MySql database instead, I suggest this tutorial made by David Fombella.

Prerequisites

Before start to install the Pentaho BI-Server 5 you have to check to have Java installed in you system. To check it, you have simply to execute the command below from a terminal.

java -version

If you don’t have it, below you can find a tutorial on how to install it. Please, remember that Pentaho BI-Server 5 requests Java7.

Download and install Pentaho Business Analytics Platform 5 Community Edition

After Java7 is available into your system, you have to download the Pentaho BI-Server 5 package from the official website or the sourceforge web page. In our case we are going to install the Pentaho Business Analytics 5 Community Edition.

Once the ‘biserver-ce-5.0.1-stable.zip’ file will be downloaded in the system, unzip it on the desktop or everywhere else you will like. All the Pentaho Business Analytics 5 tool is available in a folder described below:

biserver-ce

Probably you cannot believe me but this is enough to install Pentaho Business Analytics 5 into your system. 😉

First run and access to the user interface

Pentaho Business Analytics 5 is mainly a web application deployed in a tomcat servlet container. You can easily run the Pentaho Business Analytics 5, opening a terminal and executing the ‘start-pentaho’ script stored in the ‘biserver-ce’ folder (the one with the ‘sh’ extension for the Linux based operating systems and the one with the ‘bat’ extension for the Windows based operating systems).

To check what is happening to the web application, you can see at the log in the file described below.

<biserver-ce>/tomcat/logs/catalina.out

Once, the application is started, you can access to the user interface using a web browser at the link below.

http://<server>:8080/pentaho

With the Community Edition is suggested to use Mozilla Firefox or Google Chrome instead of MS IE Explorer (not well supported today).

To access as administrator you can use the ‘admin’ user with password ‘password’.

After the first run you are ready to use it.. for example with the A.A.A.R. solution. 😉

03 Jan

How to install Pentaho Data Integration 5 (aka Kettle)

In this tutorial we are going to see how to install Pentaho Data Integration 5. PDI 5 (called Kettle) is one of the most powerful tool of the Pentaho Suite that develop a pure (and complete) ETL tool. This tutorial is an extraction of the complete wiki section dedicated to this amazing tool.

If you have a Linux based operating system or a Windows based platform, the tutorial should work in any case because, you will see, the steps are very simple and easy and not related on the platform.

Prerequisites

Before start to install the PDI 5 (aka Kettle) you have to check to have Java installed in you system. To check it, you have simply to execute the command below from a terminal.

java -version

If you don’t have it, below you can find a tutorial on how to install it. Please, remember that PDI 5 requests Java7.

Download and install PDI 5 Community Edition

After Java7 is available into your system, you have to download the PDI 5 package from the official website or the sourceforge web page. In our case we are going to install the Pentaho Data Integration 5 Community Edition.

Once the ‘pdi-ce-5.0.1-stable.zip’ file will be downloaded in the system, unzip it on the desktop or everywhere else you will like. All the PDI 5 tool is available in a folder described below:

data-integration

Probably you cannot believe me but this is enough to install PDI 5 into your system. 😉

First run

PDI 5 tool is composed by different executables and services (Spoon, Kitchen, Pan) everyone designed for a specific purpose. To create all the configuration folders and files, you have to run the Spoon tool for the first time. Spoon is a graphical user interface that allows you to design transformations and jobs that can be run with the other Kettle tools (Pan and Kitchen). To run the spoon tool, follow the instructions described here.

After the first run you are ready to use it.. for example with the A.A.A.R. solution. 😉

02 Jan

Alfresco forum opens a new section dedicated to reporting and analytics

alfresco logoA new section dedicated to reporting and analytics on Alfresco has been opened in the Alfresco forum during last month. This is a request submitted from the users (bisana in particular) and accepted from the administrators (Mark Rogers in particular).

In my opinion this is a good news for the ones like me, that work specifically on that task. Last but not least, I submit to your attention the current topics of the brand new section:

https://forums.alfresco.com/forum/installation-upgrades-configuration-integration/business-reporting