Inicio con pentaho 3.5

Getting Started

Installing and Configuring Java

The Pentaho BI Platform requires a JVM (Java Virtual Machine) to be installed on your PC or server. To check if Java is already installed issue the following command (seen in bold) at the command prompt:

C:\>java -version
java version "1.6.0_13"
Java(TM) SE Runtime Environment (build 1.6.0_13-b03)
Java HotSpot(TM) Client VM (build11.3-b02, mixed mode, sharing)

If a similar output (seen above) is displayed Java is already installed. If not, to install Java on Windows you will need to download the Java installation file from the Sun Developer Network downloads page.

The next step is to check if the JAVA_HOME environment variable is setup correctly, issue the following command (seen in bold) at the command prompt:

C:\>echo%JAVA_HOME%
C:\Program Files\Java\jdk1.6.0_13

If a similar output (seen above) is displayed the JAVA_HOME environment variable is already setup. To setup the JAVA_HOME environment variable right click on My Computer and click the Properties option then the Advanced tab and click the Environment Variables button.

[pic]

Depending on your setup (User variables or System variables)click onthe New button to create a new Environment Variable (in this guide I will be adding them for the user). For the variable name enter JAVA_HOME and for the variable value find the location of your Java installation in this example it is c:\Program Files\Java\jdk1.6.0_13:

[pic]

The CATALINA_OPTS environment variable should also be set to tell the Apache-Tomcat server to use more than thedefault memory, to do this follow the same steps from above but this time make sure you set the variable name to CATALINA_OPTS and the variable value to -Xms256m -Xmx768m -XX:MaxPermSize=256m -Dsun.rmi.dgc.client.gcInterval=3600000 -Dsun.rmi.dgc.server.gcInterval=3600000:

[pic]

From now on every time the PC or server is started/restarted the JAVA_HOME and CATALINA_OPTS environment variables willbe set automatically.

Installing and Configuring MySQL 5.x Server

Click here for a Windows guide.

Deploying the Platform

You are able to deploy the platform in many different ways but in this guide I will explain how to deploy it with the packaged Apache-Tomcat server (comes with the Pentaho BI Server installation file) or with an existing Apache-Tomcat server.

Packaged Apache-TomcatServer

You will need to first download the pentaho-ce-3.5.x.stable.zip file from the Pentaho Sourceforge projects page - this file contains all the files/packages needed for setting up our platform. After downloading extract its contents into a folder you would like to store the Pentaho BI Server - in this example I have chosen c:\pentaho\.

Use 7-Zip to extract the file contents toC:\pentaho\ folder.

The following folders should be visible after you have extracted the ZIP file:

C:\
|-- pentaho
|    |-- adminstration-console
|    |-- biserver-ce

Existing Apache-Tomcat Server

If you would like to deploy the Pentaho BI Platform on an existing Apache-Tomcat server first extract the contents of the pentaho-ce-3.5.x.stable.zip file found on the Pentaho Sourceforge projectspage. After downloading extract its contents into a folder you would like to store the Pentaho BI Server - in this example I have chosen c:\pentaho\

Use 7-Zip to extract the file contents to C:\pentaho\ folder.

The following folders should be visible after you have extracted the ZIP file:

C:\
|-- pentaho
|    |-- adminstration-console
|    |-- biserver-ce
|        |--pentaho-solutions
|        |-- tomcat
|            |-- common
|                `-- lib
|                    `-- mysql-connector-java-5.0.7.jar (optional)
|            |-- webapps
|                 `-- pentaho
|                 `-- pentaho-styles
|                 `-- sw-styles

The files and folders in bold (seen above) will need to be moved to your existing Apache-Tomcat installation.

MySQL Java...