Introduction Pentaho Analysis Services is called Mondrian, which is the name I’ll use for the remainder of this post. Mondrian is Pentaho’s OLAP server. In this post I’ll provide step-by-step instructions on how to install Mondrian 3.4.1 Ubuntu Linux 12.04 LTS x64. We’ll use MySQL as the database. Download Let’s first create a directory to …
Introduction There are many reasons for changing the Pentaho BI Server’s default port, but one of the most common is a conflict with another server. I ran into this issue where both the Pentaho User Console and the Hadoop MapReduce ShuffleHandler were trying to use port 8080. I wrote an earlier article on how to …
Introduction Sakila is an example database for MySQL. It is often used for training purposes. Installation cd ~/Downloads wget http://downloads.mysql.com/docs/sakila-db.tar.gz tar -xzf sakila-db.tar.gz cd sakila-db mysql -u root -p < sakila-schema.sql mysql -u root -p < sakila-data.sql
Introduction Open Kettle cd ~/bin/data-integration To run Spoon: ./spoon.sh Create a new repository Run the following in a terminal. mkdir ~/kettle The steps below are performed within the PDI UI. In the Repository Connection dialog box, click the small green plus symbol. In the Select the repository type dialog box, select Kettle file repository. Click …
Introduction This is my personal .bash_aliases file that is mainly used for Cloudera CDH4 (Hadoop) and Pentaho. As a result, many of my aliases are specific to these software packages. I plan to update this post as my .bash_aliases file expands. I will also push my .bash_aliases file into Git to make it easier to …
Introduction Kettle is Pentaho’s ETL tool, which is also called Pentaho Data Integration (PDI). Installing Kettle is extremely simple. Install Java Follow the JDK installation instructions that are listed in the following post: Install Java JDK 6.0 update 31 on Ubuntu 12.04 LTS Download To download the Kettle either run the following command, or follow …
Introduction The instructions below assume that you’ve followed my prior blog posts on how to install Pentaho on Ubuntu Linux 12.04 LTS x64. Download To download the Pentaho Metadata Editor (PME) either run the following command, or follow the 3 bulleted steps below. wget http://downloads.sourceforge.net/project/pentaho/Pentaho%20Metadata/4.5.0-stable/pme-ce-4.5.0-stable.tar.gz Or follow the steps below if you don’t want to …
Introduction Pentaho Design Studio (PDS) is a BI plugin for Eclipse. I’m going to download the complete package as Pentaho was nice enough to integrate the plugin with Eclipse for us. Download To download the Pentaho Design Studio (PDS) either run the following command, or follow the bulleted steps below. wget http://downloads.sourceforge.net/project/pentaho/Design%20Studio/4.0.0-stable/pds-ce-linux-64-4.0.0-stable.tar.gz Or follow the …
Overview: What is Pentaho? Pentaho is an open source Business Intelligence (BI) Suite that comes in with either commercial support (http://www.pentaho.com/) and or community support (http://community.pentaho.com/). This post provides instructions for the Pentaho community edition suite. Create a pentaho user and group Open a terminal and run the following commands: sudo addgroup pentaho sudo adduser …
What is Pentaho Pentaho is an open source Business Intelligence (BI) Suite that comes in with either commercial support (http://www.pentaho.com/) and or community support (http://community.pentaho.com/). This post provides instructions for the Pentaho community edition suite. Install Pentaho BI Server 4.5 on Windows 7 x64 Install Java Your steps may vary slightly as I had an …
AkbarAhmed.com 