Pentaho in a Virtual Machine

We have prepared virtual servers with a preconfigured installation of Pentaho, the well-known open source platform for Business Intelligence (BI Pentaho PCI).
You can freely download a virtual machine ready with the virtualization software VirtualBox 2.0 Sun, and another with VM 2.0 server software:

Download Image Virtual Pentaho Downloading virtual machine for Virtual Box
Download Image Virtual Pentaho Downloading virtual machine for VMware
(Patience with the download, the files are very large)

 

The Pentaho Installation

This is an installation of Pentaho BI Suite PCI, with Pentaho preconfigured with version 1.7 GA (stable) from the suite, and with a database Hypersonic (HSQLDB) operational, with test data to run reports and 'applications' you have at the portal of example available when the server starts.

You can use this facility to test the platform on your own machine / server exploring the options of the portal, or even as a base to build you own BI system with Pentaho.

You just have to create a new virtual machine with virtualization software and make it boot from the downloaded files.
Enter to the system with the user dataprix, password dataprix.

On boot the machine raise the BI server automatically, so all we have to do is to open Firefox, which have Pentaho local portal as home page. Portal users already have the password entered, so with only two clicks we can begin to explore the reports.

Pentaho running on CentOS on VirtualBox

However, we indicate how to stop and start the server in case anyone wants to do it manually:

To start:

  1. Double-click the desktop icon Terminal
  2. In the terminal window run the following commands:
    $ dd pentaho-demo (the demo directory)
    $ ./start-pentaho.sh (shell to boot the platform)
  3. Wait for the terminal message Pentaho BI server ready
  4. Open Firefox browser (icon next to menu system)
    Url to access the portal is http://localhost:8080/pentaho

To stop Pentaho server, opening another terminal:

$ cd pentaho-demo
$ ./stop-pentaho.sh 

 

Virtualization Tools

VirtualBox

Virtual Box is available for Linux, OS X (Mac) and Windows, and has a free edition of evaluation and personal use, and another Open Source subject to the terms of the GPL. In this way our image may be used freely in any environment, provided to licence conditions.

It is easy to install, and its operation is very intuitive, but I attach the user manual for anyone who don't know the tool, or want to use advanced options.
In order to use our virtual server you can follow these steps:

  1. Install VirtualBox
  2. Download the virtual disk from Download Image Virtual PentahoPentaho VirtualBox virtual image
  3. Unzip it in the directory of VirtualBox virtual disks, usually called VDI
  4. Run VirtualBox and create a new machine with the wizard, choosing the type of Operating System Red Hat, 512 MB of memory (this is a suggestion), and downloaded as a virtual disk bootable disk.
  5. Booting the machine by double-clicking on it.

Thanks to Oscar Osta for preparing the virtual image with CentOS.

VMware

Surely is the most widely used virtualization software, and also have versions that can be used freely, though not for all operating systems. Because there are several products that enable working with our VMWare virtual machine (VMware Player, VMware Server, VMware Infrastructure ..), refer to the website of WMware to download any of them or read the documentation.

However, with most of these products the steps are very similar:

  1. Installing a product that allows to boot VMWare virtual machines
  2. Download the virtual machine from Download Image Virtual Pentaho VMware virtual image Pentaho
  3. Unzip into the VMware virtual disk .., normally My virtual machines, in the user document folder.
  4. Run VMware.. and add a new machine to the inventory of downloaded files by selecting the .vmx extension.
  5. Boot the machine by double-clicking on it.

 

The Operating System

CentOS 5 is the Operating System we have choose as a base for the installation of Pentaho. The reasons have to do with the use can be given to this image. This OS is based on the Open Source Code used by Red Hat Enterprise Linux and for practical purposes, works the same way that this Enterprise version of Linux, and is also geared to corporate use, but it's totally under free distribution. It coul'd be used even in a production environment, and most of the RedHat documentation and practices are applicable to CentOS.

We have created the user dataprix. The password for this user and also for root user is dataprix.

CentOS installed on VirtualBox

 

This is the most basic installation of Pentaho, which is configured to operate in localhost and with an Hypersonic database, perfect for evaluating the potential of this Open Source Business Intelligence Software, or for a simple first contact without complications. It also serves as a basis for preparing more complex things, and I hope in future be able to expand this virtual machine with new features, configurations, testing or interesting demos.

If someone uses this image as a basis for doing something interesting, we appreciate if you tell us, or contact us if you want we host your 'release'. Any comments, questions, ideas or suggestions are welcome in our forum on the topic Virtual Image with Pentaho.

AttachmentSize
VirtualBoxUserManual.pdf4.41 MB
Average: 5 (1 vote)
Admin console password by Anonimo (not verified)
WOrks only on User Console by Anonimo (not verified)
how do we fix the path? by Anonimo (not verified)
 I fixed this by renaming an by Anonimo (not verified)
I have the same problem. I by mfserrano (not verified)
Virtualbox requires APIC by Yevgen (not verified)

Post new comment

The content of this field is kept private and will not be shown publicly.

More information about formatting options

By submitting this form, you accept the Mollom privacy policy.