HSQLDB Database Manager

To start this program, run the DatabaseManager.sh (or DatabaseManager.bat for Windows) script in the /pentaho-data directory. Then use the following settings to connect:

• Type: HSQL Database Engine In-Memory
• Driver: org.hsqldb.jdbcDriver
• URL: jdbc:hsqldb:hsql://localhost/gather
• User: sa
• Password: <empty by default unless you have changed it>

You can save the settings for later use by entering a "Setting Name" at the top. Once you click OK, you will be able to explore and run queries on the Gather database to test out the queries you will use in reporting.

Back to GettingStartedWithPentaho