A useful feature we can get through in the Pentaho BA Platform is the ability to define a data source as the output of a query. This can be achieved as a result of the CSV load operation or, at the very end, as the result of accessing a plain table. Let's show you how to do this by using a CSV file as the input for our virtual data mart, accessed through this interesting kind of new data source.
The following steps detail how we can use the wizard to define a new Data Source, starting from a CSV file:
From the Home perspective, click on the Manage Data Source button; the Data Sources dialog box appears.
An alternative way to open the Data Sources dialog box is from the main menu by navigating to File | Manage Data Sources.
The Data Source Types combobox drops down and shows the various types of data sources we can define. From the list, select Data Source Wizard.
The Data Source Wizard dialog box opens. Follow all of the...