Hi All, After learning about Pentaho's ETL and BI tools, we realized that the world would be a much better place if we had a plugin for Pentaho's ETL tools that pulled data from OpenMRS via web services. Well, we now have a working prototype to show on the dev call in the morning!
The Reporting REST module ( http://svn.openmrs.org/openmrs-modules/reportingrest/trunk/) lets you do this: - GET http://localhost:8018/openmrs18/ws/rest/reporting/cohortdefinition-> lists all available cohort definitions - GET http://localhost:8018/openmrs18/ws/rest/reporting/datasetdefinition-> lists all available data set definitions - GET http://localhost:8018/openmrs18/ws/rest/reporting/dataset/c6f3a3cf-df0e-4733-9d9e-ff0c6cf9629f?cohort=f6f5a60e-72a9-4e7f-8f92-f95d4000ca2a-> evaluates a DSD against a cohort And you get back this: > { > "metadata": { > "columns":[ > {"name":"OpenMRS Identification Number", "label":"OpenMRS > Identification Number","datatype":"java.lang.String"}, > {"name":"gender","label":"gender","datatype":"java.lang.String"}, {"name":"age","label":"age","datatype":"java.lang.Integer"} > ]}, "rows":[ > {"OpenMRS Identification Number":"101-6","age":70,"gender":"M"}, > {"OpenMRS Identification Number":"100-8","age":37,"gender":"M"} > ], > ... > } Then we've got a PDI plugin ( https://github.com/djazayeri/openmrs-contrib-reportingpdiplugin) that you can use with Spoon to hit that web service as an Input step into your ETL. Tune into the dev call to see what we've done so far, and help us brainstorm where to go next. Both these tools are early alpha (at best) but hopefully we can get some pre-releases out soon for people to play around with. -Darius and Ben _________________________________________ To unsubscribe from OpenMRS Developers' mailing list, send an e-mail to [email protected] with "SIGNOFF openmrs-devel-l" in the body (not the subject) of your e-mail. [mailto:[email protected]?body=SIGNOFF%20openmrs-devel-l]
