|
I need to pull the calendar data from exchange into sql. I know exchange uses ESE and I have been unsuccessful finding an easy way to do this.
(comments are locked)
|
|
I tried asking this question a while ago (http://ask.sqlservercentral.com/questions/3452/tsql-to-query-exchange-server-data.html) and got nowhere. I'm afraid its something that simply wont happen, or at least, wont happen simply. There is an ODBC driver for exchange... Or maybe that came with Crystal reports.
Oct 08 '12 at 04:24 PM
sp_lock
Oh... Just seen that I tried to help last time ;-) Never done it before, but powershell could be a reasonable way forward.
Oct 08 '12 at 04:27 PM
sp_lock
So AgendaX queries exchange for the data?
Oct 09 '12 at 02:20 PM
Briley
yes, install and point to your mail server and bingo.
Oct 09 '12 at 02:22 PM
Fatherjack ♦♦
(comments are locked)
|
|
I think the best way to do this is going to be with a third party software. From doing more research I found MX-Sync that is supposed to be able to do this. Has anyone ever tried it? To get just the schedule information we use a product called AgendaX. Its pretty reliable but does have a habit of needing a lot of resources when it scans that Exchange data. Not heard of the product you mention so cant comment
Oct 09 '12 at 02:15 PM
Fatherjack ♦♦
(comments are locked)
|
