Hi Dennis,
The hibernate and quartz are the default databases that comes with
Pentaho suite. Apart from that you are suppose to create two DB's
SourceDB and DestinationDB which is your mifos and datawarehouse
instance respectively.
Excecute
"D:\mifos_bi-1.2.0\ETL\MifosDataWarehouseETL\load_mifos_datawarehouse.sq
l" and
D:\mifos_bi-1.2.0\ETL\MifosDataWarehouseETL\load_mifos_datawarehouse_sto
red_procedures.sql
To create the schema of your datawarehouse.
Thanks,
Ramya
From: Dennis Tela [mailto:[email protected]]
Sent: Friday, August 12, 2011 1:47 PM
To: A good place to start for users or folks new to Mifos.
Subject: Re: [Mifos-users] BI
Thanks Udai.
I have many questions to ask about the guide whose link you just showed
me.
I have followed the guide; I have a "hibernate" and "quartz" database in
place.
Then the guide says;-
"You will need to configure two databases SourceDB and DestinationDB.
Edit the file with SourceDB and DestinationDB login credentials"
The file $PDI_HOME/simple-jndi/jdbc.properties looks like this:-
SampleData/type=javax.sql.DataSource
SampleData/driver=org.hsqldb.jdbcDriver
SampleData/url=jdbc:hsqldb:hsql://localhost/sampledata
SampleData/user=pentaho_user
SampleData/password=password
Quartz/type=javax.sql.DataSource
Quartz/driver=org.hsqldb.jdbcDriver
Quartz/url=jdbc:hsqldb:hsql://localhost/quartz
Quartz/user=pentaho_user
Quartz/password=password
Hibernate/type=javax.sql.DataSource
Hibernate/driver=org.hsqldb.jdbcDriver
Hibernate/url=jdbc:hsqldb:hsql://localhost/hibernate
Hibernate/user=hibuser
Hibernate/password=password
Shark/type=javax.sql.DataSource
Shark/driver=org.hsqldb.jdbcDriver
Shark/url=jdbc:hsqldb:hsql://localhost/shark
Shark/user=sa
Shark/password=
Assuming that "mifos" is the SourceDB and "mifos_dw" is the
DestinationDB
How is the jdbc.properties file meant to look like, the mifos_bw
database is not yet created at this stage.
Thanks
On Fri, Aug 12, 2011 at 10:33 AM, Udai Gupta <[email protected]> wrote:
http://mifosforge.jira.com/wiki/display/MIFOS/Installing+Mifos+BI+1.3
> Similarly, is it possible to run the BI suite off a windows machine
while
> mifos runs on linux?
Yes, configure the SourceDb datasource of BI on windows to use MySQL
of Mifos on linux.
Udai
------------------------------------------------------------------------
------
Get a FREE DOWNLOAD! and learn more about uberSVN rich system,
user administration capabilities and model configuration. Take
the hassle out of deploying and managing Subversion and the
tools developers use with it.
http://p.sf.net/sfu/wandisco-dev2dev
_______________________________________________
Mifos-users mailing list
[email protected]
https://lists.sourceforge.net/lists/listinfo/mifos-users
------------------------------------------------------------------------------
Get a FREE DOWNLOAD! and learn more about uberSVN rich system,
user administration capabilities and model configuration. Take
the hassle out of deploying and managing Subversion and the
tools developers use with it.
http://p.sf.net/sfu/wandisco-dev2dev
_______________________________________________
Mifos-users mailing list
[email protected]
https://lists.sourceforge.net/lists/listinfo/mifos-users
