Thursday, September 26, 2013

How publish Saiku Analytics on OpenShift


Saiku Analytics is a great open source server or Pentaho plugin for explore and vizualize data!


About Saiku: "Saiku was founded in 2008 by Tom Barber and Paul Stoellberger. Originally called the Pentaho Analysis Tool, if started life as a basic GWT based wrapper around the OLAP4J library. Over the years it has evolved, and after a complete rewrite in 2010, it was reborn as Saiku.
Saiku offers a user friendly, web based analytics solution that lets users, quickly and easily analyse corporate data and create and share reports. The solution connects to a range of OLAP Servers including Mondrian, Microsoft Analysis Services, SAP BW and Oracle Hyperion and can be deployed rapidly and cost effectively to allow users to explore data in real time." - Meteorite

About OpenShift: "OpenShift is a cloud computing platform as a service product from Red Hat. A version for private cloud is named OpenShift Enterprise.
The software that runs the service is open-sourced under the name OpenShift Origin, and is available on GitHub. Developers can use Git to deploy web applications in different languages on the platform.
OpenShift also supports binary programs that are web applications, so long as they can run on Red Hat Enterprise Linux. This allows the use of arbitrary languages and frameworks. OpenShift takes care of maintaining the services underlying the application and scaling the application as needed." - Wikipedia


In this post I'll demonstrate how you can publish Saiku Analytics server on OpenShift platform using a free account that provide 1GB storage per gear. Using another words (commercial words) is put your business analytics on the sky (ok, on the cloud :) ) by free (or low cost depends of your bussiness).

After create your account on OpenShift website, you need install/configure OpenShift RHC Client Tools. I'll describe the steps for install and configure in Linux but you can follow the instructions on this link.
The steps on Linux Ubuntu are:
  1. sudo apt-get install ruby-full rubygems git-core
  2. sudo gem install rhc
  3. rhc setup (put your credentials)

The next step is create your application on OpenShift, you have three ways for do that. One using OpenShift website with your account (as I'll demonstrate), other way is using RHC client tool and the other using JBoss Developer Studio (you can find out more about those ways in this link).
The steps using website are:

  1. Click on ADD APPLICATION button;
  2. Choose which type application, in this case I choose Tomcat 6 (JBoss EWS 1.0);
  3. Write the application name, in this case I wrote "saiku".


The next step is download Saiku WAR's (UI and Backend) file to deploy on OpenShift. After that, you need do the following steps on your command line:

  1. rhc git-clone saiku
  2. cd saiku
  3. git rm -r src pom.xml
  4. cp <war-path-file>/saiku-ui-2.5.war webapps/ROOT.war
  5. cp <war-path-file>/saiku-webapp-2.5.war webapps/saiku.war
  6. git add .
  7. git commit -m 'Deploy Saiku 2.5'
  8. git push

And is done! You can check in your URL http://<application-name>-<username>.rhcloud.com. You should have something like: http://saiku-latinojoel.rhcloud.com/ .

Enjoy. ;)




Interested Links: