All posts tagged: Pentaho

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

comments 4
Pentaho

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 download Mondrian into. mkdir -p ~/Downloads/pentaho/analysis cd ~/Downloads/pentaho/analysis To download the Mondrian either run the following command, or follow the […]

Change the default port on Pentaho BI Server

Leave a comment
Pentaho

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 change the default port for Hadoop MapReduce ShuffleHandler. So this got me thinking about how to change the Pentaho BI […]

Create a Kettle repository

Leave a comment
Pentaho

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 OK In the File repository settings dialog box, enter the following information: Base directory: /home/akbar/kettle Read-only repository?: Leave unchecked Hide […]

Create a .bash_aliases file

comments 3
Hadoop / Linux / Pentaho

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 keep up with changes to the file. How to create a .bash_aliases file vi ~/.bash_aliases Paste the following into the […]

Install Kettle 4.3.0 on Ubuntu 12.04 LTS

comments 5
Pentaho

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 the bulleted steps below. wget http://downloads.sourceforge.net/project/pentaho/Data%20Integration/4.3.0-stable/pdi-ce-4.3.0-stable.tar.gz Or follow the steps below if you don’t want to use the wget command […]

Install Pentaho Metadata Editor (PME) 4.5.0 on Ubuntu 12.04 LTS

Leave a comment
Pentaho

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 use the wget command shown above. Download Pentaho Metadata Editor (PME) 4.5.0 from http://wiki.pentaho.com/display/COM/Latest+Stable+Builds. Click 4.5.0-stable. Click pme-ce-4.5.0-stable.tar.gz to download […]

Install Pentaho Design Studio 4.0 on Ubuntu 12.04 LTS Desktop

comments 2
Linux / Pentaho

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 steps below if you don’t want to use the wget command shown above. Open a web browser to http://wiki.pentaho.com/display/COM/Latest+Stable+Builds. Click […]

Install Pentaho BI Server 4.5 on Ubuntu 12.04 LTS Desktop

comments 17
Linux / Pentaho

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 --system --ingroup pentaho --disabled-login pentaho Install Java Follow the JDK installation instructions that are listed in the following post: Install […]

Install Pentaho BI Server 4.5 on Windows 7 x64

comments 30
Uncategorized

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 older version of the JDK installed. However, the gist is “just click Next till your done”. Download the Java JDK […]