...
Set up JNDI entries for SourceDB and DestinationDB in the administration console. Only DestinationDB is needed for the datawarehouse, the other (mifos application database) is needed if running ETL or running non-DW reports so you may as well set them both up at the same time.
1st go into the administration-console directory and run start-pac.bat
then go to your browser and put in "localhost:8099" log in as admin, click Administration, then 'database connections', then the + to add a new one and fill in
name: SourceDB
driver class: com.mysql.jdbc.Driver
user name: root (or whatever mysql user you want)
password: *****
Url: jdbc:mysql://localhost:3306/mifos_secdep_prod
the bit at the end is the database name to point to. Then click test and assuming you get a clean test, save it. Do same for DestinationDB
...