Home | Contact Us | FAQ | Search & Site Map | Link to Us
Sign In | Join | Other 45 Sites in Network
Home
Discussion GroupsWindows Server 2003Windows 2000Windows NTSmall Business ServerVirtual ServerExchange ServerIISHost Integration ServerISA ServerSMSWSUSMOMWindows Media ServerSecurityCertification
Related Topics
SQL ServerMS WindowsMS OfficePC HardwareMore Topics ...

Windows Server Forum / Exchange Server / Applications / April 2006

Tip: Looking for answers? Try searching our database.

How to Pull Data from Exchange to SQL Server?

Thread view: 
Enable EMail Alerts  Start New Thread
Thread rating: 
Peter D. Jorgensen - 24 Apr 2006 17:53 GMT
Hello everyone.  I'm sure what I'm about to ask is simple, and possibly even
does not make sense for what I want to do, but please bear with me.

The situation is as follows:

My organization is a fitness center that wants to build a "facility hours"
page on our web site with a calendar that displays the times different
facilities are open.  We'd like to do this by pulling the data out of an
Exchange Server shared Calendar folder so that any staff member can update
the hours through Outlook.  This is obviously better than building a
completely new interface from scratch.

My question is how do we pull the data off the Exchange server?  I'm
assuming it needs to be placed into an intermediate storage location such as
SQL before being loaded onto the page, but obviously I'm not really certain
about anything.  Perhaps an Exchange script can do this automatically on
update?

If this is the case, is there a resource someone can point me to to explain
how to get this done?  Perhaps someone's already done it?

Thanks very much!
Henning Krause [MVP] - 24 Apr 2006 19:39 GMT
Hello Peter,

actually, you don't have to store the calendar infos in an Exchange server.

You can search the calendar for the relevant items directly, using WebDAV
for example. See
http://msdn.microsoft.com/library/en-us/e2k3/e2k3/_exch2k_searching_calendar_fol
ders_webdav.asp

for more information on this.

Greetings,
Henning Krause

> Hello everyone.  I'm sure what I'm about to ask is simple, and possibly
> even
[quoted text clipped - 22 lines]
>
> Thanks very much!
Peter D. Jorgensen - 24 Apr 2006 19:51 GMT
Hmm.  I see your point, and that would work, you're right.

However, from a server-load standpoint, I'm not sure we'd want Exchange
queried every time someone loads the hours page on the website, as it is
highly trafficked.

Regardless, you've been most helpful.  Thanks!

> Hello Peter,
>
[quoted text clipped - 34 lines]
> >
> > Thanks very much!
Henning Krause [MVP] - 24 Apr 2006 19:59 GMT
Hello Peter,

if you are using .NET, you can use output caching as well as the caching
infrastructure of ASP.NET.

Greetings,
Henning Krause

> Hmm.  I see your point, and that would work, you're right.
>
[quoted text clipped - 48 lines]
>> >
>> > Thanks very much!
TxKevo - 24 Apr 2006 23:09 GMT
Thanks Hennig!  This information is exactly what I needed for my post
regarding a solution for creating an Exchange read-only web calendar.  We've
pulled info from the server, now we just have to parse it and present it.

Thanks!
K

> Hello Peter,
>
[quoted text clipped - 56 lines]
> >> >
> >> > Thanks very much!
 
Sign In
Join
My Latest Posts
My Monitored Threads
My Blog
My Photo Gallery
My Profile
My Homepage

Start New Thread
Enable EMail Alerts
Rate this Thread



©2009 Advenet LLC   Privacy Policy - Terms of Use
This website includes both content owned or controlled by Advenet as well as content owned or controlled by third parties.