topic Re: How to pull data from Meditech to Qlikview? in Healthcare

How to pull data from Meditech to Qlikview?

bhavvibudagam — Wed, 28 Aug 2024 16:07:25 GMT

Hi,

Can any one Please let me know "how to pull the data from Meditech Data Repository Database Model" into Qlikview/Qliksense.

Please explain how to pull the data step by step.

1)In which format you can pull the data viz., excel, csv etc.?

2) can the pulling of the data be automated i.e. regular intervals, say, daily?

3) which API calls to use to retrieve data directly out of 'Meditech'?

4) Is there any connector already available to pull into QlikView?

Thanks.

Anonymous — Fri, 16 Dec 2016 23:57:31 GMT

Hi Bhavvi,

You can either write a query against the data repository (or better yet a stored procedure) and build it into your load script, like so:

MeditechAdHocExample:

SQL SELECT ,,,

;

Meditech StoredProcExample:

SQL exec my_proc;

You can then schedule a reload of the QVW through the Qlik Management Console.

bhavvibudagam — Fri, 06 Jan 2017 11:31:08 GMT

Hi Matt,

Thanks for your reply.

Can you please attach any sample file if you have.

Anonymous — Fri, 06 Jan 2017 21:35:25 GMT

Hi Bhavvi,

Please see attached