Qlik Community

QlikView Scripting

Discussion Board for collaboration on QlikView Scripting.

Not applicable

Extracting Data from Exchange server

Hello,

Can anyone recommend a program that enables to extract data from Exchange server (i.e -MS Outlook) - and then to present  the data in a tabular model (directly into QlikView or to an Excel/XML/txt file)

In addition, this task is tended to be repetitive so a schedular option is a must.

Thanx,

Gilad

1 Reply
schlettig
Contributor

Re: Extracting Data from Exchange server

Hi,

four months ago i searched for some kind of connector to automatically read outlook calendar entries and pull them into qlikview, but wasn't able to find one.

But there are some useful technet articles on powershell commands, that you can run i the exchange powershell:

http://technet.microsoft.com/DE-DE/library/1625c25a-7cc9-459c-97ea-281ac421bbce%28EXCHG.141%29.aspx

http://social.technet.microsoft.com/Forums/en-US/exchangesvrclients/thread/2d0c38fb-f22f-43de-987a-4...

with these you can export some data into txt/xls and process them further in qv.

Hope that helps,

Christian

Community Browser