Qlik Community

Qlik Healthcare User Group

This group is for healthcare organizations, partners, and Qlik Healthcare staff to collaborate and share insights.

Highlighted
bhavvibudagam
Contributor II

How to pull data from Meditech to Qlikview?

Hi,

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

https://www.meditech2.com/prdr/Tables/DBM_s61matdb/system_Mat.htm


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.

Tags (1)
1 Solution

Accepted Solutions
mattblanchette
Visitor

Re: How to pull data from Meditech to Qlikview?

Hi Bhavvi,

Please see attached

   

 

3 Replies
mattblanchette
Visitor

Re: How to pull data from Meditech to Qlikview?

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
Contributor II

Re: How to pull data from Meditech to Qlikview?

Hi Matt,

Thanks for your reply.

Can you please attach any sample file if you have.

mattblanchette
Visitor

Re: How to pull data from Meditech to Qlikview?

Hi Bhavvi,

Please see attached