Install and Run pentaho-data
pentaho-data provides an HSQLDB-based data source shared by gather and pentaho.
Prerequisites
- JAVA_HOME is set properly
Steps
Checkout then run the server:
- checkout the project
- svn co http://code.dimagi.com/svn/Gather/pentaho/pentaho-data/trunk/ pentaho-data
- run the server
- start_hypersonic.sh or start_hypersonic.bat
- optionally, run the database manager
- DatabaseManager.sh
Transcript...
$ svn co http://code.dimagi.com/svn/Gather/pentaho/pentaho-data/trunk/ pentaho-data A pentaho-data/hibernate A pentaho-data/hibernate/hibernate.log A pentaho-data/hibernate/hibernate.script A pentaho-data/hibernate/hibernate.properties ... A pentaho-data/oracle10g A pentaho-data/oracle10g/sampledata-ora.sql A pentaho-data/stop_hypersonic.bat Checked out revision 48. $ cd pentaho-data/ $ ./start_hypersonic.sh JAVA_HOME set to /Library/Java/Home/ JAVA is /Library/Java/Home//bin/java ... [Server@5d173]: Startup sequence completed in 994 ms. [Server@5d173]: 2008-06-04 14:14:22.603 HSQLDB server 1.8.0 is online [Server@5d173]: To close normally, connect and execute SHUTDOWN SQL [Server@5d173]: From command line, use [Ctrl]+[C] to abort abruptly
Optional: Run the DatabaseManager
The DatabaseManager is a java-based GUI for working with any jdbc accessible database.
- launch the DatabaseManager
- DatabaseManager.sh or DatabaseManager.bat
- connect to the gather datasource
- URL: "jdbc:hsqldb:hsql://localhost/gather"
Transcript...
$ chmod +x DatabaseManager.sh $ ./DatabaseManager.sh
