I have an external SQL data source that I would like to include in SharePoint search crawling with a BCS/BDC model. As it stands, SharePoint sees this data independently of the SharePoint site structure. This data is related to specific SPWeb's. What I would like is for SharePoint to correlate this external data with the SPWeb it is associated with so that when end-users search in a SharePoint site, the external data returned in the search results is relative to the SharePoint site they are currently viewing.
Can I accomplish this with a BCS model? If not, what alternative methods could I use to expose this data for search crawling and have it correlated to the SPWeb it belongs to?