I have a set of external data that I'll be fetching through SQL Server queries. I'd like to bring it in to a MOSS 2007 site. So far so good, I've been reading about BDC, and I'm encouraged.
The problem is that I need it to display in a calendar. The data are currently entered manually into a SharePoint Calendar list and viewed in Calendar view. The goal here is to create a "live" version of that list.
Unfortunately, I don't yet see a no-code way to do this in MOSS 2007. I see that we have External Lists in SharePoint 2010, and I presume that I could display one in a Calendar view, but I'm not seeing how to do this in MOSS at this time.
Has anyone done something like this before?