Integrations: APIs to query reports from other applications

geek-maniac wrote on Wednesday, August 13, 2014:

Hi,

Is there a way I can query & send reports to openEMR? I would be interested in integrating this solution into my standalone application. I do not want to go around querying openEMR database. But, some wrappers/integration APIs which can help me to achieve this.

tmccormi wrote on Thursday, August 14, 2014:

We are working on tools to allow the easy setup and use of Pentaho Business Intelligence ( http://www.pentaho.com ) reporting tools with OpenEMR.

Solea ( http://www.soleasolutions.com/ ) is the prime developer on this with MI2 (project design) and IPPF (funding). It’s going to be incredible. We will release a basic OpenEMR ad hoc reporting server as a installable instance and/or a VM to the community.

Gotta say, Solea rocks!

Tony

toddjones wrote on Friday, August 15, 2014:

Tony, I looked into Pentaho 2 years ago and it seems there was an issue with using the open source version. Did you research?

tmccormi wrote on Friday, August 15, 2014:

yes, very fully. There is no issue with the community addition, it is fully open and very functional, but complicated. The basic report designer client is easy to use, but getting full BI for a production system requires a deep understanding of modern ETL methods and Modrian Cubes … that’s what we are prepackaging …

geek-maniac wrote on Monday, August 25, 2014:

actually, what I would be interested in it to have kind of webservices and use the services’ APIs to integrate. Is such thing already exists? If yes, how can I use 'em?

geek-maniac wrote on Monday, August 25, 2014:

actually, what I would be interested in is to have kind of webservices and use the services’ APIs to integrate. Is such thing already exists? If yes, how can I use 'em or what are those services/APIs?

tmccormi wrote on Wednesday, August 27, 2014:

There is nothing specifically like that for reporting. Franky it would be
an unnecessary layer, in my opinion.

The MYSQL databases can be accessed using various connectors such as JDBC
and ODBC, but you still need to write SQL code or build in intermediate
model of the data you are interested in reporting.

There is are 3rd party API for interaction with specific records.

Tony McCormick, CTO

Support: 866-735-0897, Direct: 713-574-6709
My Calendar: http://bit.ly/XznvDo

On Mon, Aug 25, 2014 at 3:23 AM, Geek geek-maniac@users.sf.net wrote:

actually, what I would be interested in is to have kind of webservices and
use the services’ APIs to integrate. Is such thing already exists? If yes,
how can I use 'em?

Integrations: APIs to query reports from other applications
https://sourceforge.net/p/openemr/discussion/202506/thread/b54fc7eb/?limit=25#9b69

Sent from sourceforge.net because you indicated interest in
OpenEMR / Discussion / Developers

To unsubscribe from further messages, please visit
SourceForge.net: Log In to SourceForge.net


Please be aware that e-mail communication can be intercepted in
transmission or misdirected. Please consider communicating any sensitive
information by telephone. The information contained in this message may be
privileged and confidential. If you are NOT the intended recipient, please
notify the sender immediately with a copy to hipaa-security@mrsb-ltd.com and
destroy this message.