These are the required software for Mifos BI 1.3 (they are the same as required by the Mifos application itself)
If you have already installed BI 1.2 you don't need to do a full Pentaho installation and instead you can just update the mifos files.
Get the latest Mifos BI (1.3) from sourceforge.org. download here and unzip it.
Move or delete the following target directories prior to upgrading (copying).
biserver-ce\tomcat\webapps\pentaho\WEB-INF\classes\org
"The install directory"\ETL
biserver-ce\pentaho-solutions\standardReports
biserver-ce\pentaho-solutions\mpesa
biserver-ce\pentaho-solutions\Dashboards
biserver-ce\pentaho-solutions\DashboardsMenu
biserver-ce\pentaho-solutions\CommonActions
biserver-ce\pentaho-solutions\DataAccess
If you have added your own files, add them back afterwards.
copy directory reports\i18n\org to biserver-ce\tomcat\webapps\pentaho\WEB-INF\classes
copy directory ETL to "The install directory" (same level as initialise_datawarehouse.bat file is)
copy file reports\CDFReportingTemplate\template-dashboard-mifosreports.html to biserver-ce\pentaho-solutions\system\pentaho-cdf
copy file DashboardsTemplate\template-dashboard-dashboards.html to biserver-ce\pentaho-solutions\system\pentaho-cdf
copy files reports\CDFReportingTemplate*.jpg to biserver-ce\pentaho-solutions\system\pentaho-cdf\resources\style\images
copy directory reports\standardReports to biserver-ce\pentaho-solutions
copy directory reports\mpesa to biserver-ce\pentaho-solutions
copy directory reports\Dashboards to biserver-ce\pentaho-solutions
copy directory reports\DashboardsMenu to biserver-ce\pentaho-solutions
copy directory reports\commonActions to biserver-ce\pentaho-solutions
copy directory reports\dataAccess to biserver-ce\pentaho-solutions (and delete file index.html in the dataAccess directory so it doesn't show up on pentaho)
Then login to Pentaho as admin and do
i) Tools/Refresh/Repository Cache
ii) Tools/Refresh/CDA Cache
If you want to run the incremental ETL, create a file with the contents below called incremental_datawarehouse.bat and put it in pentaho_mifosbi_1_3_windows directory
SET PDIPATH=data-integration\ %PDIPATH%kitchen.bat /file:../%DWPATH%DataWarehouseIncrementalLoad.kjb %1 /level:Basic > transformationLog_incremental.log EXIT |
If you want to run the incremental ETL on Windows XP you will have to replace ETL\MifosDataWarehouseETL\SetDBParametersForCreatingDWDB.ktr with this attachment of the same name
SetDBParametersForCreatingDWDB.ktr
This assumes:
The installation process will create a data warehouse database called 'mifos_dw'. It will also create databases quartz, hibernate and sampledata for pentaho use.
mifosbi_mysql_scripts.bat MYSQLUSERNAME PASSWORD if you don't use a password with root you will need to edit the mifosbi_mysql_scripts.bat and remove all the occurrences of -p%2 |
initialise_datawarehouse.bat |
incremental_datawarehouse.bat |
If you run into issues running Mifos and Pentaho simultaneously, it's because of their port numbers. Mifos by default runs on port 8080. This is where Pentaho will try to run as well. To run both applications simultaneously, you need to change the port Pentaho runs on to 8086. Follow these steps to change the port for Pentaho. |
(A tomcat window will pop up - it will be successfully running when you see the following)
The instructions below are for Windows Task Scheduler (Windows XP/Windows 2003)
For more on using Windows Task Scheduler, see http://www.iopus.com/guides/winscheduler.htm.