847-505-9933 | +91 20 66446300 info@datametica.com

Pentaho CDE Series

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-5.1.0.0-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)

folders_img

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

pentaho_user

username : admin password: password.

The welcome page of pentaho looks as shown in the snapshot below:

pentaho_business

 

à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.

pentaho_business2

Click on Marketplace.

market_place

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.

ho_busibess

In this blog, we introduced Pentaho CDE and followed the installation. In the next blog we would understand the perspectives of CDE.

Happy Reading.

References:

1)      http://www.pentaho.com/

2)      http://www.webdetails.pt/

3)      Wikipedia

 

By Alen Frentz

Leave a Comment

POST COMMENT Back to Top
*
Contact Us

We're not around right now. But you can send us an email and we'll get back to you, asap.