Pentaho BI Server comes with the HSQLDB (HyperSQL DataBase) embedded database server. This application is an open source database server that runs on the Java platform. With HSQLDB we don't need a separate database server to get the web application up and running.
The three databases that come with CE are hibernate, quartz, and sampledata. They are used for storing Pentaho's server configuration, user security and authorization, job schedules, and data samples used by report samples.
The database's physical file is located in
[BISERVER]/data. Here you can find the
.log files associated with each database. The file with the
.script extension is the datafile,
.lck is the locking ...