###IT4biz Training

If you are here, it is because you want to learn more about Pentaho.

If so you will probably participate in a IT4biz course.

Here are the steps you need to follow to get ready to start the Training.

Download all the softwares and unzip them all in a folder called Pentaho

If you want to download the CE(Community Edition) please go direct to sourceforge.net instead of the website Pentaho.com.

Until today (May, 23, 2016) the last stable version of Pentaho is the 6.1.0.1-196 version.

Downloads Pentaho BI Suite CE (Community Edition)

Links Pentaho BA Suite:
http://sourceforge.net/projects/pentaho/

BI Server CE 6.1.0.1-196 Stable
https://sourceforge.net/projects/pentaho/files/Business%20Intelligence%20Server/6.1/biserver-ce-6.1.0.1-196.zip/download

PDI 6.1.0.1-196 Stable
https://sourceforge.net/projects/pentaho/files/Data%20Integration/6.1/pdi-ce-6.1.0.1-196.zip/download

PRD 6.1.0.1-196 Stable
https://sourceforge.net/projects/pentaho/files/Report%20Designer/6.1/prd-ce-6.1.0.1-196.zip/download

PSW 3.12.0.1-196 Stable
https://sourceforge.net/projects/mondrian/files/schema%20workbench/3.12.0/psw-ce-3.12.0.1-196.zip/download

PAD 6.1.0.1-196 Stable
https://sourceforge.net/projects/mondrian/files/aggregation%20designer/6.1/pad-ce-6.1.0.1-196.zip/download

Install JDK 1.8

Install on your computer the JDK 1.8 and config the JAVA_HOME. DO NOT INSTALL JDK 1.6.

See the video below to help you with the installation.
https://www.youtube.com/watch?v=9hnmyQUYbro

Install PostgreSQL 9.3 or superior

Download PostgreSQL in the link below:

http://www.postgresql.org/download/

pentahoLanguagePacks

Visit the links below to learn more about it.

http://community.pentaho.com/marketplace/language-packs/

https://github.com/webdetails/pentahoLanguagePacks

http://blog.professorcoruja.com/2009/06/traducao-pentaho-bi-server-20-e-30-para.html

https://code.google.com/p/brazilianportuguesetranslationofpentaho/

Pentaho Marketplace

https://github.com/pentaho/marketplace-metadata

Infos:

BA Server 5.4.0.1-130
http://localhost:8080/
user: admin
password: password

Administration
Home -> Administration

##OLAP viewer

Saiku Chart Plus
http://it4biz.github.io/SaikuChartPlus/

Saiku
http://meteorite.bi/saiku

Pivot4J
http://mysticfall.github.io/pivot4j/
http://www.pivot4j.org/

Pivot
http://jpivot.sourceforge.net/

STPivot
https://code.google.com/p/stpivot/

OLAP4J
http://www.olap4j.org/

Hardware recommendations for the Pentaho Server
http://infocenter.pentaho.com/help/index.jsp?topic=%2Fsupported_components%2Freference_supported_components.html

##Pentaho Plug-ins (Mandatory)

• Pentaho Marketplace
• Community Dashboards Framework
• Community Data Access
• Community Dashboard Editor
• Community Graphics Generator
• Sparkl - Pentaho Application Builder
• Saiku Analytics
• Saiku Chart Plus
• Pentaho CE Audit
• Pentaho Performance Monitoring

##Pentaho Plug-ins (recommended)

• D3 Component Library
• Pivot4J Analytics
• Change Password
• Portuguese (Brazilian variant) Language Pack Installer

##Pentaho BIServer api doc http://javadoc.pentaho.com/bi-platform500/webservice500/index.html

Pentaho CE 5.4 on production with PostgreSQL

https://github.com/wmarinho/docker-pentaho
https://github.com/wmarinho/pentaho5-installer
http://forums.pentaho.com/showthread.php?165218-Pentaho-Rapid-Deployment-with-Docker
https://www.rowellbelen.com/docker-pentaho-ba-server-ce/
https://hub.docker.com/r/bytekast/docker-pentaho-ce-5.3/
https://hub.docker.com/r/wmarinho/pentaho-biserver/

Proxy / BI Server

Add -Dhttp.proxyHost=proxy.trt7.local -Dhttp.proxyPort=9090 -Dhttps.proxyHost=proxy.trt7.local -Dhttps.proxyPort=9090

IF "%BITS%" == "64" (
  set CATALINA_OPTS=-Xms3g -Xmx3g -XX:MaxPermSize=256m -Dsun.rmi.dgc.client.gcInterval=3600000 -Dsun.rmi.dgc.server.gcInterval=3600000 -Dhttp.proxyHost=proxy.trt7.local -Dhttp.proxyPort=9090 -Dhttps.proxyHost=proxy.trt7.local -Dhttps.proxyPort=9090
) ELSE (
  set CATALINA_OPTS=-Xms3g -Xmx3g -XX:MaxPermSize=256m -Dsun.rmi.dgc.client.gcInterval=3600000 -Dsun.rmi.dgc.server.gcInterval=3600000 -Dhttp.proxyHost=proxy.trt7.local -Dhttp.proxyPort=9090 -Dhttps.proxyHost=proxy.trt7.local -Dhttps.proxyPort=9090
)

Change Port / BI Server

Edit the file biserver-ce-5.4.0.1-130\biserver-ce\tomcat\conf\server.xml

	<!-- porta alterada de 8080 para 80 -->
	
    <Connector URIEncoding="UTF-8" port="80" protocol="HTTP/1.1" 
               connectionTimeout="20000" 
               redirectPort="8443" />

Edit the file \biserver-ce-5.4.0.1-130\biserver-ce\tomcat\webapps\pentaho\WEB-INF\web.xml

  <context-param>
    <param-name>fully-qualified-server-url</param-name>
    <param-value>http://localhost/pentaho/</param-value>
  </context-param>
  

DW Config

#DW Config
DW_HOST=localhost
DW_DATABASE=dw
DW_PORT=5432
DW_USERNAME=postgres
DW_PASSWORD=Encrypted 2be98afc78aa7f2e21a1da345d078bdce

Matt Casters talking about PDI/Kettle at FEA/USP

http://www.portalfea.fea.usp.br/videos/o-comeco-de-tudo-pentaho-data-integration-parte-4

http://www.portalfea.fea.usp.br/videos/pentaho-day-2014-parte-1