O'Reilly logo

Pentaho for Big Data Analytics by Feris Thia, Manoj R Patil

Stay ahead with the world's most comprehensive technology and business learning platform.

With Safari, you learn the way you learn best. Get unlimited access to videos, live online training, learning paths, books, tutorials, and more.

Start Free Trial

No credit card required

The embedded HSQLDB database server

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 .script, .lck, .properties, and .log files associated with each database. The file with the .script extension is the datafile, .lck is the locking ...

With Safari, you learn the way you learn best. Get unlimited access to videos, live online training, learning paths, books, interactive tutorials, and more.

Start Free Trial

No credit card required