|
Currently the Pentaho reports work in a multi-tenant environment as follows.
Code located at https://github.com/openMF/mifosx/blob/develop/mifosng-provider/src/main/java/org/mifosplatform/infrastructure/dataqueries/service/ReadReportingServiceImpl.java#L241
1) Tenant Database name is passed into the report along with user hierarchy for datascoping. Global scripting is used within the pentaho report to form the right URL for the tenant database ( since the host and port are not passed to the pentaho report, global scripting assumes that tenant database is located on localhost on port 3306 )
2) The default data source configured in the report has the right credentials for connecting to this tenant database. The same are used for connecting to the tenant database.
All 4 parameters need to be passed to the report (port, host,username and password)
|