Pentaho 3.5 and BIRT 2.5 Integration

Eclipse BIRT 2.5 and Pentaho 3.5 Integration and Configuration:

Contents:

1. BIRT Default Configuration in Pentaho:
2. Upgrading BIRT 2.2 to BIRT 2.5 in Pentaho 3.5
3. Known Errors
4. Fix of the Errors

Eclipse BIRT has two sections:
• Eclipse BIRT Designer 2.5
• Eclipse BIRT Runtime 2.5

You can download them from http://www.eclipse.org/birt/phoenix/
As Eclipse BIRT has its own runtime so it handles independently database connections and report rendering in different formats.

BIRT Default Configuration in Pentaho:

In Pentaho BIRT runtime is located in:
biserver‐ce‐3.5.0.RC2\biserver‐ce\pentaho‐solutions\system\BIRT

In Pentaho BIRT writes chart images in:
biserver‐ce‐3.5.0.RC2\biserver‐ce\pentaho‐solutions\tmp

In Pentaho BIRT writes log in:
biserver‐ce‐3.5.0.RC2\biserver‐ce\pentaho‐solutions\system\logs\BIRT

In Pentaho BIRT runtime libraries (jars)
\biserver‐ce‐3.5.0.RC2\biserver‐ce\tomcat\webapps\pentaho\WEB‐INF\lib

And BIRT jars are:
1. chartengineapi‐2.2.1.jar
2. com.ibm.icu‐3.6.1‐v20070906‐birt‐custom.jar
3. commons‐cli‐1.0.jar
4. commons‐codec‐1.3.jar
5. coreapi‐2.2.1.jar
6. dataadapterapi‐2.2.1.jar
7. dteapi‐2.2.1.jar
8. engineapi‐2.2.1.jar
9. flute‐1.1.1.jar
10. modelapi‐2.2.1.jar
11. js‐1.7R1.jar
12. org.eclipse.emf.common‐2.2.1.v200702131851‐birt‐custom.jar
13. org.eclipse.emf.ecore‐2.2.2.v200702131851‐birt‐custom.jar
14. org.eclipse.emf.ecore.xmi‐2.2.2.v200702131851‐birt‐custom.jar
15. org.w3c.css.sac‐1.3.0.v200706111724‐birt‐custom.jar
16. scriptapi‐2.2.1.jar

BIRT Default JDBC driver location:
biserver‐ce‐3.5.0.RC2\biserver‐ce\pentahosolutions\system\BIRT\plugins\org.eclipse.birt.report.data.oda.jdbc_2.5.0.v20090605

Upgrading BIRT 2.2 to BIRT 2.5 in Pentaho 3.5

1) In Pentaho 3.5, the BIRT plugin is not started with the Pentaho server.
To enable the BIRT plugin, add the line below to pentaho‐solutions/system/systemListeners.xml:

2) dowload and extract birt‐runtime‐2_5_0.zip
3) delete content of pentaho‐solutions\system\BIRT\configuration
4) delete content of pentaho‐solutions\system\BIRT\plugins
5) copy birt‐runtime‐2_5_0\ReportEngine\configuration in pentaho‐solutions\system\BIRT\configuration
6) copy birt‐runtime‐2_5_0\ReportEngine\plugins in pentaho‐solutions\system\BIRT\plugins
7) delete of pentaho\WEB‐INF\lib ‐ all the 16 BIRT jars mentioned above. (we do a mistake here we use to replace
these jars with new jars which creates the trouble. Please do go for replace but first delete all of them)
8) copy content of birt‐runtime‐2_5_0\ReportEngine\lib in pentaho\WEB‐INF\lib
9) copy your jdbc driver e.g. mysql‐connector‐java‐5.0.7.jar to K:\Tools\biserver‐ce‐3.5.0.RC2\biserverce\pentaho‐solutions\system\BIRT\plugins\org.eclipse.birt.report.data.oda.jdbc_2.5.0.v20090605\drivers\ folder

After these configurations we will get some errors while running pentaho server:

Known Errors

1. WARNING: logDir "" doesn't exist and be created
java.io.IOException: logDir "" doesn't exist and be created
2. BIRT reports and Charts are not showing in HTML format

Fixes

The fixes for the birt plugin in two java files : BIRTReportComponent.java and
BirtSystemListener.java is modified and the plugin jar is available here
https://sourceforge.net/projects/birt25pentaho35/
10) Please delete the pentaho‐bi‐platform‐plugin‐actions‐3.5.0.RC2.jar and download the pentaho‐bi‐platformplugin‐
actions‐3.5.0.RC2‐extended.jar from above url and copy it to pentaho/WEB‐INF/lib