3.2.2. Create Database Connection

If you want to create the star schema yourself, follow the steps below. For the detailed instructions consult the Pentaho wiki.

  1. Start Pentaho Data Integration using spoon.bat from $PENTAHO_HOME$/design-tools/data-integration.

  2. Create new transformation.

  3. Create new database connection for the transformation:

    • Enter the Connection Name

    • Connection Type: Hypersonic

    • Access: Native (JDBC)

    • Host Name: localhost

    • Database Name: bidemo

    • Port Number: 19001

    • User Name: sa

    • Leave the Password field empty

    star schema
    Figure 2. Database connection