Before interacting with a database in PDI, you need to prepare the environment. In the next sections, you will learn to create a connection to a database and explore the database from within Spoon.
For demonstration purposes, we will work with PostgreSQL, but with minor changes, you should be able to reproduce the same exercises with any other RDBMS engine. Also, the examples will be based on Pagila. Pagila is the PostgreSQL version of the Sakila database and represents the business processes of a DVD rental store.
PDI has the ability to connect to both commercial RDBMS such as Oracle or MS SQL Server, and free RDBMS such as MySQL or PostgreSQL. In order to interact with a particular database, you have to define a connection to it. A PDI database connection describes all the parameters needed to connect PDI to a database. To create a connection, you must give the connection a name and at...