"THOMASB" <thomas.bost***@gmail.com> wrote in message
news:1190087882.728447.144290@d55g2000hsg.googlegroups.com...
> Hi! Group
>
> Need to extract data from Exchange Server and loading it in a
> datawarehouse (Microsoft Analysis service). The datamart will also
> keep information from a telephone switch board and some other stuff
> from diverse system. The goal is to get a consolidated view of what
> people are doing during the day.
>
>
> I know there different API:s to use and in some cases it's possible
> to
> query the store with SQL.
>
>
> Need to know:
> Who is the organizer of a meeting?
> Who attended?
> When did it start?
> When did it ended?
> What was the subject?
>
>
> But, just to make a first pilot I'm wondering if there is any
> administration tool that can dump calendar/appointment information to
> a text file. In that case I can use an ETL tool and quickly import
> the
> data to a relational database.
>
>
> I guess there are different approaches to this and would appreciate
> your thoughts in this matter.
>
>
> Cheers
> Thomas
>