You just learned how to connect to an RDBMS from PDI. Before beginning to work with the data stored in a database, it would be useful to be familiar with that database or to verify if the database contains all the data that you need. For this, Spoon offers a Database Explorer. There are several ways to access the explorer:
- Right-click on the connection in the Database connections list and select Explore in the contextual menu.
- Click on Explore in the Database Connection window.
- Go to the menu option, Tools | Database | Explore. In the window that shows up, select the database to explore and click on OK.
Whichever way you choose, the following window appears:
Database Explorer
When you open ...
