As you were told in the first chapter, there is a Pentaho Demo that includes data for a fictional store named Steel Wheels and you can download it from the Internet. This data is stored in a database that is going to be the starting point for you to learn how to work with databases in PDI.Before beginning to work on databases, let's briefly introduce the Steel Wheels database along with some database definitions.
A relational database is a collection of items stored in tables. Typically, all items stored in a table belong to a particular type of data. The following table lists some of the tables in the Steel Wheels database:
Table |
Content |
---|---|
|
Steel Wheels' customers |
|
Steel Wheels' employees |
|
Products sold by Steel Wheels |
|
Steel Wheels' offices |
|
Information about sales orders |
|
Details about the sales orders |
The items stored in the tables represent an entity or a concept...