...
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
...
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