Introduction to Pentaho CDE
This is our first blog to Pentaho CDE series.
Here, we will walk-you-through the introduction and installation of Pentaho CDE.
At First, we need to know what is Pentaho? To answer this in short, it is “A Comprehensive Platform for data Integration & Business Analytics. It provides data integration, OLAP services, reporting, dash boarding, data mining and ETL capabilities.”
Pentaho is widely used to deal with Data Integration, Business Analytics and Big Data.
Business analytics (BA) refers to the skills, technologies, practices for continuous iterative exploration and investigation of past business performance to gain insight and drive business planning. (wikipedia)
Now let us quickly move on to Pentaho CDE – it takes care of the dashboarding part of this business analytics. Pentaho CDE comes under CTools (Community Tools) which is managed by Webdetails – A pentaho company. CTools is Open Source and free to use. CTools Dashboards render perfectly on traditional desktop devices, mobile and large formats. There are many tools under CTools, CDE is our topic of discussion right now. We would explore more tools in our forthcoming blogs.
Community Dashboard Editor is a graphical tool for creating, editing and previewing Pentaho Dashboards.
Let’s start with Pentaho Installation.
We have used the below environment for the blog series:
- Windows 8.1
- Java JDK 1.7
- Pentaho BA server 5.0.1
Pre-requisites: You need to have Java JDK 1.7 installed.
You can download the Pentaho BA server from the below link: http://sourceforge.net/projects/pentaho/files/Business%20Intelligence%20Server/5.1/biserver-ce-22.214.171.124-752.zip/download
Unzip the file after download. Place the unzip folder at your desired location. For eg: c:\pentaho
You need to set up JAVA_HOME variable as per your Operating system. Eg: for windows , you need to add these variables in the environment variables.
Go to bisserver-ce (unzipped folder)
For Windows, click on start-pentaho (windows batch file) and for Ubuntu use start-pentaho.sh
Go to any web browser. Preferably chrome or Firefox. Type localhost:8080
username : admin password: password.
The welcome page of pentaho looks as shown in the snapshot below:
àPentaho CDE is not installed in the default package of pentaho. To install CDE, we need to go to Pentaho Marketplace as shown below:
Click on Home. You would get a drop down.
Click on Marketplace.
Install CDE-Community Dashboard Editor. You would need to restart Pentaho BA server to reflect the changes.
To restart, go the biserver-ce folder, run the stop-pentaho (windows batch file) for windows and stop-penthouse for Ubuntu. Then start the server again as we had done initially.
Go to localhost:8080, login as you did earlier. At the welcome screen, click on CREATE NEW. You will be able to see CDE Dashboard option.
In this blog, we introduced Pentaho CDE and followed the installation. In the next blog we would understand the perspectives of CDE.
By Alen Frentz