Create a connection to the database

Try Pentaho Data Integration and Analytics

Version
9.3.x
Audience
anonymous
Part Number
MK-95PDIA000-11
Follow these steps to create a connection to the database.
  1. Click New next to the Connection field. You must create a connection to the database.
    The Database Connection window appears.
  2. Provide the settings for connecting to the database.
    Field Setting
    Connection Name Sample Data
    Connection Type Hypersonic
    Host Name localhost
    Database Name sampledata
    Port Number 9001
    User Name pentaho_admin
    Password password (If password does not work, please check with your system administrator.)
  3. Click Test to verify your entries are correct. A success message appears. Click OK.
    Note: If you get an error when testing your connection, ensure that you have provided the correct settings information as described in the table and that the sample database is running. See the Install Pentaho Data Integration and Analytics document for information about how to start the Pentaho Server.
  4. Click OK to exit the Database Connections window.