AbstractReporting REST web services exposes the reporting module's definitions via REST web services. We would like to leverage this to make it easier for people to use business intelligence tools, like Pentaho, with OpenMRS reporting data.
Actually there is a working prototype of a Pentaho Data Integration plugin for Eclipse, that pulls data from OpenMRS via the reporting REST web services. This plugin uses Eclipse's SWT (Standard Widget Toolkit) for the user interface.
Support for listing and evaluating all different kinds of definitions (currently only cohort definition and dataset definition are supported)
- Support for evaluating an entire report
- Optionally, to have the ability to queue report requests
The plugin that allows Kettle (aka Pentaho Data Integration) to consume reporting REST services to apply transformations can be improved as follows:
- User interface should support different types of parameters
- Add support for more kinds of queries to the reporting REST services
Reporting REST web services module
Writing a Pentaho Kettle plugin
PDI plugin for OpenMRS