Time for action – creating a PDI repository

To create a repository, follow these steps:

1. Open the MySQL command-line client.
2. In the command window, type the following command:

   CREATE DATABASE PDI_REPO;

3. Open Spoon.
4. Unless a repository dialog appears, open the repository dialog from the Tools | Repository | Connect... menu.
5. Click on the plus icon to create a new repository. A window with two options appears: Select the Kettle database repository option, as shown in the following screenshot:
   
6. The Repository information dialog shows up. Click on New to create a new database connection.
7. The database connection window appears. Define a connection to the database you have just created and give the connection the name PDI_REPO_CONN.

   Tip

   In order to create the database connection, refer to the Time for Action – creating a connection to the Steel Wheels database recipe in Chapter 8, Working with Databases.

8. Test the connection to see that it is properly configured.
9. Click on OK to close the database...