Friday, 13 November 2015

Rapid BIRT Configuration with IBM Maximo 7.6 - IBM Maximo


1 install jre-7-windows-x64.exe into C:\java\jre7
2 Extract eclipse-reporting-kepler-SR1-win32-x86_64 into C:\birt_431\eclipse


#classes folder copy
cp -R C:\IBM\SMP\maximo\reports\birt\scriptlibrary\classes C:\birt_431\eclipse\plugins\org.eclipse.birt.report.viewer_4.3.1.v201309171028\birt\WEB-INF\

# oraclethin.jar driver copy
cp C:\IBM\SMP\maximo\applications\maximo\lib\oraclethin.jar  C:\birt_431\eclipse\plugins\org.eclipse.birt.report.viewer_4.3.1.v201309171028\birt\WEB-INF\lib\



#extract driver jar file contents into
tar -xvf C:\birt_431\eclipse\plugins\org.eclipse.birt.report.viewer_4.3.1.v201309171028\birt\WEB-INF\lib\oraclethin.jar C:\birt_431\eclipse\plugins\ org.eclipse.birt.report.viewer_4.3.1.v201309171028\birt\WEB-INF\classes

#
copy C:\IBM\SMP\maximo\applications\maximo\maximouiweb\webmodule\WEB-INF\birt\platform\plugins\org.eclipse.birt.report.engine_4.3.1.v201309161141.jar C:\birt_431\eclipse\plugins\

#update mxreportdatasources.properties file
    System properties
        mxe.db.url     jdbc:oracle:thin:@//Vmax76.ots.com:1521/MAXDB
        mxe.db.driver    oracle.jdbc.OracleDriver
vi  C:\birt_431\eclipse\plugins\org.eclipse.birt.report.viewer_4.3.1.v201309171028\birt\WEB-INF\classes\mxreportdatasources.properties
      maximoDataSource.url=jdbc:oracle:thin:@//Vmax76.ots.com:1521/MAXDB
    maximoDataSource.driver=oracle.jdbc.OracleDriver
    maximoDataSource.username=maximo
    maximoDataSource.password=Oracle11g
    maximoDataSource.schemaowner=maximo
--------------------------
#birt settings, create shortcut with this path
C:\birt_431\eclipse\eclipse.exe -vm "C:\java\jre7\bin\javaw.exe" -vmargs -Xmx512m

#set library resources path: (Navigate to Report Design and select resources)
C:\IBM\SMP\maximo\reports\birt\libraries

#set templates path: (Navigate to Report Design and select Templates)
C:\IBM\SMP\maximo\reports\birt\templates/

#Create New project (Click File/ New/Project. Under Business Intelligence and Reporting Tools, select Report
Project. Click Next. )
C:\IBM\SMP\maximo\reports\birt\reports

#append eclipse.ini file
vi C:\birt_431\eclipse\eclipse.ini
-Dorg.eclipse.swt.browser.DefaultType=ie,mozilla
-Dorg.eclipse.swt.browser.IEVersion=7000


restart and DONE.

3 comments: