Hitachi Vantara Pentaho Community Forums
Results 1 to 2 of 2

Thread: Why change from HSQL to MySQL/MSSQL/Postgess ?

  1. #1

    Default Why change from HSQL to MySQL/MSSQL/Postgess ?

    I am aware of the guide ( to change Pentaho default HSQL repository to an other database.
    For me it is not very clear why you would want to do that?

    In a situation with about 5 report builders and say a 100 to 200 reportviewers with about 1000 reports would it be a problem to keep the HSQL solution? I know it is very general but any wise words on this are appreciated. Is updating the HSQL an issue.


  2. #2


    Hi Jeroen,

    we put the hibernate and quartz databases into a schema of the data warehouse database
    only because of the backup and restore mechanisms we already implemented for the data
    warehouse db. Admins were not happy with backing up the hsql-db via file system backup.

    The integrated hsql libraries are pretty old - I think pentaho still uses 1.8 and hsql is available
    in version 2.6 (?) already. As the provided data within the pentaho package is not compatible
    to versions newer than hsql 2.x, you would have to convert data.


Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
Privacy Policy | Legal Notices | Safe Harbor Privacy Policy

Copyright © 2005 - 2019 Hitachi Vantara Corporation. All Rights Reserved.