Pentaho Data Integration Cookbook Second Edition

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 the following:

• Host name: Domain name or IP address of the database server.
• Database name: The schema or other database identifier.
• Port number: The port the database connects to. Each database has its own default port.
• Username: The username to access the database.
• Password: The password to access the database.

It's recommended that you also have access to the database at the moment of creating a connection. ...