...
In order to run Mifos BI, you need to install a server running ubuntu 10.04 LTS with the following software installed:
- Sun Microsystems Java - JDK/JRE 1.6
- MySQL - Community Edition 5.1.45
- Pentaho BI Server 3.6.0
- Pentaho CDA 1.0.0
- Pentaho Data Integration Community Edition 4.0.0
NOTE: following instructions presume an ubuntu 10.04 LTS environmentNote: these tools can also be run on Windows, but instructions and scripts are currently provided only for Ubuntu.
Mifos BI 1.0 works with Mifos 2.0 and above.
Install base os dependencies
...
Get the Latest Mifos BI from sourceforge.org. (download here)
unzip -j -d /etc/pentaho/system/pentaho-cdf mifos_bi-1.0.0.zip reports/CDFReportingTemplate/template-dashboard-mifosreports.html
unzip -j -d /etc/pentaho/system/pentaho-cdf/resources/style/images mifos_bi-1.0.0.zip reports/CDFReportingTemplate/*.jpg
unzip -d /usr/local/data-integration mifos_bi-1.0.0.zip ETL/*
unzip -d /etc/pentaho mifos_bi-1.0.0.zip reports/*
mv /etc/pentaho/reports/standardReports /etc/pentaho
mv /etc/pentaho/reports/commonActions /etc/pentaho
mv /etc/pentaho/reports/dataAccess /etc/pentaho
mv /etc/pentaho/reports/i18n/org /var/lib/tomcat6/webapps/pentaho/WEB-INF/classes
rm -rf /etc/pentaho/reports/CDFReportingTemplate
rmdir /etc/pentaho/reports/i18n
rmdir /etc/pentaho/reports
chown -R tomcat6 /var/lib/tomcat6/webapps
...
See http://thread.gmane.org/gmane.comp.finance.mifos.devel/10466
setup ETL job
set up a cron job to run the etl job:
/usr/local/data-integration/etl_build_prod.sh <destination db name> /usr/local/data-integration "<destination db mysql args>" > /tmp/data_integration.sh.out 2> /tmp/data_integration.sh.err