Mifos Pentaho Plugin - Installation Instruction on Windows 11 Home x86_64 - MariaDB

  1. Objective

 

Provide clear instructions for installing the Pentaho reporting plugin for the Mifos platform on a Windows 11 Home x86_64 operating system. Ideally, these instructions should be executed by users with basic technical skills..

 

 

  1. Target Audience

 

Username

User description

General Public

User should have basic knowledge about Software Installation on Windows.

 

 

 

 

  1. System requirements

 

Hardware:

  • 8Gb RAM 

  • 2 vCPUs (Intel x86 64bits or AMD x86 64bits)

  • 32Gb Storage 

 

Software:

  • Windows 11 Home x86_64 Operating System

  • Apache Tomcat 10.1

  • Mifos Platform Release 23.12 (Apache Fineract 1.9.0)

  • MariaDB 10.8+

 

 

 

  1. Deployment Architecture

 

This is a graphical representation of the components that will be installed, they are highlighted in yellow, and the others put in the graphic as a reference and they can be used for extending the functionality.

 

 

 

 

 

  1. Instructions

 

 

  1. We start Apache tomcat

In the Windows Application Launcher, search for Apache Tomcat.

Check if the status of Apache Tomcat is “Started”, if not at the bottom of the window, look for the "Start" button

Validate that Mifos Platform is running. Open in a Web Browser the address:

 

http://localhost:8080 

 

 

  1. Set a Fineract Pentaho environment variable

In the Windows Application Launcher look for the System Variables Editor functionality.

On the bottom of the window, look for “Environment Variables”

In the “Environment Variables”, add a new entry:

 

Name:  FINERACT_PENTAHO_REPORTS_PATH

 

Value: C:\mifos\pentahoReports

 

Click on the “Accept” button.

 

 

  1. Download zip file from SourceForge https://sourceforge.net/projects/mifos/files/mifos-plugins/FineractPentahoPlugin/FineractPentahoPlugin-1.10.zip/download

When you enter the download link, the file will automatically start the downloading

We locate the downloaded zip file

We unzip the zip file

We enter the path where the decompressed file will be saved

We locate the unzipped folder

 

 

  1. Copy the Fineract Pentaho binary

On the local disk  we create the C:\mifos\pentahoReports folder.

Go to the FineractPentahoPlugin-1.10.0\MariaDB\pentahoReports folder that was unzipped and Select all the content and copy the files and folders.

Go back to the “C:\mifos\pentahoReports” folder and paste the files that were selected in the previous step.

Go to the FineractPentahoPlugin-1.10.0\MariaDB\libs folder that you have unzipped, select all the files and copy them.

Paste the files into the libraries of the Apache Fineract application which is located at “$APACHE_TOMCAT\webapps\\fineract-provider\WEB-INF\libs”.

 

  1. Restart the Tomcat service

Before restarting the service we suggest increase the JVM memory pool used for Apache Tomcat:

 

Settings are

 

Initial memory pool: 1024

 

Maximum memory pool: 1024

Restart the Apache Tomcat service. Click stop and then start to start the service. 

 

Wait a few minutes because the Apache Fineract deployment process will take a few minutes to complete.

 

  1. Verify the Mifos Platform 24.04.30 Release

Open the Mifos X  Platform 24.04.30 User Interface on a web browser. 

 

http://localhost:8080 

 

The default credentials for login:

 

user: mifos 

password: password 

Once you can enter into the Mifos WebApp the initial page will look like this one.

We enter the "All" reports section

We are looking for a report that can be used with Mifos Pentaho plugin.

 

For example:

 

Expected Payments By Date - Basic (Pentaho) 

 

Fill out the required data and click on the "Run Report" button

The report will be generated and shown in the web application.

 

 

This is a basic setup to demonstrate the use of the Mifos Pentaho Plugin.

 

Please secure the application connections, the data, and change the default login credentials.

 

Enjoy and give us feedback.

 

If you require some help please contact us. These are the channels available to get in contact: https://mifos.org/resources/community/communications/

Please include screens, logs (use a paste tool like https://privatebin.net/ ), description of the issue with all the details that you can share. Please be careful and avoid to include sensitive data.

Remember that these installation instructions are for a quick way to get the Mifos X Platform up and running very quickly. You have to protect the sensitive data in motion/rest, secrets, connections, credentials, etc. based on your local requirements.