Pentaho Home

• Pentaho Data Integration prepares and blends data to create a complete picture of your business that drives actionable insights. 
• The platform delivers accurate, analytics-ready data to end users from any source. 
• With Pentaho visual tool you can eliminate coding and complexity, Pentaho puts big data and all data sources at the fingertips of business and IT users.

Or

• Pentaho builds open-source business intelligence (BI) tools for companies, and its data-integration toolset—also known as Kettle—has gained in popularity among tech pros who spend the majority of their time working on either data extraction or data warehousing.

Prerequistes :

• Before you start proceeding with this tutorial, we assume that you have prior exposure to Core Java, Database Concepts, and SQL Queries.

Set Environment Variables:

• Set the PENTAHO_JAVA_HOME variable to indicate the path to the Java JRE or JDK that Pentaho should use. 
• Also, set the PENTAHO_INSTALLED_LICENSE_PATH variable so that when you start Pentaho, the licenses can install. (Only for Enterprise Edition)

     Note:If you do not set these variables, Pentaho will not start correctly. To set environment variables, you should be logged into an account that has administrator-level privileges. For Linux systems, you must be logged into the root user account.


For Windows PENTAHO_JAVA_HOME and PENTAHO_INSTALLED_LICENSE_PATH
Variables

• Open a Command Prompt.
• At the prompt, set the path of the PENTAHO_JAVA_HOME variable to the path of your Java 7 installation. Here is an example.
• SET PENTAHO_JAVA_HOME=C:\Program Files\Java\jre7
• At the prompt, set the path of the PENTAHO_INSTALLED_LICENSE_PATH variable to point to .installedLicenses.xml.(Only for Enterprise Edition), Here is an example.
• SET PENTAHO_INSTALLED_LICENSE_PATH=C:\Users\goel\.pentaho\.installedLicenses.xml
• Log out, then log back in.
• To verify that the variable has been properly set, open a Command Prompt window, then type this.
• echo %PENTAHO_JAVA_HOME% %PENTAHO_INSTALLED_LICENSE_PATH%
• The paths for the variables should appear. If they do not, try to set the environment variables again.

For Linux PENTAHO_JAVA_HOME and PENTAHO_INSTALLED_LICENSE_PATH

Variables

• Open a terminal window and log in as root.
• Open the /etc/environment file with a text editor. 

     Note: The vi and gedit text editors are available on most Linux machines. For example, to open the /etc/environment file with gedit, type this.

• gedit /etc/environment
• Indicate where you installed Java in your /etc/environment file by typing this. 

     Note: Substitute /usr/lib/jvm/java-7-sun with the location of the JRE or JDK you installed on your system.

• Indicate the location of the .pentaho directory by typing this.
• export PENTAHO_INSTALLED_LICENSE_PATH=//.pentaho/.installedLicenses.xml
• Save and close the file.
• Log out, then log back in for the change to take effect.
• Verify that the variables are properly set by opening a Terminal window and typing this.
• env | grep PENTAHO_JAVA_HOME

Important Terms in Pentaho:

• Jackrabbit contains the solution respository, examples, security data, and content data from reports that you use Pentaho software to create.
• Quartz holds data that is related to scheduling reports and jobs.
• Hibernate holds data that is related to audit logging.