We have a custom written database application that we use in-house to manage legal cases. it has a scheduling component which allows each user to put scheduled items relating to cases. i am looking for a way to syncronize these entries to each user's outlook calendar (we have exchange 2003).
as we store all scheduled entries in a SQL table, i would like a way to move that data into Exchange - i would think there is a tool that i can put on the exchange server, give it the right admin credentials to access all mailboxes, and that tool can "create" calendar appointments based on the data in the database. perhaps it can run every 10 minutes or so, scan all entries in my database, and replicate them to the proper outlook accounts.
i can add in to my database each users AD username and password if necessary.
If this is not possible, then is there a standard way i can have my application (which is all web-based, asp.net) call up a new schedule window (using the outlook client) with pre-filled in information? for example, if the user is looking at a particular case, they click "new event" and the scheduler just brings up a "new appointment window" from the user's outlook, with the subject field already pre-populated with data (kind of like the way a "mailto" hyperlink can contain the subject/body of an e-mail. then the appointments are saved directly to outlook/exchange.
i'm guessing this might require an outlook plugin or something - anyone know of a good one?
any help in the matter is greatly appreciated!