ioptoy.blogg.se - Pentaho data integration system requirements

#Pentaho data integration system requirements how to#
#Pentaho data integration system requirements install#

Note: hibernate user and quartz user can be the same. You will need to configure two databases to get pentaho up and running a "Hibernate" database and a "Quartz" databaseĮcho "create database hibernate " | mysql Įcho "grant all on hibernate.* to | mysql Įcho "set password for = password('') " | mysql

#Pentaho data integration system requirements install#

Unzip -d $PDI_HOME mifos_bi-1.1.0.zip etl_build.sh etl_build_prod.sh ppi_build.shĬonfigure Pentaho database settings and install ETL Unzip -d $PDI_HOME mifos_bi-1.1.0.zip ETL/*Įxtract the files etl_build.sh, etl_build_prod.sh, ppi_build.sh to $PDI_HOME: Sudo apt-get install sun-java6-jdk libmysql-java Install Data Integration/ETLĮxtract it to a location we will call $PDI_HOME (the root of the Pentaho Data Integration) Get Mifos BI 1.1 Sudo add-apt-repository "deb lucid partner" Install Process Install base os dependencies

/etc/pentaho/reports/CDFReportingTemplate.

/etc/pentaho/system/pentaho-cdf/resources/style/images/*.jpg.

reports/CDFReportingTemplate/template-dashboard-mifosreports.html.

Remove existing files/dirs before following below Install Process:.

The existing Mifos application database (mifos) will be the SourceDB. The Mifos Data Warehouse database (mifos_dw) will be the DestinationDB which will be created by running the ETL script later on.

#Pentaho data integration system requirements how to#

This document will show you how to first setup and configure Pentaho Data Integration to run ETL scripts necessary for BI and reporting. It also continues to show you how to setup the Pentaho business intelligence J2EE web application in an existing tomcat instance.

Mifos BI 1.1 works with Mifos 2.0 and above. Note: these tools can also be run on Windows, but instructions and scripts are currently provided only for Ubuntu. Pentaho Data Integration Community Edition 4.0.0.In order to run Mifos BI, you need a server running ubuntu 10.04 LTS with the following software installed: