Maximo 7.6 - BIRT setup for Report Development

Maximo 7.6 - BIRT Setup for Report Development

This guide provides the steps to configure BIRT for Maximo 7.6 with DB2 database.

Step 1:

Download the latest “birt-report-designer-all-in-one-4.6.0” version of BIRT which support Maximo 7.6 reports from http://www.eclipse.org/downloads/download.php?file=/birt/downloads/drops/R-R1-4.6.0-201606072112/birt-report-designer-all-in-one-4.6.0-20160607-win32.win32.x86_64.zip

Step 2:

Locate the classes used for report scripting in <v76_SMP_folder>\maximo\reports\birt\scriptlibrary\classes and copy into <birt_install_path>\eclipse\plugins\org.eclipse.birt.report.viewer_4.6.0.v201606072122\birt\WEB-INF overwriting classes folder

Step 3

Locate the JDBC driver for DB2 db2jcc.jar in <v76_SMP_folder>\maximo\applications\maximo\lib and copy into <birt_install_path>\eclipse\plugins\org.eclipse.birt.report.viewer_4.6.0.v201606072122\birt\WEB-INF\lib

Step 4

Open the JDBC jar file you copied and extract the contents of the jar file into <birt_install_path>\eclipse\plugins\org.eclipse.birt.report.viewer_4.6.0.v201606072122\birt\WEB-INF\classes

Step 5

Modify the mxreportdatasources.properties in <birt_install_path>\eclipse\plugins\org.eclipse.birt.report.viewer_4.6.0.v201606072122\birt\WEB-INF\classes to include following properties –

      a.   maximoDataSource.url=jdbc:db2://<database_server_host<database_server_port>/<database_sid

  b.   maximoDataSource.driver=com.ibm.db2.jcc.DB2Drive

  c.  maximoDataSource.username=<database_server_username

  d.   maximoDataSource.password=<database_server_password

  e.   maximoDataSource.schemaowner=maximo

Step 6

Create local folders of the Maximo 7.6 libraries and templates 

1.   Copy the libraries folder from <v76_SMP_folder>\reports\birt\libraries and store them locally
2.   Copy the templates folder from <v76_SMP_folder>\reports\birt\templates and store them locally.

Step 7

Launch BIRT and create a workspace.Note : Workspace can be created at any local path

Step 8

Set the BIRT Preferences as follows –

1.    From the Menu, select Window à Preference
2.    Expand Report Design and select Resource
3.    Using the 'File System' icon, navigate to the location of your local libraries folder created in step 6
4.    Select Apply.
5.    From the Menu, select Window à Preference
6.    Expand Report Design and select Template
7.    Using the ‘Select’ icon, navigate to the location of your local templates folder created in step 6.
8.    Select Apply.

Step 9

Create new project

Step 10

Create new folders for Out of Box reports (<v76_SMP_folder>\maximo\reports\birt\reports) and Custom reports

Step 11

Import reports into respective folders.