3.3. Configure Pentaho Analysis Report

  1. Open Pentaho console: http://localhost:18081/pentaho and login as Admin/password.

  2. Click File → Manage Data Sources.

  3. Click the settings button and select New Connection:

    bi pentaho
    Figure 16. Database connection

  4. Create connection to HSQLDB:

    • Host Name: localhost

    • Database Name: bidemo

    • Port Number: 19001

    • User Name: sa

    bi pentaho 2
    Figure 17. Database connection

Now you can either use the analysis report delivered with the demo project or create it yourself following the steps below.