How to Connect Pentaho to a database

Connecting to a database

If you intend to work with a database, either reading, writing, looking up data, and so on, the
first thing you will have to do is to create a connection to that database. This recipe will teach
you how to do this.
Getting ready
In order to create the connection, you will need to know the connection settings. At least you

will need:
f Host Name: Domain name or IP address of the database server.
f Port Number
f User Name
f Password

It's recommended that you also have access to the database at the moment of creating the
connection.
How to do it...
1. Open Spoon and create a new transformation.
2. Select the View option that appears in the upper-left corner of the screen, right-click
the Database connections option, and select New. The Database Connection dialog
window appears.
3. Under Connection Type, select the database engine that matches your DBMS.
7
Working with Databases
4. Fill the Settings options and give the connection a name by typing it in the
Connection Name: textbox. Your window should look like this:
5. Press the Test button. A message should appear informing you that the connection to

your database is OK.