Learning Pentaho CTools

Defining data sources for components

We don't want static dashboards, we want to query data to be shown in them. There are two ways to set queries in components. The data sources can be of one of two types, CDA and non-CDA:

• Going the CDA way, you need to define it using the query it's defining, inside the component, an object such as queryDefinition or chartDefiniton depending on the component, with a set of properties:
  • path: This is the path that points to a CDA file. You can make use of the CDA files created as explained in the chapter dedicated to CDA.
  • dataAccessId: This should set the ID of an available data source, also covered in the CDA chapter, that is set in the file we are pointing at.
• Going the non-CDA way, by just using a simple SQL or ...