AkbarAhmed.com

Engineering Leadership

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 …

Continue reading

Introduction Creating a DB connection from Kettle to MySQL involves creating a MySQL use who can access the DB in question, installing the JDBC driver, and creating a connection. Install the MySQL JDBC driver Download the MySQL JDBC driver from http://dev.mysql.com/downloads/connector/j/. Login to mysql.com, then click Download. cd ~/Downloads tar -xzf mysql-connector-java-5.1.20.tar.gz cd mysql-connector-java-5.1.20 cp …

Continue reading

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 …

Continue reading