Every week the Pentaho team makes a concerted effort to improve our documentation. As anyone who has worked on an open source project can attest, there is never enough time to write all of the code you want to write and write all of the documentation you would like to accompany it.

Fortunately, we have a strong community that graciously contributes gems via forums and email discussions on successfully tackling frequently performed tasks. So we have dedicated this portion of our developer's site to publishing these technical gems so that the rest of the community can benefit from tested, "single-path-of-execution" solutions to everyday problems. Hopefully, you will find just the solution you are looking for here. If not, you can always post your dilemma in our forums here.

If you have an idea for a tech tip you would like to write, please contact communityconnection@pentaho.org 

Please get involved and send us feedback on these articles!

Pentaho Platform and Solution Articles

Pentaho Tech Tips

• Stub — May 16, 2008
  Submitted by Pedro Alves, Community Member
• Change the name of the HIBERNATE database — March 02, 2007
  Submitted by David Kincade, Pentaho Team Developer
• Pentaho reports integration with portlets web application — October 07, 2007
  Contributed by Ashish Sarin, Pentaho Community Member
• A Dashboard Framework for the Pentaho BI Platform — August 21, 2007
  Contributed by Ingo Klose, Pentaho Community Member
• HOWTO - My (very big) pentaho install and setup tutorial — August 13, 2007
• Dynamic Reporting using the ReportSpec API (work in progress) — March 02, 2007
  Submitted by Mike D'Amour, Pentaho Team Developer
• Using PostgreSQL 8.x for Hibernated Data in the Platform — February 28, 2007
  Submitted by Marc Batchelor, Pentaho Team Developer
• Dynamically Generating a Cross Tab Report, Part 2 — September 12, 2006
  Contributed by Nic Guzaldo, Pentaho Community Member
• Dynamically Generating a Cross Tab Report, Part 1 — September 12, 2006
  Contributed by Nic Guzaldo, Pentaho Community Member
• The IF Statement and PREPARE - Building Flexible, Secure and Scalable Solutions — October 11, 2006
  Submitted by Marc Batchelor and Doug Moran, Pentaho Team Developer
• Using AJAX to Drive Dependent Report Parameters — January 23, 2007
  Submitted by Mike D'Amour, Pentaho Team Developer

External Articles

• Pentaho on Glassfish, the Step-by-Step Installation — July 23, 2006
  Contributed by Stephane Paquet, French blogger
• Hands on: MySQL Samples For Pentaho 1 (Installation of the PCI) — July 10, 2006
  Contributed by Roland Bouman, MySQL AB, Netherlands
• Hands on: MySQL Samples For Pentaho 2 (Configuration of the PCI) — July 12, 2006
  Contributed by Roland Bouman, MySQL AB, Netherlands
• Hands on: MySQL Samples For Pentaho 3 (Making the MySQL Directory) — July 16,2006,
  Contributed by Roland Bouman, MySQL AB, Netherlands
• Pentaho on Glassfish Quick and Dirty —
  Contributed by Stephane Paquet, French blogger
• Step by Step - Setting Up a custom solution repository— September 10, 2007,
  Contributed by Michael Tarallo, Pentaho Corportation
• Business Intelligence mit Pentaho [German]— Dezember 10, 2007,
  Contributed by Marcus Held and Ingo Klose, SHS VIVEON AG
• Pentaho AJAX Guide— September 10, 2007,
  Contributed by Michael Tarallo, Pentaho Corportation

Pentaho Data Integration Articles

Pentaho Tech Tips

• PDI Performance tuning check-list
• Executing Job or Transformation packaged in a zip file
• Mappings re-visited (version 3 or higher)
• Step error handling codes
• PDI Plugin Loading
• Javascript and Java Object Access in Kettle — March 30, 2006
  Submitted by Matt Castors, Chief of Data Integration, Pentaho
• Helpful Tips and Tricks Using Kettle — April 14, 2006
  Submitted by Matt Castors, Chief of Data Integration, Pentaho
• Looking Up Information in Kettle — April 14, 2006
  Submitted by Matt Castors, Chief of Data Integration, Pentaho
• Mappings in Kettle — May 9, 2006
  Submitted by Matt Castors, Chief of Data Integration, Pentaho
• Using Variables in Kettle — May 23, 2006
• How to Configure Kettle's Spoon for a Pentaho Solution — May 25, 2006
  Submitted by James Dixon, Pentaho Chief Geek
• Use Kettle to Migrate Sample Data to MySQL — July 11, 2006
  Contributed by Nic Guzaldo, Pentaho Community Member
• Loading Binary Objects With Kettle — August 23, 2006
  Submitted by Matt Casters, Chief of Data Integration, Pentaho
• Evaluating Parameters in Kettle Jobs — August 24, 2006
  Submitted by Matt Castors, Chief of Data Integration, Pentaho
• Using the Copy Table Wizard — August 24, 2006
  Submitted by Matt Castors, Chief of Data Integration, Pentaho
• Auditing and Operational Metadata — September 1, 2006
  Submitted by Matt Castors, Chief of Data Integration, Pentaho

External Articles

• Great Overview of Kettle — June 10, 2006
  Contributed by Roland Bouman, MySQL AB, Netherlands
• UPSERTS Using Kettle and MySQL — May 4, 2006
  Contributed by Nicholas Goodman, Pentaho blogger extraordinaire
• Using Java Locale to create a date dimension — September 4th, 2007
  Contributed by Roland Bouman, MySQL AB, Netherlands
• Kettle und die Entwicklung eines eigenen Plug-ins (German) — September, 2007 [Java Magazin 10.2007]
  Contributed by Jens Bleuel, Pentaho
• Studie zur Entwicklung eines Data Warehouses zur Auswertung von SAP-Controlling Daten an der Wirtschaftsuniversität Wien (German) - February, 2006
  Written by Martin Bernsteiner. [Development of a Data Warehouse for analysing SAP-Controlling Data at the Vienna University of Economics and Business Administration]

• Busines Solutions using PDI (In Open Document Text Format) -  2 May 2008
  A work in progress text consisting of case studies and examples on solving common business problems with PDI.
  Contributed by Pradesh Chanderpaul, DataCraft Software, South Africa

Pentaho Reporting Articles

Pentaho Tech Tips

• Designing Reports With MySQL and JNDI — May 4, 2006
  Contributed by Lee Mewshaw, Red Hat
• Setting Up Parameters With the Design Studio — May 17, 2006
  Submitted by Doug Moran, Pentaho Team Developer
• Introducing the Pentaho Report Designer — May 31, 2006
  Submitted by Mike D'Amour, Pentaho Team Developer
• Dynamically Generating SQL... And More — June 8, 2006
  Submitted by Marc Batchelor, Pentaho Team Developer
• Embedding Charts in Pentaho Reporting — June 27, 2006
  Submitted by Mike D'Amour, Pentaho Team Developer
• Localizing a Pentaho Report — July 13, 2006
  Submitted by Mike D'Amour, Pentaho Team Developer

External Articles

• Reporting in 60 Seconds — June 1, 2006
  Contributed by Nicholas Goodman, Pentaho blogger extraordinaire
• Connect to Your Own Database — May 4, 2006
  Contributed by Nicholas Goodman, Pentaho blogger extraordinaire

Pentaho Analysis Articles

Pentaho Tech Tips

• Evaluating Pentaho Analysis — March 25, 2008
• MDX Calculations - Previous Period Growth — October 24, 2006
  Contributed by Chris Webb, Crossjoin Consulting
• MDX Calculations - Percentage Shares and Allocations — November 7, 2006
  Contributed by Chris Webb, Crossjoin Consulting
• MDX Calculations - Set Functions — January 15, 2007
  Contributed by Chris Webb, Crossjoin Consulting

External Articles

• Trend Lines in Mondrian — November 1, 2006
  Contributed by Nicholas Goodman, Pentaho blogger extraordinaire
• The Power of OLAP, Part 1: Building a Custom MDX Measure — June 8, 2006
  Contributed by Nicholas Goodman, Pentaho blogger extraordinaire
• The Power of OLAP, Part 2: Bringing the Power to Your Users — June 9, 2006
  Contributed by Nicholas Goodman, Pentaho blogger extraordinaire