Calendar View for Multiple Databases

I would like to have a calendar view that displays data from different databases (vacation days from our HR database, scheduled jobs from our Implementation database, etc.) The two ideas that were brought up for this were: 1. Create a calendar view in one of these databases. Somehow have the schedule data from each of the separate databases appear as entries in this calendar view.

  1. Create a separate database. Each save of data in the other databases (HR, Implementation, etc.) will somehow insert the appropriate scheduling data into this new database. Then we will just have a calendar view in this new database to display its own records.

Are either of these possible? If so, can you give me an idea of how? Or is there a better way?

Subject: Calendar View for Multiple Databases

There is posting in the Sandbox which is a calendar which pulls in the details from different people’s calendars’. It also keeps enires in synch when one is deleted/rescheduled.

Search for ‘Shared Calendar’

Although this has been designed to work from mail files - you can easily modify the agent to work from other forms in HR Dbs.

HTH,

Ranjan