Summary
In this chapter, you learnt everything Pentaho Report Designer can do with data sources, discovering all the available types and their specific features. You started with an introduction to how a data source looks in the user interface and how the fields are used in the layout of the report. Then you moved on to discover how to manage all the possible types of data sources using Report Designer, finding out all about:
- The JDBC data source
- The metadata data source
- The MongoDB data source
- The Pentaho Data Integration transformation data source
- The OLAP data source in various versions (legacy and generic, normalized and denormalized, standard, and custom)
- The XML data source
- The table data source
- The advanced data sources (scriptable, external, sequence generator, and OpenERP)
- The Pentaho community data access data source
Now that you have read this chapter, you should feel comfortable with all the ways Pentaho Report Designer offers to connect to a source. This is the very first step to go through...