How to pull data from Meditech to Qlikview?

[bhavvibudagam]

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.

[Anonymous]

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]

Hi Matt,

Thanks for your reply.

Can you please attach any sample file if you have.

[Anonymous · Accepted solution]

Hi Bhavvi,

Please see attached