| OHDSI Home | Forums | Wiki | Github |
Hello,
I’m interesting in using the OHDSI model as the core data model for delivering some basic BI features (ad-hoc reporting) for an open source EMR as well as developing the required ETLs and some analytics dashboards.
Is anyone out there doing something similar?
Also, does anyone know if the data model is available for mysql?
Best,
Mauricio A.
Mauricio,
MySQL is not a supported datastore for OMOP. If you need an open source tool, Postgres is supported.
We’ve been experimenting with other BI tools against the OMOP model, such as Tableau. I just checked them out at HIMSS and have been impressed with eace of use and their focus on healthcare (http://www.tableau.com/solutions/healthcare-analytics).
Bill
Mauricio,
If you have development experience / developers you work with, I think there would certainly be folks interested in extending OHDSI software tools to meet BI objectives. While not part of the core OHDSI mission, this could result in some valuable contributions back to the platform.
Thanks,
Jon
@jon_duke @wstephens Thank you very much for the response.
I MySQLized the data model and comitted the changes to a fork in my github account: https://github.com/rmalarc/CommonDataModel/tree/master/MySQL. I’m not sure of how this community handles code contributions. In any event, I hope someone finds it useful.
@jon_duke, I do have development experience and will be more than glad to contribute to the project. As mentioned, I’m interested in developing and making available whatever I can in order to connect openemr to OHDSI with the objective of delivering some BI & analytics functionality.
On a somewhat related note, is anyone working on a fhir/ohdsi gateway/etl?
Best,
Mauricio A.
I am interested in a fhir/ohdsi gateway/etl. I am going to use https://github.com/fhirbase/fhirbase as transaction databse and expose fhir interface for exchanging data between external system or special purpose CDR like OHDSI
@wanghaisheng this FHIRBase is cool stuff!
I really don’t feel like writing an ETL that the only thing it does is transform data from my source system into the ohdsi model.
I like the idea of using FHIRBase as a staging/middleware between the source system and OHDSI. In my case, it would allow me to enable FHIR connectivity via their FHIRPlace server in addition to the OHDSI stuff. I can kill many birds with one stone!!!
Are you building the FHIRBase to OHDSI gateway? It sounds like a worthwhile cause!!!
Best,
no . I have not started yet.we can talk to each other about this more
Hi Maurucio -
tools like Tableau have Postgres connectors and I think the freemium versions of Qlik/Tableau have support for Tableau.
We can share some cubes that have been built on the OMOP vocabulary that we have found useful. These however have only satisfied very simple aggregations of the data.
We also find BI tools quite useful for prototyping ideas and simply visualising and understanding outputs of complex queries.
Sajan