05 Dec

How to install Pentaho Data Integration 7 (aka Kettle)

Few weeks ago, close to the annual Pentaho Community Meeting, the Pentaho Team released the brand new Pentaho Suite v7 with a complete restyle of the layout (of course, this is only one of the improvements). This a good opportunity for me to update the step by step tutorial on how to install the Pentaho Data Integration (aka Kettle) after the one about the past version 5.

Read More

13 Oct

How to install Alfresco 5.0.a Community Edition on Ubuntu 14.04 LTS

alfresco logoAfter the development of my most viewed post sharing how to install Alfresco 4.2.c on Ubuntu 10.04 LTS (more than 35.000 views) and Windows Server 2008 R2 (more that 13.000 views), it’s time to update the tutorial to the newest major version of Alfresco: Alfresco Community Edition 5.0.a. Even if the 5-th version is quite different from the 4-th version, the installation process is more or less the same… but let’s describe exactly the differences. The operating system choosen for the tutorial is Ubuntu 14.04.01 LTS.

Differently from the other post, the tutorial is separated in two parts: the installation of the dependencies and the Alfresco installation. As we like and prefer, the installation is a step by step list of commands and tasks: simpler to understand, to do and to test. Hope you’ll be agree.

Read More

22 Apr

ffmpeg for Ubuntu 14.04 LTS (mandatory for Alfresco)

ffmpegIn a past tutorial (one of the most accessed post of the blog) I shared a step by step tutorial describing the installation of Alfresco using an more controlled and “enterprise” approach respect to the bundle. The tutorial referrers to Alfresco Community Edition 4.2.c on Ubuntu 12.04 LTS and few days ago has been released the brand new Ubuntu 14.04 LTS Operating System.

Installing Alfresco as usual, I have found the FFmpeg is not included in the Ubuntu repositories and it has been replaced by libav (an ffmpeg fork of the project). For further details, you can read something here:

http://askubuntu.com/questions/432542/is-ffmpeg-missing-from-the-official-repositories-in-14-04

Waiting for an official answer from Alfresco, I found how to solve the problem. In particular, how to install ffmpeg on Ubuntu 14.04 LTS that is mandatory to make Alfresco works.

Other instructions on how to install Alfresco 4.2.f on Ubuntu 14.04 LTS are similar to the tutorial, so I don’t want to repeat them here (probably I’ll refresh the post in the future).

Coming to the solution…

To install ffmpeg on Ubuntu 14.04 LTS you have simply to open a terminal and execute the commands described below.

sudo apt-add-repository ppa:mc3man/trusty-media
sudo apt-get update
sudo apt-get install ffmpeg gstreamer0.10-ffmpeg

I hope this information will help you to install Alfresco with success in your environment. 😉

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. 😉

14 Nov

Alfresco Audit Analysis and Reporting installer

Do you want try the A.A.A.R. solution but you think the installation process it’s a little bit tricky?

Are you wondering an easy wizard with a few-click process without the need of technical skills?

Do you want to see the A.A.A.R. solution immediately in action with sample data inside?

pentaho-logoStarting from now I plan to work on that task. In particular, I would like to explicitly thank Pedro Alves of the Pentaho team for the suggestions and strategy, making what is going to be, really simple to install and easy to use in few minutes of your (precious) time.

A.A.A.R.

To be a little bit more clear, I’m going to release the A.A.A.R. solution in the Pentaho Marketplace with a Sparkl integration. This means that the Alfresco analytics will be available with an automatic installation procedure that will not require technical skills. Want to know more technical details? Take a look here.

In particular the process will be:
1) Install the Penthaho Suite.
2) Install A.A.A.R. from the marketplace.
3) Next, next, next… and enjoy!

Some of you are asking me about the release of the A.A.A.R. Analytics.
I plan to release it under this new installation package so, please, a little bit of patience and stay tuned. 😉

Thanks for the comprehension.