Pentaho

Install Prerequisities

  1. Install Java JDK 6.0 update 26 on Ubuntu 12.04 LTS
  2. Install MySQL

Install Pentaho

BI Platform

  1. Install Pentaho BI Server 4.5 on Ubuntu 12.04 LTS Desktop
  2. Install Pentaho Design Studio 4.0 on Ubuntu 12.04 LTS Desktop
  3. Install Pentaho Metadata Editor (PME) 4.5.0 on Ubuntu 12.04 LTS

ETL – Kettle – Pentaho Data Integration (PDI)

  1. Install Kettle 4.3.0 on Ubuntu 12.04 LTS
  2. Create a Kettle repository
  3. Install the sample MySQL Sakila database
  4. Create a DB connection to MySQL in Kettle

Analysis Services – Mondrian

  1. Install Pentaho Analysis Services (Mondrian) 3.4.1 with MySQL on Ubuntu 12.04 LTS

Configure Pentaho

BI Server

2 Comments

  1. Dear akbar,

    how to create the dynamic reports in pentaho??(i.e., to change the contents of a database through pentaho reports….

    thanks in advance…

    Reply

Leave a Reply

Fill in your details below or click an icon to log in:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out / Change )

Twitter picture

You are commenting using your Twitter account. Log Out / Change )

Facebook photo

You are commenting using your Facebook account. Log Out / Change )

Google+ photo

You are commenting using your Google+ account. Log Out / Change )

Connecting to %s