Difference between revisions of "Using Pentaho with opentaps"

From Opentaps Wiki
Jump to navigationJump to search
(How to design and run a report with the pentaho framework)
(How to design and run a report with the pentaho framework)
Line 1: Line 1:
 
==How to design and run a report with the pentaho framework==
 
==How to design and run a report with the pentaho framework==
  
# 1 First we need to get the Pentaho Report Designer (stable version 1.5.6) [http://downloads.sourceforge.net/pentaho/PentahoReportDesigner-1.5.6.270-0.zip?use_mirror=mesh Pentaho Report Designer 1.5.6]
+
1. First we need to get the Pentaho Report Designer (stable version 1.5.6) [http://downloads.sourceforge.net/pentaho/PentahoReportDesigner-1.5.6.270-0.zip?use_mirror=mesh Pentaho Report Designer 1.5.6]
  
# 2 We need to activate the opentaps pentaho component by uncommenting the following line in hot-deploy/component-load.xml :
+
2. We need to activate the opentaps pentaho component by uncommenting the following line in hot-deploy/component-load.xml :
 
  <!-- <load-component component-location="${ofbiz.home}/hot-deploy/pentaho"/> -->
 
  <!-- <load-component component-location="${ofbiz.home}/hot-deploy/pentaho"/> -->
 +
 +
3. Configuration of the database connection for the Pentaho Report Designer tool
 +
*3.1 Unzip the Report Designer you have downloaded to a directory we will call <REPORT-DESIGNER-HOME>
 +
*3.2 Drop you JDBC database driver in <REPORT-DESIGNER-HOME>/lib/jdbc
 +
*3.3 Run the Pentaho Report Designer application (startdesigner_linux.sh)

Revision as of 19:48, 22 September 2007

How to design and run a report with the pentaho framework

1. First we need to get the Pentaho Report Designer (stable version 1.5.6) Pentaho Report Designer 1.5.6

2. We need to activate the opentaps pentaho component by uncommenting the following line in hot-deploy/component-load.xml :

<!-- <load-component component-location="${ofbiz.home}/hot-deploy/pentaho"/> -->

3. Configuration of the database connection for the Pentaho Report Designer tool

  • 3.1 Unzip the Report Designer you have downloaded to a directory we will call <REPORT-DESIGNER-HOME>
  • 3.2 Drop you JDBC database driver in <REPORT-DESIGNER-HOME>/lib/jdbc
  • 3.3 Run the Pentaho Report Designer application (startdesigner_linux.sh)