| Info |
|---|
Work in Progress |
A guide for installing Mifos Business Intelligence Suite 1.2 on a Windows machine.
...
- No previous mifos BI installation
- The mifos database is called 'mifos'
- mysql is using port 3306
- Running Mifos 2.0 or higher.
The installation process will create a data warehouse database called 'mifos_dw'. It will also create databases quartz, hibernate and sampledata for pentaho use.
Please refer to to Installing Mifos BI 1.1 for 2 for instructions on installing on a Linux server. Special thanks to John Woodlock for compiling this installer package.
...
...
If you have a problem kicking of pentaho at the end of this process... it may be because of mysql security issues. If you see hibuser access denied type messages this is likely the case. In this event, please download the attachment below and run it:
mysql -u"USERNAME" -p"PASSWORD" < mifosbi_users.sql
Software Requirements
These are the required software for Mifos BI 1.1 2 (they are the same as required by the Mifos application itself)
- Sun Microsystems Java - JDK/JRE 1.6
- MySQL - Community Edition 5.1.45 or higher
Installation
- Download Mifos BI 1.1 2 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.
| Panel |
|---|
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 |
- 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.
...
- Go to the biserver-ce folder in the pentaho_mifosbi_1_12_windows folder. Double-click start-pentaho.bat
...
- Navigate to your control panel and double click Scheduled Tasks icon.
- Double click to Add Scheduled Task.
- Under the Add Scheduled Task wizard, click the Browse option and navigate to the pentaho_mifosbi_1_12_windows directory and select initialise_datawarehouse.bat
- You can rename the task if you like. For Perform this task, select Daily.
- Select the time you'd like it to run at. I've selected it to run after midnight each day so all daily transactions will have been entered.
- Enter your Windows user credentials.
- Click Finish to successfully add the task. You can select advanced properties to control how and when the task gets run.
...