...
These are the required software for Mifos BI 1.1 2 (they are the same as required by the Mifos application itself)
...
- Download Mifos BI 1.1 Windows Install package I chose to download this install_mifos_bi_1_12_Windows.zip file directly into my C:\MifosInstall folder. If you don't have the option to specify your download folder; after the download completes use windows explorer to 'cut it' (for speed instead of copy) from your download folder to an install folder of your choice.
- Go to your install folder via Windows Explorer. Extract/Unzip install_mifos_bi_1_12_Windows.zip into your install folder. This creates a folder called install_mifos_bi_1_12_Windows
- You can extract/unzip into any folder, the install folder is used here for simplicity.
- Set up MySQL: Open up a Command Prompt (Start >> run >> CMD) and cd into the install_mifos_bi_1_12_Windows folder. Run the following command replacing MYSQLUSERNAME with root and PASSWORD with your password for root user.
...
- Run the Datawarehouse ETL Job: You can do this manually by cd'ing into pentaho_mifosbi_1_12_windows folder and entering:
Panel initialise_datawarehouse.bat
- For your data to be populated from Mifos into the datawarehouse, this ETL job needs to be run (typically each day just after midnight but could be less frequent if preferred). See below for instructions on scheduling the ETL job.
...