topic Re: Pulling real-time data from Epic in Archived Groups

Pulling real-time data from Epic

Tue, 22 Jul 2025 14:29:37 GMT

Hi folks,

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?

Thanks!,

Brett

Re: Pulling real-time data from Epic

Gethyn — Thu, 18 Jun 2015 08:36:15 GMT

Hi Brett,

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.

http://docs.intersystems.com/documentation/cache/20141/pdfs/BGOD.pdf

I hope this is useful to you.

Gethyn.

Re: Pulling real-time data from Epic

Thu, 18 Jun 2015 13:22:35 GMT

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....

Re: Pulling real-time data from Epic

joe_warbington — Fri, 26 Jun 2015 23:00:03 GMT

Hi Brett,

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.

Re: Pulling real-time data from Epic

mcafee44 — Thu, 01 Nov 2018 15:11:19 GMT

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.

CMc