Is there any detailed info available regarding pulling real-time data out of Epic for use in QlikView? I’ve seen mention of pulling data from Chronicles and am wondering how that’s achieved and what we should expect…I’ve also seen a mention of web services, is that referring to the Epic-built web services that are available or do you guys provide additional ones?
I have been thinking about heading in this direction too, although I haven't had much time to pursue it yet. I have found some info on InterSystems web site about ODBC linking to Cache databases though.
Thanks Gethyn, that's an interesting idea and I'll take a look. I was looking more for something "out of the box" from Qlik though. We were told real-time data access was available but it was unclear to me how exactly that would happen. I assume there'd have to be some underlying Cache code (or KB_SQL?) regardless of the connection method....
I chatted today with the team at Beaumont about the use cases and options for connecting to real-time data from Epic. Typically, I've seen more of the KB_SQL ODBC being used against a Shadow server for that data that you need intra-daily. Combine that with data from Clarity and/or CDW, and you have a full picture with up to date data.
Chronicles through KB_SQL ODBC has some performance considerations - so you'll want to target properly indexed INIs and items, and leverage data older than 1 day through say Clarity.
Other options include the open APIs (http://open.epic.com) and web services - all depends on your skill sets.
Use cases? I've heard of and seen some with census data and disease surveillance.
What are your use cases? Hoping others with pitch in too.
Have people been doing this more and more? It seems to have stalled. I'd be interested in knowing the use cases others have employed. We'd like to pilot of few efforts (up to date ED info, census, etc). Wondering if there is one settled query that someone could share for us to pilot.
