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.
- 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?