# Business Intelligence tools with openEHR support **URL:** https://discourse.openehr.org/t/business-intelligence-tools-with-openehr-support/1264 **Category:** Integration **Created:** [1 February 2021 16:30 UTC](https://discourse.openehr.org/t/business-intelligence-tools-with-openehr-support/1264 "2021-02-01T16:30:19Z") **Posts on this page:** 1 **Showing post:** 22

### Author: ![erik.sundvall](https://discourse.openehr.org/user_avatar/discourse.openehr.org/erik.sundvall/32/1961_2.png) [@erik.sundvall](https://discourse.openehr.org/u/erik.sundvall) #### Post date: [11 September 2024 05:25 UTC](https://discourse.openehr.org/t/business-intelligence-tools-with-openehr-support/1264/22 "2024-09-11T05:25:17Z")

I discovered this nice thread now (and refenced it in [RFI: Datalake combined with openEHR CDRs - combined data dictionaries etc - #5 by erik.sundvall](https://discourse.openehr.org/t/rfi-datalake-combined-with-openehr-cdrs-combined-data-dictionaries-etc/5637/5)). > [@yampeku](#): > > One thing I want to try is to embed AQL queries (more like REST calls with AQL queries) in XQuery to extract and transform data. I’d love to have XML data from available openEHR EHR servers, but people seem to be happier with just json 🤣 @yampeku, way back during my PhD thesis work with [LiU-EEE](https://github.com/LiU-IMT/EEE) wa actually did embed AQL inside XQuery and used XQuery to transform results into e.g. HTML pages or KML (Google Earth placemarks), see e.g. - [EEE/src/main/resources/www-file-root/AdHocQuery\_examples/Test at master · LiU-IMT/EEE · GitHub](https://github.com/LiU-IMT/EEE/blob/master/src/main/resources/www-file-root/AdHocQuery_examples/Test) - [EEE/src/main/resources/www-file-root/AdHocQuery\_examples/Composition\_list\_1.xml at master · LiU-IMT/EEE · GitHub](https://github.com/LiU-IMT/EEE/blob/master/src/main/resources/www-file-root/AdHocQuery_examples/Composition_list_1.xml) --- _[View the full topic](https://discourse.openehr.org/t/business-intelligence-tools-with-openehr-support/1264)._