Reporting Web Services and Pentaho Integration Enhancements
- Burke Mamlin
- Michael Downey
- Lluis Martinez
Primary mentor | @Lluis Martinez |
Backup mentor | TBD |
Assigned to | @Sashrika Waidyarathna |
Abstract
Reporting 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.
Project Champions
TBD
Objectives
Proposed improvements
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
Extra Credit
Resources
Reporting REST web services module