The eHealth DB API is not an API in the traditional sense. It's a set of views and tables that can be accessed directly from the Oracle DB that eHealth utilizes for storing all of its data. The documentation is pretty scarce and limited, but there's a section on the DB API, including some table definitions, in the eHealth Administrator guide.
>From the little bit of poking around I've done, using the DB "API", you can >pull element definition information, and the raw numbers that the eHealth >graphs are generated from. -- Christopher From: John O'Mahony [mailto:[email protected]] Sent: Monday, November 07, 2011 3:30 PM To: spectrum Subject: [spectrum] eHealth DBAPI/SQL question Hi all I have a question on getting data out of eHealth ... possibly using the DB API or SQL. One of our clients wants to pull data from Spectrum and eHealth into a 3rd party reporting solution. The main reason is to consolidate reporting ... for example they would like the data from a Group Availability report (from SRM) and a Group Health report (from eHealth) presented in the same report for their customers. I know how to get the Spectrum data so the question I have is how to get the data - and "analysed data" in particular - from eHealth. For instance how can the data in a Health report be extracted from eHealth for use in a 3rd party tool. Can this be done using the DB API? Or using SQL? Or by some other mechanism? Or maybe it's not possible? Is there a manual that describes how to do this? Having spent a little time looking at this it seems SQL is a likely route so if that is the case I was wondering if anyone had pointers to specific tables that need to be accessed ... and are these documented? Maybe I'm heading down the wrong track on this so any help/experiences will be gratefully received :-) Regards, John * --To unsubscribe from spectrum, send email to [email protected]<mailto:[email protected]> with the body: unsubscribe spectrum [email protected]<mailto:[email protected]> --- To unsubscribe from spectrum, send email to [email protected] with the body: unsubscribe spectrum [email protected]
